Removeing an Object Library Reference with VBA runtime error 9

[Liz_I3]

Hi am working with Access 2010. I am want to remove a reference from the library with VBA
I am using the below function
Public Sub RemoveReference(strReferenceName As String)
Access.References.Remove Access.References(strReferenceName)
End Sub

Calling from an Event Procedure

Call RemoveReference("Microsoft Outlook 14.0 Object Library")

I have also tried RemoveReference("C:\Program Files (x86)\Microsoft Office\Office14\MSOUTL.OLB") but keep getting Runtime Error9 Subscripted out of Range

What I am missing

Thanks
L

 

[xenou]

Re: Excel help please

Hi, welcome. Post your Excel questions in the Excel forum: Excel Questions

Provide as much information as you can as your question seems difficult and would definitely require more information for anyone to be able to assist.

Good luck,
Xenou.