View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default Closed Excel but Vba project remained

I've seen a few posts that blame Google's Desktop Search utility. But I had the
problem before I used that search utility.

But in my case, it just seemed like an irritant. Those ghost projects never
caused me any problems.

I just ignore them.

But if you want, you can close excel and reopen.

John B wrote:

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.


--

Dave Peterson