File save As

M

Mathew

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!
 
M

Mathew

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")
 
D

Dave Peterson

You mean the .saveas options?

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

Ask a Question

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.

Ask a Question

Top