Fix missing references using VBA

[rksample]

Hi Gurus,

I am trying to fix few missing library references using VBA. I am able to use the same code on a sample file with a missing reference to Excel-Addin. However, it is not working on the main file with references to SAP Lib References and MS SOAP Toolkit References. I am adding the sample file below:

Let me know if you need a sample file. I shall try to downsize the code and upload it.

cheers,
RK.

 

[footoo]

Re: Help trying to fix missing references using VBA

See if this helps :
Missing References In VBA

 

[rksample]

Re: Help trying to fix missing references using VBA

See if this helps :
Missing References In VBA

Thanks footoo. I had already gone through this. Unfortunately, it doesn't help me trigger removal of these references using VBA on Workbook Open method. That's what I am looking after.

Cheers,
Ravi.

 

[rksample]

Re: Help trying to fix missing references using VBA

Hi Excel Gurus,

Any help on this issue? I am looking to find all the Missing references and remove them (and ofcourse add replace them with relevant versions).

Thank you,
Ravi.