Hi there,
I have an Excel file which I use both at home and at work. I have 2003 installed at home and 2007 at work.
I keep running into the same problem whereby I have to keep changing the Outlook Object reference each time I want to use a macro depending where I am (the reference has MISSING next to it).
I'm sure there is a way where I can programatically set the reference whenever I start the macro, but I can't remember what it is. Something to do with navigating through the menus, like:-
Thanks in advance,
Paul.
I have an Excel file which I use both at home and at work. I have 2003 installed at home and 2007 at work.
I keep running into the same problem whereby I have to keep changing the Outlook Object reference each time I want to use a macro depending where I am (the reference has MISSING next to it).
I'm sure there is a way where I can programatically set the reference whenever I start the macro, but I can't remember what it is. Something to do with navigating through the menus, like:-
Code:
On Error Resume Next
Application.????????.("Microsoft Outlook 11.0 Object Library")
Application.????????.("Microsoft Outlook 12.0 Object Library")
On Error GoTo 0
Thanks in advance,
Paul.