LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?






 
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 11:57 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"