Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 47
Default Project still in "project explorer" window after file closed down!

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 52
Default Project still in "project explorer" window after file closed down!

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 661
Default Project still in "project explorer" window after file closed d

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Project still in "project explorer" window after file closed d

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Project still in "project explorer" window after file closed d

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default Project still in "project explorer" window after file closed down!


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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 47
Default Project still in "project explorer" window after file closed down!

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default Project still in "project explorer" window after file closed down!

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 172
Default Project still in "project explorer" window after file closed down!

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 47
Default Project still in "project explorer" window after file closed down!

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 52
Default Project still in "project explorer" window after file closed down!

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 661
Default Project still in "project explorer" window after file closed d

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Project still in "project explorer" window after file closed d

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Project still in "project explorer" window after file closed down!

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Project still in "project explorer" window after file closed down!

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Project still in "project explorer" window after file closed down!

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Project still in "project explorer" window after file closed d

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display "macro-free workbooks - VB project message" on closing Exc Gary Nguyen Excel Discussion (Misc queries) 4 April 4th 23 11:41 AM
Excell error "Can't find Project or Library" Project VBAProject Lost in Excel Excel Worksheet Functions 0 April 12th 07 04:42 PM
Docking Project Explorer, Properties window and Code window in VBE jayray Setting up and Configuration of Excel 2 March 27th 07 04:42 PM
How to activate (in the Project Explorer window) using VBA EagleOne Excel Discussion (Misc queries) 0 December 15th 06 02:26 AM
Excel VBA File Search Command Cannot "See" VBA Project Name gfhunt Excel Programming 0 May 23rd 04 04:36 AM


All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"