I am trying to automatically download some pdfs off of our companies website and unfortunately the company has it set up in such a way that the only way to me to automate the download process, I have to write VBA code to go through the save as file box method. In the screenshot below, does anyone know how to write code to change the "C:\Users\srn5\Downloads" to another path say "M:\StatementDocs\2013\" ?
Also, does anyone know how to rename the file in that box from "Deca_Written_statement" to lets say "Deca"?
SaveAs.jpg
Bookmarks