Open 'Save As' dialogue box using Macro

Z

Zainuddin Zakaria

I have chosen to hide the Menu Bar.
How do I let users save their work?

I plan to create a button and assign a MACRO to it so that users can click
and 'SAVE AS' their file by first typing in the file name. Can someone come
out with a macro command for this?

Also a macro command to EXIT button (without saving the file).

Thank you so much.


Zainuddin Z
 
A

ankur

Hi Zainuddin,

Try this...

Sub Test()
fileSaveName = Application.GetSaveAsFilename(fileFilter:="Excel Files
(*.xls), *.xls")
If fileSaveName = False Then
End
Else
ActiveSheet.SaveAs Filename:=fileSaveName
End If
End Sub

Regards
Ankur Kanchan
www.xlmacros.com
 

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

Similar Threads

Macro command to turn on File Menu 6
Macro Command to Exit 5
Saving just one of the worksheets to a disket 2
Hiding Menu Bar With Macro Command 4
How to record a macro within a macro 9
Save Macro enabled WB as w/o macro 13
Save-As Macro 2
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4

Top