View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gunnar Johansson[_3_] Gunnar Johansson[_3_] is offline
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) ( x 4 times before I can close
it! ) 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?