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

Thanks Bob!

"Bob Phillips" wrote:

Try

Application.Quit

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anthony" wrote in message
...
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