Reload Typelibrary? .Remove() & .AddFromFile() fails

  • Thread starter Thread starter Dunstan
  • Start date Start date
D

Dunstan

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
 
Dunstan,

Does recompiling the VBA project help? You can programmatically
recompile the active VBProject with

Application.VBE.CommandBars.FindControl(ID:=578).Execute


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top