late binding in VBA

[Grey]

I have to link MS outlook to send email in MS Excel and I know it needs to use msoutl.olb Object Library for link the outlook with excel. However, there would be different object library version in different office.

What I need to do is first Check what office version is in the PC, and then use LATE BINDING to refer the object library. Am I right to do that? If so, can anyone teach me how to such late binding in Excel as I don't have any ideas .


Million Thanks

Eric

 

[JE McGimpsey]

Yes - late binding is generally most appropriate for working with
different versions of Office.

You can find lots of articles in the archies on late binding:

http://groups.google.com/advanced_group_search?q=group:*excel*


Use "late binding" as an exact search phrase.

 

[Tom Ogilvy]

No, you don't need to check the version. That is why you late bind.

I provided you an excellent reference to it. Look at your previous thread.

--
Regards,
Tom Ogilvy


I have to link MS outlook to send email in MS Excel and I know it needs to
use msoutl.olb Object Library for link the outlook with excel. However,
there would be different object library version in different office.

What I need to do is first Check what office version is in the PC, and then
use LATE BINDING to refer the object library. Am I right to do that? If so,
can anyone teach me how to such late binding in Excel as I don't have any
ideas .


Million Thanks

Eric