Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
In Excel VBA.... when I Remove() a reference to a typelibrary, update the typelibrary with new IDispatch methods, then add the new library back using AddFromFile(), the Intellisense doesn't update. It is as though Excel VBA hides the reference on Remove(), but caches the original library, then re-associates the cache with the workbook on AddFromFile(). If I open a manually associate the new typelibrary with another workbook (Tools-Refs-Add) then the new workbook obtains the new Intellisense. Does anyone have any suggestions or experience on forcing Excel VBA references / Intellisence to reload? Thanks for any ideas, Dunstan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel crash reload close | Excel Discussion (Misc queries) | |||
Reload Excel | Excel Discussion (Misc queries) | |||
How to reload Excel-- no longer have the cd program? | Excel Discussion (Misc queries) | |||
How do I force a reload of the workbook? | New Users to Excel | |||
my system crashed & i had to reload xp, now I cant get my office . | Setting up and Configuration of Excel |