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
|