VBA to Download documents using URLs & Save As to folder

[Kenneth Hobs]

Unfortunately, snips like that don't help me help you.

As I said, you have two solution paths.
1. IE object
2. SendKeys()

If you can view the source code's text when you click the link, can you see the value Reports File.xlsx and the path to it blocked out? If you can, code can get that and use the API or Workbooks.Open methods to get and save the file. My suspicion is that they used a security method to hide such details.

If it was just one file, a SendKeys() might have an off chance of working. For more than one file, SendKeys() will likely not be of much help. Of course a hybrid of the two methods might have a remote chance of working.

I did project many years ago where I had to get all items in a web listbox and then chose an item by code. As I explained, one has to get source code to know if that kind of thing is even possible.

If you can learn how I coded the #9 post's example, you might be able to discover a like solution for yourself. Try to work through doing that example with only the link known, mail.yahoo.com. Of course if you cheat and look at the solution example, I won't tell. In fact I recommend stealing, err, using the shown solution but in steps. Think, how would I enter my username, click Next button, enter my password, and click Ok button to login. As you will see in code, the Next button loads another website. As such, it has to wait until it loads before interacting with it further. Loops often work but I added an extra step where it waits for the new url to <> the first url. Sometimes, one just has to add and Application.Wait.




Feel free to PM me for some private conversation.