Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA projects!! Aaaargh!
Does anyone know why the following happens? I'm using excel XP/2002, Office SP3. I open an instance of excel and the vba editor so I can see both. I open and excel file that contains code. The VBA project appears in the editor. I close the excel workbook. The VBA project still shows the VBA Project. Why doesn't the VBA Project automatically unload? TIA, MAtt. -- MattShoreson ------------------------------------------------------------------------ MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472 View this thread: http://www.excelforum.com/showthread...hreadid=494088 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA projects!! Aaaargh!
Are you using Google Desktop? I saw someone post a few days ago something
about that being the cause. "MattShoreson" wrote: Does anyone know why the following happens? I'm using excel XP/2002, Office SP3. I open an instance of excel and the vba editor so I can see both. I open and excel file that contains code. The VBA project appears in the editor. I close the excel workbook. The VBA project still shows the VBA Project. Why doesn't the VBA Project automatically unload? TIA, MAtt. -- MattShoreson ------------------------------------------------------------------------ MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472 View this thread: http://www.excelforum.com/showthread...hreadid=494088 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA projects!! Aaaargh!
I found this registry change in an earlier post:
(HKEY_CURRENT_USER\Software\Microsoft\Office\Excel \Addins\Office.Desktop.Google.com\LoadBehaivor=2) "Charlie" wrote: Are you using Google Desktop? I saw someone post a few days ago something about that being the cause. "MattShoreson" wrote: Does anyone know why the following happens? I'm using excel XP/2002, Office SP3. I open an instance of excel and the vba editor so I can see both. I open and excel file that contains code. The VBA project appears in the editor. I close the excel workbook. The VBA project still shows the VBA Project. Why doesn't the VBA Project automatically unload? TIA, MAtt. -- MattShoreson ------------------------------------------------------------------------ MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472 View this thread: http://www.excelforum.com/showthread...hreadid=494088 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA projects!! Aaaargh!
P.S. Note the possible misspelling of LoadBehavior in that registry entry. I
don't know if it is misspelled in the example or that is how it is really spelled in the registry. I don't have Google Desktop on this machine. "Charlie" wrote: I found this registry change in an earlier post: (HKEY_CURRENT_USER\Software\Microsoft\Office\Excel \Addins\Office.Desktop.Google.com\LoadBehaivor=2) "Charlie" wrote: Are you using Google Desktop? I saw someone post a few days ago something about that being the cause. "MattShoreson" wrote: Does anyone know why the following happens? I'm using excel XP/2002, Office SP3. I open an instance of excel and the vba editor so I can see both. I open and excel file that contains code. The VBA project appears in the editor. I close the excel workbook. The VBA project still shows the VBA Project. Why doesn't the VBA Project automatically unload? TIA, MAtt. -- MattShoreson ------------------------------------------------------------------------ MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472 View this thread: http://www.excelforum.com/showthread...hreadid=494088 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA projects!! Aaaargh!
Because Bill Gates is an idiot?!?
MattShoreson wrote: Does anyone know why the following happens? I'm using excel XP/2002, Office SP3. I open an instance of excel and the vba editor so I can see both. I open and excel file that contains code. The VBA project appears in the editor. I close the excel workbook. The VBA project still shows the VBA Project. Why doesn't the VBA Project automatically unload? TIA, MAtt. -- MattShoreson ------------------------------------------------------------------------ MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472 View this thread: http://www.excelforum.com/showthread...hreadid=494088 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA projects!! Aaaargh!
Higly likely. I've noticed that it only holds the reference to the last file opened. So if I open book2, then book3 and then close all books, the onl reference held is book3 -- MattShoreso ----------------------------------------------------------------------- MattShoreson's Profile: http://www.excelforum.com/member.php...nfo&userid=347 View this thread: http://www.excelforum.com/showthread.php?threadid=49408 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA projects!! Aaaargh!
Matt, I just read your post about Excel XP SP3 not unloading the VA Projects when you close a workbook. I am experiencing the same problem. Did you find a Solution? Tim Hannon -- Tim Hannon ------------------------------------------------------------------------ Tim Hannon's Profile: http://www.excelforum.com/member.php...o&userid=37139 View this thread: http://www.excelforum.com/showthread...hreadid=494088 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA projects!! Aaaargh!
Tim, Sorry to say - nope. There's not much around on this one and no-one has given a decent answer/possible direction in avoiding. -- MattShoreson ------------------------------------------------------------------------ MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472 View this thread: http://www.excelforum.com/showthread...hreadid=494088 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA projects!! Aaaargh!
Matt,
From your description of only affecting the last WB, do you have some addin interacting with the ActiveWorkbook ? And I assume you don't have Google Desktop installed ? NickHK "MattShoreson" wrote in message news:MattShoreson.2c5w9h_1154940607.0168@excelforu m-nospam.com... Tim, Sorry to say - nope. There's not much around on this one and no-one has given a decent answer/possible direction in avoiding. -- MattShoreson ------------------------------------------------------------------------ MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472 View this thread: http://www.excelforum.com/showthread...hreadid=494088 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA projects!! Aaaargh!
From your description of only affecting the last WB, do you have som addin interacting with the ActiveWorkbook ? Addins dont cause this problem I'm afraid. Removing all addins opening the editor and repeating open a wkbk, open a second, close th first, close the second. The vba project from wkbk2 is still evident. The only way of avoiding the situation above is to NOT open the VBE then no projects show as being loaded after performing the above. And I assume you don't have Google Desktop installed ? Nope -- MattShoreso ----------------------------------------------------------------------- MattShoreson's Profile: http://www.excelforum.com/member.php...nfo&userid=347 View this thread: http://www.excelforum.com/showthread.php?threadid=49408 |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA projects!! Aaaargh!
I had this problem and discovered it was because the Excel process was still running even after closing Excel.
I think this was somehow related to testing I'd been doing in VBA which had caused errors. Anyway, it was easy enough to fix: Close Excel. Open the Task Manager in Windows, and End all the Excel processes still running. Then when you fire it up again, the problem will be solved and closing a file will unload the projects. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with projects | Excel Discussion (Misc queries) | |||
Protected Projects | Excel Programming | |||
Same variable name in different projects | Excel Programming | |||
How to become a better programmer, post college. More projects or less projects. | Excel Programming | |||
How can we share more projects? | Excel Programming |