Excel 2003 - A macro to exit excel

A

Alan_Malawi

Hi I need to create a macro that will first do a "save as" picking up a file
name from a cell on the worksheet and then will exit excel
 
D

David Billigmeier

Chage the reference of [a1] to the cell on your worksheet that has the name
you want to save as:

Sub SaveAndClose()
ActiveWorkbook.SaveAs Filename:= _
"C:\myDirectory\" & [a1] & ".xls"
ActiveWorkbook.Close
End Sub
 

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

Close all without saving and exit without prompts 8
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Macro to Insert Current Date into cell - Macro to "Save As" 4
Save As Macro 2
Disable X button on excel 6
Help with a macro 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Help with a Macro 2

Top