Candace has attended:
Excel VBA Intro Intermediate course
Saving a Workbook / calling the Save As menu
Hi,
I have created a spreadsheet that will be used by the business units for data capture and I have added a "save details" button to the spreadsheet that uses the "Active.WorkBook.Save" functionality.
I have been requested to change this so that the Save As menu is shown. This should allow the user to select where they would like to save the workbook and what they what they would like to call it.
Do you have any advice on how to do this? I have tried the ActiveWorkbook.SaveCopyAs but this also does not seem to work.
Thanks,
Candace
RE: Saving a Workbook / calling the Save As menu
Hi Candace:
One thing a lot of people ignore is the fact that you can use Excel's built-in Dialog Boxes within your code. If you want to allow users to select where they save a file, you can give them the 'Save As' box with this code:
Application.Dialogs(xlDialogSaveAs).Show
Hope this helps. Post back if you need more assistance.
Regards,
Tony Gay
