advanced+excel+courses - Saving a Workbook / calling the Save As menu | Excel forum

Resolved · Low Priority · Version Standard

Tue 6 Nov 2007, 14:08 Delegate Candace said...

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

Thu 8 Nov 2007, 13:24 Trainer Anthony said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Viewing two Excel 2010 Workbooks at the same time

Did you know you can view two Excel 2010 workbooks side by side? Very useful when comparing data without constantly having to go back and forth!

1) Open both Excel workbooks
2) Select Window then select Compare Side by Side with (Spreadsheet 2)
3) When you have finished, select Window again and click Close Side by Side

View all Excel hints and tips