J
John Keith
Is it possible to open the file save as dialog window and change the
name of the file from the current name?
John Keith
(e-mail address removed)
name of the file from the current name?
John Keith
(e-mail address removed)
Hi John,
Is this what you are looking for?
Application.Dialogs(xlDialogSaveAs).Show
this should save it to whatever name you give it, if that's what you want.
you'll need to supply the path, too.
activeworkbook.SaveAs "YourFilename.xls"
I don't understand John.
Your question was "Is it possible to open the file save as dialog window and
change the name of the file from the current name?"
You can change the file name in the dialog box as well select the location
for the file.
I don't want the user to fill in the name of the file. I want the
macro to fill in the name of the file but I want the user to select
the path to where that file will be saved.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.