MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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, 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.

Posted by Dave Hawley on May 10, 2001 10:38 AM


Not too sure I understand you, but you may be after the GetSaveAsFilename. This will display the Standard Save As dialog and return a String of the File name and Path chosen without saving.+

You could place the Drives you wanted in some cells on a Worksheet and Loop though them and use it as the Drive.

Sub ShowSaveAs()
'Written by OzGrid Business Applications
Dim i As Integer
Dim sSave As String
For i = 1 To 3
sSave = Application.GetSaveAsFilename
MsgBox sSave
Next i


End Sub

OzGrid Business Applications