Thread: save Changes and close book
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default 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 ***

Reply With QuoteReply With Quote