Home |
Search |
Today's Posts |
#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? |
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 |