creating a macro for a "Save As" box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I create a macro that will display the "Save As" dialog box? When I
create it using the the Macro Wizard, it doesn't bring up the "Save As"
window. It just saves at the previous location and name. My attempts to
alter the VBA code have failed.
 
hi,
add this to the macro wizard code

Application.Dialogs(xlDialogSaveAs).Show

regards
FSt1
 
Thank you FSt1! It worked perfectly and completed the final suggestion from
my manager for a spreadsheet project.
 
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

Excel 2007: Saving a file with a Macro 1
Macro (SAVE AS) 1
Macro to save as 2
Excel 2003 save as .XLSX 10
How to make a .XLTM template file default to save as .XLSM type? 1
Excel 2007: Help creating a macro that will run Solver? 3
Saving a workbook step in a Macro 3
VBA code for "Save as PDF" 1

Back
Top