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,
