The workbook with the macro is refered to as THISWORKBOOK. So you can
use

Thisworkbook.close savechanges:=True
or
Thisworkbook.close savechanges:=True


This will leave the excel application running

To close the application and the workbook first save the file then quit
the application


Thisworkbook.Save
Thisworkbook.quit


You can't close the application if you son't want to save the file.


If you are referencing another workbook I always recommend giving all
workbook a variable name on opening.


set bk = workbooks.open(filename:="book1.xls")

The using bk to close the workbooks

bk.save
bk.close savechanges:=true
thisworkbook.quit


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=165091

Microsoft Office Help