Hi Kenneth,

Maybe I haven't explained properly - the list of URLs I have are in a list in an excel workbook so I can click on each like a hyperlink to run a specific report, I don't have to click the link provided in our company website although I must be signed into our company's security section.

In other words, the macro only needs to click a hyperlink in the list in excel, wait for the 'save' window to appear, click save (sendkeys?), save the file as the name listed next to the hyperlink to specific folder, replace old file, close, ......click next in list and repeat until list ends

Maybe this will make a difference?