Dave: Question about "Save as" macro
Posted by A.R. on May 10, 2001 10:17 AM
Your method worked to the message you posted at http://mrexcel.com/wwwboard/messages/16439.html, but I want the macro to go to a particular location every time where the file is going to be saved. For example, the "Save as" dialog box comes up and I verify or change the filename and the macro saves the file to the first location in C drive in the "Spreadsheet folder". The "Save as" dialog comes up again and I again verify or change the filename and the macro saves the file in the second location in G drive in the "data" folder. The macro continues for the last location. This way I don't have to navigate to a particular drive/folder every time I save a file. Thank you.