VBA references

[Greg]

I have some VBA code that creates and sends an e-mail. I'm using
msoutl.olb (Outlook library).
The problem is that the spreadsheet runs on versions of excel from 2000 to
2003.
In 2000 the library is called msout9.olb.
Is there a way to have somewhere in the vba code, the library name?
Or is there another solution?
Greg

[Bob Phillips]

You could develop it Excel 2000 using its type library, and release to that
and later versions, it will update automatically.

Or you could late bind. See http://xldynamic.com/source/xld.EarlyLate.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Greg" <[email protected]> wrote in message
news:[email protected]...
> I have some VBA code that creates and sends an e-mail. I'm using
> msoutl.olb (Outlook library).
> The problem is that the spreadsheet runs on versions of excel from 2000 to
> 2003.
> In 2000 the library is called msout9.olb.
> Is there a way to have somewhere in the vba code, the library name?
> Or is there another solution?
> Greg
>