Macro to save & close

pp2002 · May 20th, 2002, 02:05 AM

Hello,

I'm trying to include a macro on a workbook that saves & closes it - but I'm having trouble.

Any suggestions?

Thanks
Paul

Audiojoe · May 20th, 2002, 02:14 AM

The code would be:

Sub Saveandclose()

ActiveWorkbook.Save
ActiveWorkbook.Close

End Sub

Just paste it into a module in VBA

Audiojoe

[ This Message was edited by: Audiojoe on 2002-05-20 01:15 ]

Mudface · May 20th, 2002, 02:22 AM

Or: -

ActiveWorkbook.Close True

To save it under it's current filename.

Or: -

ActiveWorkbook.Close True, "C:My DocumentsBook1.xls"

replacing the path and filename with where you want it saved and what you want it called.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 02:05 AM	#1
pp2002 New Member Join Date: May 2002 Location: Wrexham, North Wales,UK Posts: 10	Hello, I'm trying to include a macro on a workbook that saves & closes it - but I'm having trouble. Any suggestions? Thanks Paul

May 20th, 2002, 02:14 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	The code would be: Sub Saveandclose() ActiveWorkbook.Save ActiveWorkbook.Close End Sub Just paste it into a module in VBA Audiojoe [ This Message was edited by: Audiojoe on 2002-05-20 01:15 ]

May 20th, 2002, 02:22 AM	#3
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Or: - ActiveWorkbook.Close True To save it under it's current filename. Or: - ActiveWorkbook.Close True, "C:My DocumentsBook1.xls" replacing the path and filename with where you want it saved and what you want it called.