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...
What kind of files would be downloaded?
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.
Power Query doesn't download files. It could take content from other files, transform it, combine. But result will be loaded into the same file from which you run the query.
