I will have a second try to see if I can manage to click with VBA the OK button in the Save As dialog box from Internet Explorer.
Now I have a message box appearing to stop the code for a moment while I choose the file to download, choose the folder where to save to and click the OK button.
It would be great if I could include in the macro code a part where once the message box appears, it will wait until the Internet Explorer popup asking where to save and click save.
It should always use the same folder to save the files.
1- is there a way to make excel wait for Internet Explorer to pop up the dialog box?
2- tell it where to save
3- click the save button and continue with the code.
I found some code google-ing, but these are specific for a page and and not that easy for me to understand.