Using msoutl.olb

[Grey]

I am using MS Office XP to develope a VBA in excel. I need to interact with MS outlook, so I use the object library, msoutl.olb in the VBA. My problem is that can I deploy my VBA program using this object library file?? Is there any licenese I need to consider?? Because I found that some user are using different Office version, such as office 2000, office XP and office 2003. If I just copied the VBA to the user's machine without the object file, it did not work.

 

[Tom Ogilvy]

You need to remove the reference to outlook and use late binding. Your
declarations will have to be the generic object.

You will need to write you code so it is compatible with the lowest version
of outlook you will interact with.

You can't distribute the outlook object library and it won't work with other
versions of outlook anyway.

--
Regards,
Tom Ogilvy

I am using MS Office XP to develope a VBA in excel. I need to interact with
MS outlook, so I use the object library, msoutl.olb in the VBA. My problem
is that can I deploy my VBA program using this object library file?? Is
there any licenese I need to consider?? Because I found that some user are
using different Office version, such as office 2000, office XP and office
2003. If I just copied the VBA to the user's machine without the object
file, it did not work.

 

[Grey]

how to use late binding...

 

[Tom Ogilvy]

http://support.microsoft.com/default.aspx?kbid=245115
INFO: Using Early Binding and Late Binding in Automation

http://support.microsoft.com/default.aspx?scid=kb;EN-US;247579
INFO: Use DISPID Binding to Automate Office Applications Whenever Possible