Remove Reference Library Programmatically

Hi All

I'm trying to programmatically add and remove the Outlook 11.0 Reference Library in Excel 2003.

So far, I have found the following code which successfuly adds the reference:

Please Login or Register  to view this content.

But when I try to remove it using the following code, it doesn't work.

Please Login or Register  to view this content.

Does anybody have any suggestions of what I'm doing wrong?

Dion

As in your first code, the argument you pass to the Remove method is a Reference object, not a string (or GUID). To do it using a GUID, I think you would have to loop through all the references, check the GUID property and, if it matches, remove it.

Perhaps:

Please Login or Register  to view this content.

R, will have better code to hand I'm sure but there was a general conversation on this some time back on another thread:

http://www.excelforum.com/excel-prog...eferences.html

Of course in the above as new libraries are created by MS so the Select Case in the above would require update.