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?