Automate in Excel hyperlinks which allow files download

Support
#1

At the bottom of this page, there are 3 hyperlkins which, when we click them, allow the download of an Excel file.

Is it possible to have in Excel rows where we copy this hyperlink... and a macro that will click on each hyperlink and therefore the three files will be downloaded one after the other.

I have a Spreadheet with 10000 hyperlinks and would love to know how to automate the clicking, without having to have to click 10 000 times to download 10 000 small excel files.

Thanks for your help !!

#2

Have you tried the DownloadFile function?

#3

I found a way with a very basic VBA function but now they limit me at 500 downloads per month... I did not know the downloadfile function. Where can I find it in SEOTOOLSFOREXCEL ? Thanks !!

#4

Look at the link in my previous post. It's a formula available under the HTTP menu, or directly:
=DownloadFile(arguments...)

#5

Hello,

I am using this function, but it is giving me this error:
"An exception occurred during a WebClient Request."

here's the function: =DownloadFile(C2,"D:\NARS\Product Images",B2)

DLFile_error2
DLFile_error21212×328 98.9 KB

What could I be doing wrong here? Any help would be appreciated! :slight_smile:

#6

Can you provide the image URL and the image name in cell B2?