save Changes and close book
 

Hi there,

I use the personal VB workbook to run a series of macros. They run a
macro on the active workbook. At the end of the macros I need to tell
the Macro within the Personal workbook to close the active workbook on
which it has just run the macros... , anyone know the VB for that...???

Regards

D

*** Sent via Developersdex http://www.developersdex.com ***

save Changes and close book
 

ActiveWorkbook.Close SaveChanges:=True

--
Regards,
Tom Ogilvy


"Darin Kramer" wrote:



Hi there,

I use the personal VB workbook to run a series of macros. They run a
macro on the active workbook. At the end of the macros I need to tell
the Macro within the Personal workbook to close the active workbook on
which it has just run the macros... , anyone know the VB for that...???

Regards

D

*** Sent via Developersdex http://www.developersdex.com ***