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

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