Programmatically removing references (2000/2002)

Topic

New Reply

I know that you can use the VBA Extensability object model to access a Projects references but when I try to use the Remove method I get an error that the object doesn’t support that method. Has anyone had any experience with this?

Thanks
Ed

Reply | Quote

Replies

Try the following approach, where Reference2BRemoved is the refernce you wish to remove :

Dim oRef
Set oRef = Reference2BRemoved
Application.VBE.ActiveVBProject.References.Remove oRef.

That should work even without a reference to the VBA Extensability, unless of course you are trying to remove that reference.

Andrew C

Reply | Quote

If the above doesn’t help, please post the relevant portion of code. We’ve had posts here, but it’s probably more efficient to eyeball the code than dig through.

Reply | Quote

The previous post worked like a champ.

Reply | Quote