Prompt user for a filename
Application.Dialogs(xlDialogSaveAs).Show "C:\Myfile.xls"
HTH
"J S" wrote:
I want to create an excel macro that display the saveas dialog box to the
user, how do I do that?
i.e. I want the user to save the current document, but when I use
thisworkbook.save or thisworkbook.saveas excel does NOT display the saveas
dialog box where the user can select the filename and directory he wants to
save to.
-J
|