Remove reference from code

[Guest]

My VBA project has a reference to an xla - lets call it external.xla. Not all
users of my VBA project has this xla installed. Is there any way to check the
existence of the xla from my code when the VBA project is opened. If it exist
it is placed in the folder C:\xlaStore.

If the xla does not exist I would like to remove the reference or perhaps
just ignore it in some way.

Thanks
The Doctor

 

[Tom Ogilvy]

Private Sub Workbook_Open()
if dir("C:\xlaStore\external.xla") = "" then
- xla does not exist
End if
End Sub

 

[Guest]

Thanks Tom, however I still need the part that removes the reference

The Doctor

 

[Tom Ogilvy]

http://support.microsoft.com/default.aspx?scid=kb;en-us;213529&Product=xlw
XL2000: How to Programmatically Create a Reference

shows how to both add and remove a reference.