View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anthony Anthony is offline
external usenet poster
 
Posts: 275
Default workbook close macro

Hi,
excuse my naivety but I'm a bit of a novice :)
Very simply I want a macro to close my excel application, but I can only get
it to close the open workbook, here is what I have...

Sub before_close()
Application.ActiveWorkbook.Save
Workbooks("Book1").Close
End Sub

can U help?
than ks