Hi There,

I have a spreadsheet containing a number of hyperlinks in column F. These link to the "Download CSV" function of a particular website. In column G I have listed out the filenames that I would like to use when saving the files.


I have to download these on a weekly basis so I would like to automate the process if possible.

When I click on the links as they are it downloads a read-only file that seems to be temporary - it does not appear in my downloads folder.

I have tried tweaking a few bits of code that I have found online with no success so I went through the motions of recording a macro for the first few lines and trying to get the code that way.

Here is what I have so far

Please Login or Register  to view this content.
The problem seems to be with the saving - If anyone could offer any suggestions on how I could get this to work that would be great!!

Thanks,

Carrie