Save As help

  • Thread starter Thread starter Brad E
  • Start date Start date
B

Brad E

I have a macro assigned to a button. With this macro, I
want to bring up the "Save As" dialog box just as if the
user was to go to File > Save As.

Is there a way to do this?
Thanks, Brad E.
 
Hi
have a look at the GetSaveAsFilename method in the VBA help
 
you could assign the code

Savefile = Application.GetSaveAsFilename

ActiveWorkbook.SaveAs Savefile

HTH

Davi
 
Hi,

FileName = Application.GetSaveAsFilename
ActiveWorkbook.SaveAs FileName


Paul
 
You must log in or register to reply here.

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

VBA Save As problem with file that already exist 2
Saving a Workbook cause's Error's 7
copy and save as csv 4
PowerPoint High Resolution Images from PowerPoint 0
MACRO TO POP UP SAVE AS WINDOW 1
SAVE AS MACRO 5
SAVE AS/ GET SAVE AS/ 1
Disable save/saveas dialog box upon closing 11

Back
Top