File save As

[Guest]

I’ve reviewed the site for File Save as questions. They all seem to revolve
around the approach that requires the line: Application.DisplayAlerts =
False. However, In a Macro I want to save the file, but I would like the
“Save As dialog box†in excel to open up so the user can put the file in any
directory they want it in. How would you do this? I'm sure it is esay but
I can't figure it out! By the way, the Application.DisplayAlerts = True
doesn’t work! Any help would be appreciated!

 

[Guest]

I've got this code and it works but I need some help with the options:
FileSaveName = Application.GetSaveAsFilename(fname, filefilter:="Excel Files
(*.xls),*.xls")

 

[Dave Peterson]

You mean the .saveas options?

How about looking in VBA's help--or asking about a specific option?