VBAProject duplicates

Ok I have been looking here and know this happens but not why.

I have a workbook with macros written with excel97 then moved to 2000
later. I am finally getting around to making everything cleaner.

I open two worksheets to copy calendar and sales data into monthlly
goal sheets and everything has always worked fine.

Now in excel2003 I am getting out of memory errors and the Project
Explorer shows multiple copies of each VBAProject open. As many as
three of the calendar workbook.

I know you guys can help me. Why I am confused is that I never saw
this in excel2000 and if it is a references problem, shouldn't I have
had the problem before?

Thank You all,
SDenton

Hi

Do you have Google desktop installed?
See
http://www.*****-blog.com/archives/2...oogle-desktop/


--
Regards Ron de Bruin
http://www.rondebruin.nl



"nope" <please_just_post@the_newsgroup.com> wrote in message news:[email protected]...
> Ok I have been looking here and know this happens but not why.
>
> I have a workbook with macros written with excel97 then moved to 2000
> later. I am finally getting around to making everything cleaner.
>
> I open two worksheets to copy calendar and sales data into monthlly
> goal sheets and everything has always worked fine.
>
> Now in excel2003 I am getting out of memory errors and the Project
> Explorer shows multiple copies of each VBAProject open. As many as
> three of the calendar workbook.
>
> I know you guys can help me. Why I am confused is that I never saw
> this in excel2000 and if it is a references problem, shouldn't I have
> had the problem before?
>
> Thank You all,
> SDenton
>
>

Thank You for this reply. Yes I thought this was exactly the cause.
Additionally there is a registry key which can be changed and allows
you to keep Google Desktop Search
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Office.Desktop.Google.com\LoadBehavior

It was set to 3. I set it to 2 and all is well.
http://www.*****-blog.com/archives/2...oogle-desktop/

Hooray this was a definite answer. Thank you Ron


On Sun, 9 Jan 2005 13:28:37 +0100, "Ron de Bruin"
<[email protected]> wrote:

>Hi
>
>Do you have Google desktop installed?
>See
>http://www.*****-blog.com/archives/2...oogle-desktop/
>
>
>--
>Regards Ron de Bruin
>http://www.rondebruin.nl
>
>
>
>"nope" <please_just_post@the_newsgroup.com> wrote in message news:[email protected]...
>> Ok I have been looking here and know this happens but not why.
>>
>> I have a workbook with macros written with excel97 then moved to 2000
>> later. I am finally getting around to making everything cleaner.
>>
>> I open two worksheets to copy calendar and sales data into monthlly
>> goal sheets and everything has always worked fine.
>>
>> Now in excel2003 I am getting out of memory errors and the Project
>> Explorer shows multiple copies of each VBAProject open. As many as
>> three of the calendar workbook.
>>
>> I know you guys can help me. Why I am confused is that I never saw
>> this in excel2000 and if it is a references problem, shouldn't I have
>> had the problem before?
>>
>> Thank You all,
>> SDenton
>>
>>
>
>

Thanks for the feedback

--
Regards Ron de Bruin
http://www.rondebruin.nl



"nope" <please_just_post@the_newsgroup.com> wrote in message news:[email protected]...
> Thank You for this reply. Yes I thought this was exactly the cause.
> Additionally there is a registry key which can be changed and allows
> you to keep Google Desktop Search
> HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Office.Desktop.Google.com\LoadBehavior
>
> It was set to 3. I set it to 2 and all is well.
> http://www.*****-blog.com/archives/2...oogle-desktop/
>
> Hooray this was a definite answer. Thank you Ron
>
>
> On Sun, 9 Jan 2005 13:28:37 +0100, "Ron de Bruin"
> <[email protected]> wrote:
>
>>Hi
>>
>>Do you have Google desktop installed?
>>See
>>http://www.*****-blog.com/archives/2...oogle-desktop/
>>
>>
>>--
>>Regards Ron de Bruin
>>http://www.rondebruin.nl
>>
>>
>>
>>"nope" <please_just_post@the_newsgroup.com> wrote in message news:[email protected]...
>>> Ok I have been looking here and know this happens but not why.
>>>
>>> I have a workbook with macros written with excel97 then moved to 2000
>>> later. I am finally getting around to making everything cleaner.
>>>
>>> I open two worksheets to copy calendar and sales data into monthlly
>>> goal sheets and everything has always worked fine.
>>>
>>> Now in excel2003 I am getting out of memory errors and the Project
>>> Explorer shows multiple copies of each VBAProject open. As many as
>>> three of the calendar workbook.
>>>
>>> I know you guys can help me. Why I am confused is that I never saw
>>> this in excel2000 and if it is a references problem, shouldn't I have
>>> had the problem before?
>>>
>>> Thank You all,
>>> SDenton
>>>
>>>
>>
>>
>

