remove reference via code
 

Hello

I'm trying to work out how to remove a reference (to Microsoft Outlook
9.0 Object Library) automatically from code when the spreadsheet is
opened. I've found application.VBE.VBProjects(1).References from just
rooting around but can't work out (or find any documentation on) how
to actually remove a reference.

Is this possible? Am i barking up the wrong tree? Please help

Thanks in advance

remove reference via code
 

Brian,

You need to pass the Remove procedure a valid reference Object:

ThisWorkbook.VBProject.References.Remove _
ThisWorkbook.VBProject.References.Item("Outlook")

HTH,
Bernie
MS Excel MVP

"Brian" wrote in message
om...
Hello

I'm trying to work out how to remove a reference (to Microsoft Outlook
9.0 Object Library) automatically from code when the spreadsheet is
opened. I've found application.VBE.VBProjects(1).References from just
rooting around but can't work out (or find any documentation on) how
to actually remove a reference.

Is this possible? Am i barking up the wrong tree? Please help

Thanks in advance