Thread: VBA references
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default VBA references

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