Question Locked

Excel07- autodownload from hyperlink

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a list of hyperlinks in an excel file (40-50) that I have to click on daily. These take me to individual daily reports that are saved as pdf files. I then save each and every file in a folder manually (as in go to file-->save as--> etc). Since I already have the links, is there a way to let excel "click" on the links automatically and save the files on its own? Can I code this in a macro?

I might add that there is no user-id/password combination required for opening the pdf files.

Thanks,

1 reply

This discussion is closed to new replies.