View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Workbooks still appear in Project Explorer after closing in Excel?

Peter -

I don't know. I did notice that only Excel was affected, so after removing
all the add-ins, I was mucking about in the registry, and noticed there was
still a key for the SparkMaker add-in. It uses VSTO, so you might look for
VSTO-based add-ins as your culprit.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Peter T" <peter_t@discussions wrote in message
...
I wonder if it's specifically your Bissantz SparkMaker utility or something
it has in common other things that also give rise to the same effect. Only
mention because I don't have that particular utility yet still get those
phantoms from time to time.

Regards,
Peter T

"Jon Peltier" wrote in message
...
7. Uninstalling the Bissantz SparkMaker utility from the computer has

solved
the problem with phantom VB projects. Too bad, because that was a

promising
tool.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Jon Peltier" wrote in message
...
I followed up on a number of things.

1. The phantom projects appear for deleted Excel workbooks, but not for
deleted Word documents nor for deleted PowerPoint presentations.

2. It happens with any workbooks (brand new Book1, Book2), not just
with
old corrupt ones.

3. I created a new user account in Windows, and the problem persists
for
the new user.

4. Repair and Reinstall from the Control Panel's Add/Remove Programs
did
not help with the phantom VB projects, though it cleared up a problem

with
VBA's Chart.Export for GIF and PNG files, which had been caused by

Office
2007 overwriting the graphics filters files.

5. The Google thing was not a problem; I changed the LoadBehavior of
another add-in, which had no effect.

6. I removed all add-ins (Excel and VBE) and all XLSTART files, cleaned
TEMP and the Recycle Bin. No effect.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Peter T" <peter_t@discussions wrote in message
...
Wouldn't surprise me at all, though I don't have it. The problem only
rarely
manifests for me other than with the system chart files which almost
always
ghost themselves.

Dread to think what's going on in Jon's system though <g

Regards,
Peter T

"NickHK" wrote in message
...
I seem to remember this can be caused by a few "unrelated"
situations.
For some reason "Google Desktop" :
http://www.dicks-blog.com/archives/2...oogle-desktop/

NickHK

wrote in message
ups.com...
I'm having a weird problem when my workbooks still show up in the

VBA
Project Explorer even after I've closed them in Excel.

Sometimes if I open the same workbook multiple times in a session,
I'll
see it listed several times with the same name in the Project
Explorer.
From the Project Explorer, I still can access the VB code and
forms
even though the workbook itself is closed and not in the main Excel
interface.

The workbooks are not hidden. And if I close and reopen Excel they
disappear form the Project Explorer.

Anyone have any ideas what is going on?