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

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" wrote in message
.com...
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