Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I find that the VBAProjects doesn't disappear in the explorer window in vba editor and if I open the file more times, there will be more Projects with the same name and it causes crasches after a while. Anybody know why? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've seen these, but don't know what causes them.
I've never had xl crash because of one of them, but if you're concerned, close excel and restart. Next time I see one, I'm gonna try reopening a few times to see if xl crashes. Gunnar Johansson wrote: Hi, I find that the VBAProjects doesn't disappear in the explorer window in vba editor and if I open the file more times, there will be more Projects with the same name and it causes crasches after a while. Anybody know why? -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have exactly the same problem on my main computer but not on my laptop!
I have used "Detect & Repair" and also "Reinstall" from my Office XP CD but to no avail. I have no add-ins and my VBA references are the minimum. I have been on other forum sites and this is NOT an isolated problem. So far I have encountered at least a dozen reports of the same thing happening. Paul "Dave Peterson" wrote: I've seen these, but don't know what causes them. I've never had xl crash because of one of them, but if you're concerned, close excel and restart. Next time I see one, I'm gonna try reopening a few times to see if xl crashes. Gunnar Johansson wrote: Hi, I find that the VBAProjects doesn't disappear in the explorer window in vba editor and if I open the file more times, there will be more Projects with the same name and it causes crasches after a while. Anybody know why? -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Uninstall Googel personal indexer..that's the casue of the problems.
/Regards "Paul" skrev i meddelandet ... I have exactly the same problem on my main computer but not on my laptop! I have used "Detect & Repair" and also "Reinstall" from my Office XP CD but to no avail. I have no add-ins and my VBA references are the minimum. I have been on other forum sites and this is NOT an isolated problem. So far I have encountered at least a dozen reports of the same thing happening. Paul "Dave Peterson" wrote: I've seen these, but don't know what causes them. I've never had xl crash because of one of them, but if you're concerned, close excel and restart. Next time I see one, I'm gonna try reopening a few times to see if xl crashes. Gunnar Johansson wrote: Hi, I find that the VBAProjects doesn't disappear in the explorer window in vba editor and if I open the file more times, there will be more Projects with the same name and it causes crasches after a while. Anybody know why? -- Dave Peterson |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks a lot. otherwise I'm going to get crazy. I tried to repair, reinstall, safe mode but didn't work.
Thanks again. Regards. -- Haldun Alay "Gunnar Johansson" , haber iletisinde şunları ... Uninstall Googel personal indexer..that's the casue of the problems. /Regards "Paul" skrev i meddelandet ... I have exactly the same problem on my main computer but not on my laptop! I have used "Detect & Repair" and also "Reinstall" from my Office XP CD but to no avail. I have no add-ins and my VBA references are the minimum. I have been on other forum sites and this is NOT an isolated problem. So far I have encountered at least a dozen reports of the same thing happening. Paul "Dave Peterson" wrote: I've seen these, but don't know what causes them. I've never had xl crash because of one of them, but if you're concerned, close excel and restart. Next time I see one, I'm gonna try reopening a few times to see if xl crashes. Gunnar Johansson wrote: Hi, I find that the VBAProjects doesn't disappear in the explorer window in vba editor and if I open the file more times, there will be more Projects with the same name and it causes crasches after a while. Anybody know why? -- Dave Peterson |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Do you have any VBE addins installed? I'm not sure but I had some freezes with Smart Indenter v3.3, that disappeared when I installed v3.4 (rel.Nov 5th) http://www.oaltd.co.uk Else just unload all VBE addins and see if it still happens... keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool Gunnar Johansson wrote in message : Hi, I find that the VBAProjects doesn't disappear in the explorer window in vba editor and if I open the file more times, there will be more Projects with the same name and it causes crasches after a while. Anybody know why? |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Yes, I had ASAP Utilities and Navigator, but I have unloaded them but
problem still exists. When I close down Excel and reopen it, the projects disappear. Is this a XL 2003 question? I don't rembemer I had this probelm with 2002..? /Regards "keepITcool" skrev i meddelandet ... Do you have any VBE addins installed? I'm not sure but I had some freezes with Smart Indenter v3.3, that disappeared when I installed v3.4 (rel.Nov 5th) http://www.oaltd.co.uk Else just unload all VBE addins and see if it still happens... keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool Gunnar Johansson wrote in message : Hi, I find that the VBAProjects doesn't disappear in the explorer window in vba editor and if I open the file more times, there will be more Projects with the same name and it causes crasches after a while. Anybody know why? |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Gunnar,
it's NOT 'normal' addins for excel (like ASAP) it's specific com-addins for the VBEditor, as listed under addins/add-in manager in the VBeditor. if you dont have these.. i dont know what's causing it. keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool Gunnar Johansson wrote in message : Yes, I had ASAP Utilities and Navigator, but I have unloaded them but problem still exists. When I close down Excel and reopen it, the projects disappear. Is this a XL 2003 question? I don't rembemer I had this probelm with 2002..? /Regards "keepITcool" skrev i meddelandet ... Do you have any VBE addins installed? I'm not sure but I had some freezes with Smart Indenter v3.3, that disappeared when I installed v3.4 (rel.Nov 5th) http://www.oaltd.co.uk Else just unload all VBE addins and see if it still happens... keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool Gunnar Johansson wrote in message : Hi, I find that the VBAProjects doesn't disappear in the explorer window in vba editor and if I open the file more times, there will be more Projects with the same name and it causes crasches after a while. Anybody know why? |
#9
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the same problem with "ghost" projects persistence in Excel97.
I hadn't noticed that to be a cause of crashes; I'll have to try pushing it to find out. Paul -------------------------------------------------------------------------------------------------------------- When I close down Excel and reopen it, the projects disappear. Is this a XL 2003 question? I don't rembemer I had this probelm with 2002..? /Regards |
#10
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The only VBE addin I have is PrettyCode, but I don't think it's the problem.
I'm right now trying to reinstall Office. We'll see if a fresh office have the same problem (or if it is connected to a VBAProject...). I'll be back. /Regards skrev i meddelandet ... I have the same problem with "ghost" projects persistence in Excel97. I hadn't noticed that to be a cause of crashes; I'll have to try pushing it to find out. Paul -------------------------------------------------------------------------------------------------------------- When I close down Excel and reopen it, the projects disappear. Is this a XL 2003 question? I don't rembemer I had this probelm with 2002..? /Regards |
#11
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've seen it in xl97, too. And in xl2002. (I don't recall if I've seen it in
xl2k--but that doesn't mean it doesn't occur.) Gunnar Johansson wrote: Yes, I had ASAP Utilities and Navigator, but I have unloaded them but problem still exists. When I close down Excel and reopen it, the projects disappear. Is this a XL 2003 question? I don't rembemer I had this probelm with 2002..? /Regards "keepITcool" skrev i meddelandet ... Do you have any VBE addins installed? I'm not sure but I had some freezes with Smart Indenter v3.3, that disappeared when I installed v3.4 (rel.Nov 5th) http://www.oaltd.co.uk Else just unload all VBE addins and see if it still happens... keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool Gunnar Johansson wrote in message : Hi, I find that the VBAProjects doesn't disappear in the explorer window in vba editor and if I open the file more times, there will be more Projects with the same name and it causes crasches after a while. Anybody know why? -- Dave Peterson |
#12
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have exactly the same problem with Excel XP (xl2002).
I have used my Office XP CD to "Detect & Repair" and to "Reinstall" but with no effect. My only other course will be to uninstall and then reinstall - but I want to know why this is happening! Paul "Dave Peterson" wrote: I've seen it in xl97, too. And in xl2002. (I don't recall if I've seen it in xl2k--but that doesn't mean it doesn't occur.) Gunnar Johansson wrote: Yes, I had ASAP Utilities and Navigator, but I have unloaded them but problem still exists. When I close down Excel and reopen it, the projects disappear. Is this a XL 2003 question? I don't rembemer I had this probelm with 2002..? /Regards "keepITcool" skrev i meddelandet ... Do you have any VBE addins installed? I'm not sure but I had some freezes with Smart Indenter v3.3, that disappeared when I installed v3.4 (rel.Nov 5th) http://www.oaltd.co.uk Else just unload all VBE addins and see if it still happens... keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool Gunnar Johansson wrote in message : Hi, I find that the VBAProjects doesn't disappear in the explorer window in vba editor and if I open the file more times, there will be more Projects with the same name and it causes crasches after a while. Anybody know why? -- Dave Peterson |
#13
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have now reinstalled office 2003 and the problem continues.
/Regards "Paul" skrev i meddelandet ... I have exactly the same problem with Excel XP (xl2002). I have used my Office XP CD to "Detect & Repair" and to "Reinstall" but with no effect. My only other course will be to uninstall and then reinstall - but I want to know why this is happening! Paul "Dave Peterson" wrote: I've seen it in xl97, too. And in xl2002. (I don't recall if I've seen it in xl2k--but that doesn't mean it doesn't occur.) Gunnar Johansson wrote: Yes, I had ASAP Utilities and Navigator, but I have unloaded them but problem still exists. When I close down Excel and reopen it, the projects disappear. Is this a XL 2003 question? I don't rembemer I had this probelm with 2002..? /Regards "keepITcool" skrev i meddelandet ... Do you have any VBE addins installed? I'm not sure but I had some freezes with Smart Indenter v3.3, that disappeared when I installed v3.4 (rel.Nov 5th) http://www.oaltd.co.uk Else just unload all VBE addins and see if it still happens... keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool Gunnar Johansson wrote in message : Hi, I find that the VBAProjects doesn't disappear in the explorer window in vba editor and if I open the file more times, there will be more Projects with the same name and it causes crasches after a while. Anybody know why? -- Dave Peterson |
#14
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have seen this problem too. I found that
it pertained to an individual workbook and not to Excel itself. To fix the problem with the workbook I copied all of the code to a new workbook and the problem went away. HTM, Jim On Sun, 7 Nov 2004 13:12:50 +0100, "Gunnar Johansson" wrote: Hi, I find that the VBAProjects doesn't disappear in the explorer window in vba editor and if I open the file more times, there will be more Projects with the same name and it causes crasches after a while. Anybody know why? |
#15
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I had the same problem but found out that my add-in had some references to a worksheet in the workbook I tried to close. By ensuring that the reference was dropped the VBA project disappeared. So make sure you do not have remaining references in your addin when you close your workbook. Microsoft -- Could be something to warn about perhaps !? "Gunnar Johansson" wrote: Hi, I find that the VBAProjects doesn't disappear in the explorer window in vba editor and if I open the file more times, there will be more Projects with the same name and it causes crasches after a while. Anybody know why? |
#16
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Interesting Bertil. 'remaining references' - what is that? Anybody?
I get error Device I/O error (Error 57) when I try to close down the VBE. I guess it's caused by VBA projects nearly identical (just different time versions of them). What can I look for? What it this "dropped references"? I'm not recogize what it is? Can any explain for me and give a hint on what I can look for? Regards "Bertil Emmertz" skrev i meddelandet ... Hi, I had the same problem but found out that my add-in had some references to a worksheet in the workbook I tried to close. By ensuring that the reference was dropped the VBA project disappeared. So make sure you do not have remaining references in your addin when you close your workbook. Microsoft -- Could be something to warn about perhaps !? "Gunnar Johansson" wrote: Hi, I find that the VBAProjects doesn't disappear in the explorer window in vba editor and if I open the file more times, there will be more Projects with the same name and it causes crasches after a while. Anybody know why? |
#17
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Gunnar !
My addin builds up a number of internal structures mostly objects relating to each other. Some of the fields are references to e.g. a worksheet. If you close down your workbook without making sure that these internal structures are destroyed (set to Nothing) then you can have the problem of a dangling reference. Does that answer your question. "Gunnar Johansson" wrote: Interesting Bertil. 'remaining references' - what is that? Anybody? I get error Device I/O error (Error 57) when I try to close down the VBE. I guess it's caused by VBA projects nearly identical (just different time versions of them). What can I look for? What it this "dropped references"? I'm not recogize what it is? Can any explain for me and give a hint on what I can look for? Regards "Bertil Emmertz" skrev i meddelandet ... Hi, I had the same problem but found out that my add-in had some references to a worksheet in the workbook I tried to close. By ensuring that the reference was dropped the VBA project disappeared. So make sure you do not have remaining references in your addin when you close your workbook. Microsoft -- Could be something to warn about perhaps !? "Gunnar Johansson" wrote: Hi, I find that the VBAProjects doesn't disappear in the explorer window in vba editor and if I open the file more times, there will be more Projects with the same name and it causes crasches after a while. Anybody know why? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display "macro-free workbooks - VB project message" on closing Exc | Excel Discussion (Misc queries) | |||
Excell error "Can't find Project or Library" Project VBAProject | Excel Worksheet Functions | |||
Docking Project Explorer, Properties window and Code window in VBE | Setting up and Configuration of Excel | |||
How to activate (in the Project Explorer window) using VBA | Excel Discussion (Misc queries) | |||
Excel VBA File Search Command Cannot "See" VBA Project Name | Excel Programming |