File save As
 

Ive 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
doesnt work! Any help would be appreciated!

File save As
 

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


"Mathew" wrote:

Ive 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
doesnt work! Any help would be appreciated!

File save As
 

You mean the .saveas options?

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

Mathew wrote:

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

"Mathew" wrote:

Ive 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
doesnt work! Any help would be appreciated!

--

Dave Peterson