MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Calling SaveAs dialogue box from UserForm or Macro


Posted by Tom D on September 04, 2001 9:01 PM

Using the UserForm, some data gets entered, and the file then needs to be copied under a new name. How do I have the program invoke the saveas dialogue box?


Posted by Tom Urtis on September 04, 2001 9:37 PM

The line of code is:

Application.Dialogs(xlDialogSaveAs).Show

Tom Urtis