Programmatically adding a reference to VBE 1

[Stretchwickster]

Hi people!

I successfully managed to programmatically add an add-in to excel but now need to add a reference to the VB Editor References programmatically using Excel 97. Is this possible? I cannot seem to find anything about it in the help or online. However, a friend has informed me that you can do this in Access 97 so I would presume there is a way to do this in Excel also.

Your help would be much appreciated!

Clive

http://www.kucu.co.uk

Ex nihilo, nihil fit (Out of nothing, nothing comes)

 

[FaneDuru]

The code to add a Reference is:

Sub Add_a_Reference()
 RefPath = "C:\Ref.xls"
 Workbooks.Open RefPath
 Workbooks("Ref.xls").VBProject.Name = "Test"
 ThisWorkbook.VBProject.References.AddFromFile RefPath
End Sub

To take it out :

Sub Off_Reference
 ThisWorkbook.VBProject.References.Remove _
          ThisWorkbook.VBProject.References("Test")
End Sub

I hope this helps...

 

[Stretchwickster]

That worked a treat - thankyou very much!

Clive

http://www.kucu.co.uk

Ex nihilo, nihil fit (Out of nothing, nothing comes)