Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reload Typelibrary? .Remove() & .AddFromFile() fails
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reload Typelibrary? .Remove() & .AddFromFile() fails
Dunstan,
Does recompiling the VBA project help? You can programmatically recompile the active VBProject with Application.VBE.CommandBars.FindControl(ID:=578).E xecute -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Dunstan" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |