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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >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

I can replicate this by having two windows with the same workbook.

Hide one instance and close the other.

The workbook still appears in VBE because a hidden window is present.


Gord Dibben MS Excel MVP

On Thu, 07 Jun 2007 14:22:52 -0500, Dave Peterson <(E-Mail Removed)>
wrote:

>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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> >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

I think that this isn't a problem. The project will still appear in the VBE
with any hidden workbook/addin.

These phantom projects actually appear when the workbook is closed (not just a
window to the workbook).



Gord Dibben wrote:
>
> I can replicate this by having two windows with the same workbook.
>
> Hide one instance and close the other.
>
> The workbook still appears in VBE because a hidden window is present.
>
> Gord Dibben MS Excel MVP
>
> On Thu, 07 Jun 2007 14:22:52 -0500, Dave Peterson <(E-Mail Removed)>
> wrote:
>
> >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" <(E-Mail Removed)> wrote in message
> >> news:(E-Mail Removed)...
> >> >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

Yes... the problem is when you actually CLOSE the workbook, not when
you just have only hidden sheets in a still open workbook . The VBE
actually shows the same phantom workbook name over and over in the VBE
(which shouldn't even be possible). And as mentioned, you can edit
any of the phantoms and completely waste your time since there's no
way to save the phantoms. It is some sort of resource release problem
as Jon mentions.

Jon, what is a "COM" add-in? I don't have any special add-ins from
the Tools -> Add-ins menu or in the Add-in Manager in the VBE. Is
there somewhere else to check? How do I uninstall a COM add-in?

I have one unique add-in called "XLFit", but I don't see where that is
being loaded. It checks for certain formulas in a spreadsheet, and if
detected, it then loads the main mother add-in to provide
functionality. The main add-in is an extremely complex charting macro
which sounds like may be similar to the Sparkline chart tools (??).

Thanks for your help! This problem is a big hassle when testing and
would be great to figure out.

John