Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBAProject duplicates
Hi
Do you have Google desktop installed? See http://www.dicks-blog.com/archives/2...oogle-desktop/ -- Regards Ron de Bruin http://www.rondebruin.nl "nope" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBAProject duplicates
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.dicks-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" wrote: Hi Do you have Google desktop installed? See http://www.dicks-blog.com/archives/2...oogle-desktop/ -- Regards Ron de Bruin http://www.rondebruin.nl "nope" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBAProject duplicates
Thanks for the feedback
-- Regards Ron de Bruin http://www.rondebruin.nl "nope" wrote in message ... 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.dicks-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" wrote: Hi Do you have Google desktop installed? See http://www.dicks-blog.com/archives/2...oogle-desktop/ -- Regards Ron de Bruin http://www.rondebruin.nl "nope" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBAProject duplicates did the fix break more?
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" wrote: Hi Do you have Google desktop installed? See http://www.dicks-blog.com/archives/2...oogle-desktop/ -- Regards Ron de Bruin http://www.rondebruin.nl "nope" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBAProject duplicates did the fix break more?
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" wrote: Hi Do you have Google desktop installed? See http://www.dicks-blog.com/archives/2...oogle-desktop/ -- Regards Ron de Bruin http://www.rondebruin.nl "nope" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBAProject | Excel Worksheet Functions | |||
VBAProject references | Excel Programming | |||
VBAProject Password | Excel Programming | |||
VBAProject scope | Excel Programming | |||
How to get rid of a VBAProject? | Excel Programming |