I wonder if the registry change for this changed Excel so that now I
am unable to seach VBA projects.
search works in a worksheet but not in VBE.
I have seen a couple posts about VBE searching being broken but no
responses.

Any ideas?

>> Hooray this was a definite answer. Thank you Ron
>>
>>
>> On Sun, 9 Jan 2005 13:28:37 +0100, "Ron de Bruin"
>> <[email protected]> wrote:
>>
>>>Hi
>>>
>>>Do you have Google desktop installed?
>>>See
>>>http://www.*****-blog.com/archives/2...oogle-desktop/
>>>
>>>
>>>--
>>>Regards Ron de Bruin
>>>http://www.rondebruin.nl
>>>
>>>
>>>
>>>"nope" <please_just_post@the_newsgroup.com> wrote in message news:[email protected]...
>>>> Ok I have been looking here and know this happens but not why.
>>>>
>>>> I have a workbook with macros written with excel97 then moved to 2000
>>>> later. I am finally getting around to making everything cleaner.
>>>>
>>>> I open two worksheets to copy calendar and sales data into monthlly
>>>> goal sheets and everything has always worked fine.
>>>>
>>>> Now in excel2003 I am getting out of memory errors and the Project
>>>> Explorer shows multiple copies of each VBAProject open. As many as
>>>> three of the calendar workbook.
>>>>
>>>> I know you guys can help me. Why I am confused is that I never saw
>>>> this in excel2000 and if it is a references problem, shouldn't I have
>>>> had the problem before?
>>>>
>>>> Thank You all,
>>>> SDenton
>>>>
>>>>
>>>
>>>
>>
>
>

Uninstalling Google Dektop search didn't fix the VBE search if anyone
else wants to know.
>
>I wonder if the registry change for this changed Excel so that now I
>am unable to seach VBA projects.
>search works in a worksheet but not in VBE.
>I have seen a couple posts about VBE searching being broken but no
>responses.
>
>Any ideas?
>
>>> Hooray this was a definite answer. Thank you Ron
>>>
>>>
>>> On Sun, 9 Jan 2005 13:28:37 +0100, "Ron de Bruin"
>>> <[email protected]> wrote:
>>>
>>>>Hi
>>>>
>>>>Do you have Google desktop installed?
>>>>See
>>>>http://www.*****-blog.com/archives/2...oogle-desktop/
>>>>
>>>>
>>>>--
>>>>Regards Ron de Bruin
>>>>http://www.rondebruin.nl
>>>>
>>>>
>>>>
>>>>"nope" <please_just_post@the_newsgroup.com> wrote in message news:[email protected]...
>>>>> Ok I have been looking here and know this happens but not why.
>>>>>
>>>>> I have a workbook with macros written with excel97 then moved to 2000
>>>>> later. I am finally getting around to making everything cleaner.
>>>>>
>>>>> I open two worksheets to copy calendar and sales data into monthlly
>>>>> goal sheets and everything has always worked fine.
>>>>>
>>>>> Now in excel2003 I am getting out of memory errors and the Project
>>>>> Explorer shows multiple copies of each VBAProject open. As many as
>>>>> three of the calendar workbook.
>>>>>
>>>>> I know you guys can help me. Why I am confused is that I never saw
>>>>> this in excel2000 and if it is a references problem, shouldn't I have
>>>>> had the problem before?
>>>>>
>>>>> Thank You all,
>>>>> SDenton
>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>
>