I'm still having a problem of when I close a workbook (with or without
macros), a phantom copy of the workbook remains in the VBE.

If I open and close the same file 10 times, I get 10 phantom workbooks
in the VBE. The dangerous thing is that you can actually look at any
code and edit it even though there's no way to save the actual image.

The only way to get rid of these phantoms is to exit Excel and come
back in (which I'm forced to do constantly).

I know this has been discussed before, but I haven't really seen any
solutions or explanations. Has anyone figured out what causes this
phantom problem?!

Thanks!

John

I had this [known] problem with an earlier google desktop version. Do
you have the google desktop application?

Kind regards
Tskogstrom

What do you mean "google desktop version"? What is the "google
desktop application"?

I'm talking about Excel workbooks in the Visual Basic Editor ... are
they affected by something by Google?

Thanks.

John

I think Tskogstrom meant Google Desktop Search.
http://desktop.google.com/

An early version of this program was accused of causing the problem you're
seeing. Newer versions haven't been accused (as far as I've seen).

I don't have a reason why these things occur. I do know that if they bother me,
I can close excel and restart it. But the few times I've seen them, they
haven't bother me enough to do that. It sounds like they bother you more than
they bother me.

robotman wrote:

What do you mean "google desktop version"? What is the "google
desktop application"?

I'm talking about Excel workbooks in the Visual Basic Editor ... are
they affected by something by Google?

Thanks.

John

--

Dave Peterson

A lot of my macros open and close several files so the phantoms build
up quickly in the VBE when I'm testing my macros. It basically forces
me to close and re-open Excel with every test.

It would be nice to know understand what causes this phantom problem.
I don't use the Google program so that's not the culprit.

John

Dave -

This can in fact be a real bother. As RobotMan says, you don't know which VB
project you should be editing, and you can lose hours of work if you guess
wrong or don't even notice the problem in time.

John -

Do you have any COM add-ins installed? I have heard of this problem arising
when add-ins written in dot net or VSTO don't properly reference and release
resources. Two early versions of commercial sparkline chart tools both
experienced these issues, though I've been assured that both have been
corrected. Remove the add-ins one by one, and check whether the problem
disappears. When it does, you've found the culprit.

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


"Dave Peterson" wrote in message
...
I think Tskogstrom meant Google Desktop Search.
http://desktop.google.com/

An early version of this program was accused of causing the problem you're
seeing. Newer versions haven't been accused (as far as I've seen).

I don't have a reason why these things occur. I do know that if they
bother me,
I can close excel and restart it. But the few times I've seen them, they
haven't bother me enough to do that. It sounds like they bother you more
than
they bother me.

robotman wrote:

What do you mean "google desktop version"? What is the "google
desktop application"?

I'm talking about Excel workbooks in the Visual Basic Editor ... are
they affected by something by Google?

Thanks.

John

--

Dave Peterson

Hi Jon.

You've shared this with me before <bg. I guess I continue to be lucky. I
can't remember the last time I saw one of those phantom projects -- especially
in xl2003 (if there's a difference????).

Here's hoping your tips help John (with an H).

Jon Peltier wrote:

Dave -

This can in fact be a real bother. As RobotMan says, you don't know which VB
project you should be editing, and you can lose hours of work if you guess
wrong or don't even notice the problem in time.

John -

Do you have any COM add-ins installed? I have heard of this problem arising
when add-ins written in dot net or VSTO don't properly reference and release
resources. Two early versions of commercial sparkline chart tools both
experienced these issues, though I've been assured that both have been
corrected. Remove the add-ins one by one, and check whether the problem
disappears. When it does, you've found the culprit.

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

"Dave Peterson" wrote in message
...
I think Tskogstrom meant Google Desktop Search.
http://desktop.google.com/

An early version of this program was accused of causing the problem you're
seeing. Newer versions haven't been accused (as far as I've seen).

I don't have a reason why these things occur. I do know that if they
bother me,
I can close excel and restart it. But the few times I've seen them, they
haven't bother me enough to do that. It sounds like they bother you more
than
they bother me.

robotman wrote:

What do you mean "google desktop version"? What is the "google
desktop application"?

I'm talking about Excel workbooks in the Visual Basic Editor ... are
they affected by something by Google?

Thanks.

John

--

Dave Peterson

--

Dave Peterson