I have been using Excel VBA to navigate through a webpage. Using VBA, I am able to login to a site and navigate to the correct page and then using execScript, launch the save file window, but I am having trouble finding the code to hit save file as and rename the file.
The VBA code that I use which launches the save file window is below. I don't have a direct link to the file at all and have to use this execScript to launch the file.
It brings up the window, Do you want to open or save R3668_2012211422.csv" from xxxxxxx.com ? Then the options "Open", "Save" and "Cancel". (I can click on the arrow next to save to bring up the save as option as well)
I am having trouble figuring out how to use Excel VBA code to click save as and then type in the file name I want to save it as, most of the information I can find online requires a direct link to the file.
Let me know if you need more information or have any questions about what I am trying to do.
Thanks so much.