I have a macro that I am trying to create that will navigate a web site to retrieve information in the form of a file download (excel file). I have managed to get it to work well up to the point where I have to save a file into a specific folder. The macro does fine in bringing up the "File Download" dialog box with a default filename in a default location that was determined by the previous download within Internet Explorer. However, I can't seem to figure out how to:
1) change the default name to something else more meaningful (ie, with todays date or some identifying numerical sequence appended, etc.), and
2) select a specific folder where the file is saved, regardless of what the current default file save location happens to be when the macro is run.
any ideas?
thanks