MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Can VB display the "Save As" box?


Posted by Tom Urtis on April 19, 2001 10:05 PM

For something fun, I was thinking of inserting a yes/no message box at the end of some existing VB code to ask the user if they are ready now to save this file as another file name. If the response off that message box question is yes (6), does VB code exist that can cause the familiar Save As box to appear, just as if the user clicked File > Save As. I could just use an OK info box to remind the user that it's time to save as, but having the Save As box pop up would be a kicker if possible. Thanks. Tom


Posted by g-man on April 19, 2001 10:28 PM

Tom,

Try this:

Sub Save_As()
Application.Dialogs(xlDialogSaveAs).Show
End Sub


Posted by Tom Urtis on April 19, 2001 10:40 PM

Thanks g-man!!

Hey g-man, that was perfect...thank you!!


Posted by A.R. on April 20, 2001 11:38 AM

Save As macro in Excel 97 & 5.0/95 format

I have a macro that saves a file in three different locations in the Excel 97 & 5.0/95 format. I want to have the "Save As" box displayed with the Excel 97 & 5.0/95 format already set so I can verify/change the file name before I save it in the three locations.