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

Resolved · Low Priority · Version Standard

Saving a Workbook / calling the Save As menu

Candace has attended:
Excel VBA course

by - delegate Candace [2 posts] (2007 Nov 6 Tue, 14:08) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu	Bayswater	3	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	3	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
2007	2008 Dec 16 Tue	Bayswater	6	book now	£207	£215
Full Schedule: See all 109 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Saving a Workbook / calling the Save As menu

by - trainer Anthony [5 posts] (2007 Nov 8 Thu, 13:24) Reply

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

· Advanced level training: Microsoft Excel and the Web
· How to Create Better Excel Spreadsheets: Part Three
· Creating Charts with Excel
· Microsoft Excel Training: Not Just for Newbies Anymore
· Tips to Facilitate Printing of Excel worksheets

Excel tip:

Adjusting the Elevation and Rotation in a 3-D Chart

For any 3-D chart you create, you can adjust the chart’s elevation and rotation to make it more visually appealing. To do this, click the chart and select 3-D View from the Chart menu. The 3-D View dialog box will appear.

The elevation is the height you view the chart from. Click the arrows to the left of the preview picture or enter a value (something between 90 and –90) in the Elevation field to adjust the elevation.

Rotation is the rotation of the plot area around the z-axis. Click the arrows below the preview picture or enter a value (something between 0 and 360) in the Rotation field to adjust the rotation

View all Excel hints and tips

Rate this page: