Outlook 9.0 Object Library

I have an interesting problem with an Excel Spreedsheet that was created in Office 2000. The References used the Outlook 9.0 Object Library. I am able to run in fine moving from Office 2000 to Office 2003. When I move from a computer that has Office 2003, the spreadsheet is updated automatically to where the References use the Outlook 11.0 Object Library. The problem is when I need to use that spreadsheet back on a computer that uses Office 2000. The Reference shows the Outlook 11.0 Object Library missing. Which I know is true b/c I'm on Office 2000.

Any suggestions on how to correct this problem? I thought about creating two different version, but once I open a 9.0 version in XP, it upgrades the References to 11.0.

Is there a way to dynamically at the Outlook 9.0 Object Library if needed?

Thank you,

Ken

[887 byte] By [KJ777] at [2008-1-7]
# 1
Hi,

Have a look at using late binding.
http://www.xldynamic.com/source/xld.EarlyLate.html

AndyPope at 2007-10-2 > top of Msdn Tech,Microsoft ISV Community Center Forums,Visual Basic for Applications (VBA)...