View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dunstan Dunstan is offline
external usenet poster
 
Posts: 1
Default 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