Programatically set Outlook reference

[LEXCERM]

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:-

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.

 

[Norie]

I think there is a way to set the reference programatically.

But why not avoid the need for the reference in the first place by using late binding?

 

[LEXCERM]

Thanks for the pointer Norie. I'll search late binding now.

Cheers,
Paul.

 

[LEXCERM]

BTW, that late binding works perfectly. Thanks for the tip.

One final point which you may be able to help me with please. When I am attaching a file to the e-mail, I am saving the file as follows:-

ActiveWorkbook.SaveAs name_of_file.

I want to now be specific and save it in 2003 file format, i.e. .SaveAs name_of_file, FileFormat:=xlExcel7, but when the code runs it seems to crash the program.

What would be the file format for 2003?

Cheers,
Paul.