Forum Discussion
Downloading multiple files from excel hyperlinks
Dear experts, Could you please share any Excel formula or PQ solution to download multiple files from excel hyperlinks. Each cell have one hyperlink and there are total > 100 h...
All are *.xlsx files or some excel files only, I know that there must be an option in Power Query
Br,
Anupam
Maybe with Python. I have some stock code that just needs the list of URLs. I'd have to test it before making a recommendation.
The concern with running vba to download files is the anti-virus. From past experience, I know some anti-virus software will stop Excel cold if it attemps to run code to batch download.