View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John B[_3_] John B[_3_] is offline
external usenet poster
 
Posts: 11
Default Closed Excel but Vba project remained

I have a sub that opens several workbooks (with macros embedded).
at the end of the sub I have

workbooks("book1.xls").close true ' to close all but 1 workbook

the workbooks are closed but if I open vba window, I can still see the vba
projects.

if I do debug.print workbooks(2).name I get out of range error -- which i
assume the object no longer exists ...

how can i truely close workbooks?

application.quit?

I want to close all but 1 workbook.