Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project duplicated in Project Explorer
Please could someone suggest why I get multiple versions of my VBA project in
Project Explorer? It's irritating because changes I make to the code in one "clone" don't have any effect if the worksheet seems to be paying attention to another one. It seems to be OK if I consistently enter changes only into the uppermost version of the project (provided I remember to avoid the others) - but why are the duplicates there anyway? Sometimes it goes back to one version on reopening the workbook; currently I have three identical-looking versions in Project Explorer and I'm worried that some changes will get lost if I accidentally enter in the wrong clone... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project duplicated in Project Explorer
It has never happended to me, but I have seen it discussed. Most say if
they close excel and reopen it clears up. I suggest you do that when it occurs. -- Regards, Tom Ogilvy "teabag" wrote in message ... Please could someone suggest why I get multiple versions of my VBA project in Project Explorer? It's irritating because changes I make to the code in one "clone" don't have any effect if the worksheet seems to be paying attention to another one. It seems to be OK if I consistently enter changes only into the uppermost version of the project (provided I remember to avoid the others) - but why are the duplicates there anyway? Sometimes it goes back to one version on reopening the workbook; currently I have three identical-looking versions in Project Explorer and I'm worried that some changes will get lost if I accidentally enter in the wrong clone... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project duplicated in Project Explorer
Thanks for the quick reply, Tom, however closing and reopening does not clear
up my problem. This morning I started with one set of project items (workbook, worksheet, modules), closed, reopened, found two sets of identical items; closed again, reopened and now have three. I'm going to try rebooting now, since the duplicates I had yesterday had indeed disappeared this morning; however a full reboot is a bit drastic every time you want to try out a bit of code in Open or Close Workbook! I'd be grateful for any further help if available. teabag "Tom Ogilvy" wrote: It has never happended to me, but I have seen it discussed. Most say if they close excel and reopen it clears up. I suggest you do that when it occurs. -- Regards, Tom Ogilvy "teabag" wrote in message ... Please could someone suggest why I get multiple versions of my VBA project in Project Explorer? It's irritating because changes I make to the code in one "clone" don't have any effect if the worksheet seems to be paying attention to another one. It seems to be OK if I consistently enter changes only into the uppermost version of the project (provided I remember to avoid the others) - but why are the duplicates there anyway? Sometimes it goes back to one version on reopening the workbook; currently I have three identical-looking versions in Project Explorer and I'm worried that some changes will get lost if I accidentally enter in the wrong clone... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project duplicated in Project Explorer
For Tom: OOOPS! Sorry, just realised that the closing and reopening I have
been doing was of the file only. Just tried closing Excel and reopening and the problem was cleared. Still seems a bit of a pain to have to do this every time I close the file, but better than a full reboot. Thanks again, teabag "teabag" wrote: Thanks for the quick reply, Tom, however closing and reopening does not clear up my problem. This morning I started with one set of project items (workbook, worksheet, modules), closed, reopened, found two sets of identical items; closed again, reopened and now have three. I'm going to try rebooting now, since the duplicates I had yesterday had indeed disappeared this morning; however a full reboot is a bit drastic every time you want to try out a bit of code in Open or Close Workbook! I'd be grateful for any further help if available. teabag "Tom Ogilvy" wrote: It has never happended to me, but I have seen it discussed. Most say if they close excel and reopen it clears up. I suggest you do that when it occurs. -- Regards, Tom Ogilvy "teabag" wrote in message ... Please could someone suggest why I get multiple versions of my VBA project in Project Explorer? It's irritating because changes I make to the code in one "clone" don't have any effect if the worksheet seems to be paying attention to another one. It seems to be OK if I consistently enter changes only into the uppermost version of the project (provided I remember to avoid the others) - but why are the duplicates there anyway? Sometimes it goes back to one version on reopening the workbook; currently I have three identical-looking versions in Project Explorer and I'm worried that some changes will get lost if I accidentally enter in the wrong clone... |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project duplicated in Project Explorer
Closing and opening the file is what causes the problem as I understand it.
I can't say what the technical issue is, but most people don't have a problem with it. -- Regards, Tom Ogilvy "teabag" wrote in message ... For Tom: OOOPS! Sorry, just realised that the closing and reopening I have been doing was of the file only. Just tried closing Excel and reopening and the problem was cleared. Still seems a bit of a pain to have to do this every time I close the file, but better than a full reboot. Thanks again, teabag "teabag" wrote: Thanks for the quick reply, Tom, however closing and reopening does not clear up my problem. This morning I started with one set of project items (workbook, worksheet, modules), closed, reopened, found two sets of identical items; closed again, reopened and now have three. I'm going to try rebooting now, since the duplicates I had yesterday had indeed disappeared this morning; however a full reboot is a bit drastic every time you want to try out a bit of code in Open or Close Workbook! I'd be grateful for any further help if available. teabag "Tom Ogilvy" wrote: It has never happended to me, but I have seen it discussed. Most say if they close excel and reopen it clears up. I suggest you do that when it occurs. -- Regards, Tom Ogilvy "teabag" wrote in message ... Please could someone suggest why I get multiple versions of my VBA project in Project Explorer? It's irritating because changes I make to the code in one "clone" don't have any effect if the worksheet seems to be paying attention to another one. It seems to be OK if I consistently enter changes only into the uppermost version of the project (provided I remember to avoid the others) - but why are the duplicates there anyway? Sometimes it goes back to one version on reopening the workbook; currently I have three identical-looking versions in Project Explorer and I'm worried that some changes will get lost if I accidentally enter in the wrong clone... |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project duplicated in Project Explorer
Thanks for your time, Tom - at least I know I'm not alone with this one.
Regards, teabag "Tom Ogilvy" wrote: Closing and opening the file is what causes the problem as I understand it. I can't say what the technical issue is, but most people don't have a problem with it. -- Regards, Tom Ogilvy "teabag" wrote in message ... For Tom: OOOPS! Sorry, just realised that the closing and reopening I have been doing was of the file only. Just tried closing Excel and reopening and the problem was cleared. Still seems a bit of a pain to have to do this every time I close the file, but better than a full reboot. Thanks again, teabag "teabag" wrote: Thanks for the quick reply, Tom, however closing and reopening does not clear up my problem. This morning I started with one set of project items (workbook, worksheet, modules), closed, reopened, found two sets of identical items; closed again, reopened and now have three. I'm going to try rebooting now, since the duplicates I had yesterday had indeed disappeared this morning; however a full reboot is a bit drastic every time you want to try out a bit of code in Open or Close Workbook! I'd be grateful for any further help if available. teabag "Tom Ogilvy" wrote: It has never happended to me, but I have seen it discussed. Most say if they close excel and reopen it clears up. I suggest you do that when it occurs. -- Regards, Tom Ogilvy "teabag" wrote in message ... Please could someone suggest why I get multiple versions of my VBA project in Project Explorer? It's irritating because changes I make to the code in one "clone" don't have any effect if the worksheet seems to be paying attention to another one. It seems to be OK if I consistently enter changes only into the uppermost version of the project (provided I remember to avoid the others) - but why are the duplicates there anyway? Sometimes it goes back to one version on reopening the workbook; currently I have three identical-looking versions in Project Explorer and I'm worried that some changes will get lost if I accidentally enter in the wrong clone... |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project duplicated in Project Explorer
Do you have Google Desktop installed ?
http://groups.google.co.uk/group/mic...f43483 83ab93 NickHK "teabag" ... Please could someone suggest why I get multiple versions of my VBA project in Project Explorer? It's irritating because changes I make to the code in one "clone" don't have any effect if the worksheet seems to be paying attention to another one. It seems to be OK if I consistently enter changes only into the uppermost version of the project (provided I remember to avoid the others) - but why are the duplicates there anyway? Sometimes it goes back to one version on reopening the workbook; currently I have three identical-looking versions in Project Explorer and I'm worried that some changes will get lost if I accidentally enter in the wrong clone... |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project duplicated in Project Explorer
Er, no, Nick - should I?
Regards, teabag "NickHK" wrote: Do you have Google Desktop installed ? http://groups.google.co.uk/group/mic...f43483 83ab93 NickHK "teabag" ... Please could someone suggest why I get multiple versions of my VBA project in Project Explorer? It's irritating because changes I make to the code in one "clone" don't have any effect if the worksheet seems to be paying attention to another one. It seems to be OK if I consistently enter changes only into the uppermost version of the project (provided I remember to avoid the others) - but why are the duplicates there anyway? Sometimes it goes back to one version on reopening the workbook; currently I have three identical-looking versions in Project Explorer and I'm worried that some changes will get lost if I accidentally enter in the wrong clone... |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project duplicated in Project Explorer
Nick, Thanks for the interesting link - always a comfort to read about
fellow-sufferers. I think I give up - thanks for your time, Best regards, teabag "teabag" wrote: Er, no, Nick - should I? Regards, teabag "NickHK" wrote: Do you have Google Desktop installed ? http://groups.google.co.uk/group/mic...f43483 83ab93 NickHK "teabag" ... Please could someone suggest why I get multiple versions of my VBA project in Project Explorer? It's irritating because changes I make to the code in one "clone" don't have any effect if the worksheet seems to be paying attention to another one. It seems to be OK if I consistently enter changes only into the uppermost version of the project (provided I remember to avoid the others) - but why are the duplicates there anyway? Sometimes it goes back to one version on reopening the workbook; currently I have three identical-looking versions in Project Explorer and I'm worried that some changes will get lost if I accidentally enter in the wrong clone... |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project duplicated in Project Explorer
If you have autosave checked on your ToolsOptionsSave tab then you could be
getting a different version number assigned as the file auto saves if changes have been made in the mean time. I have noticed the version suffix on my files on occasion but they usually go away when I manually save and close the file. When you open the file, the basic file should be the one to open, not the version suffixed files, so you really don't have to worry about it. "teabag" wrote: Nick, Thanks for the interesting link - always a comfort to read about fellow-sufferers. I think I give up - thanks for your time, Best regards, teabag "teabag" wrote: Er, no, Nick - should I? Regards, teabag "NickHK" wrote: Do you have Google Desktop installed ? http://groups.google.co.uk/group/mic...f43483 83ab93 NickHK "teabag" ... Please could someone suggest why I get multiple versions of my VBA project in Project Explorer? It's irritating because changes I make to the code in one "clone" don't have any effect if the worksheet seems to be paying attention to another one. It seems to be OK if I consistently enter changes only into the uppermost version of the project (provided I remember to avoid the others) - but why are the duplicates there anyway? Sometimes it goes back to one version on reopening the workbook; currently I have three identical-looking versions in Project Explorer and I'm worried that some changes will get lost if I accidentally enter in the wrong clone... |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project duplicated in Project Explorer
Thanks for this, JLGWhiz. I do have autosave checked and I will stop worrying
about it. Since getting help a few days ago, I have been closing Excel instead of just the file and this clears the "clones" away - which gels with your autosave tip, too, I guess. Sorry about the delay, by the way: the email announcing your response got caught in our spam filter so I didn't know to look for it till I checked spam today. Grateful teabag. ........................................ "JLGWhiz" wrote: If you have autosave checked on your ToolsOptionsSave tab then you could be getting a different version number assigned as the file auto saves if changes have been made in the mean time. I have noticed the version suffix on my files on occasion but they usually go away when I manually save and close the file. When you open the file, the basic file should be the one to open, not the version suffixed files, so you really don't have to worry about it. "teabag" wrote: Nick, Thanks for the interesting link - always a comfort to read about fellow-sufferers. I think I give up - thanks for your time, Best regards, teabag "teabag" wrote: Er, no, Nick - should I? Regards, teabag "NickHK" wrote: Do you have Google Desktop installed ? http://groups.google.co.uk/group/mic...f43483 83ab93 NickHK "teabag" ... Please could someone suggest why I get multiple versions of my VBA project in Project Explorer? It's irritating because changes I make to the code in one "clone" don't have any effect if the worksheet seems to be paying attention to another one. It seems to be OK if I consistently enter changes only into the uppermost version of the project (provided I remember to avoid the others) - but why are the duplicates there anyway? Sometimes it goes back to one version on reopening the workbook; currently I have three identical-looking versions in Project Explorer and I'm worried that some changes will get lost if I accidentally enter in the wrong clone... |
#12
|
|||
|
|||
I had the same issue when I enabled Analysis ToolPack and its related built-ins. These built-ins contain macros too, probably this was the root cause.
After disabling them, the issue disappeared. Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Project Explorer list | Excel Programming | |||
Project still in "project explorer" window after file closed down! | Excel Programming | |||
Project still in "project explorer" window after file closed down! | Excel Programming | |||
VBA Project Explorer | Excel Programming | |||
Bizarre Project Explorer in VBE | Excel Programming |