Re: Office 2000 - Office 2003

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

In 2000 the reference to the Outlook Library is:

C:\Program Files\Microsoft Office\Office10\msoutl.olb

That would suggest the system has Excel 2000 and Outlook from Office 2002
(it might also have Outlook 2000)

If you save your project on a machine that only has Outlook 2000 it should
work on all versions from 2000 on. Also ensure your code only includes
methods supported by the earliest version, or cater for differences in later
versions (if any).

Regards,
Peter T


If you build and save your project on a system that only has
"EA" <NOSPAM@xxxxxxxxxxxx> wrote in message
news:44478f76$0$9233$ed2619ec@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am trying to write code that works on both in Excel 2000 and Excel 2003.
My problem is with the references.

In 2000 the reference to the Outlook Library is:

C:\Program Files\Microsoft Office\Office10\msoutl.olb

In 2003 it is:

C:\Program Files\Microsoft Office\Office11\msoutl.olb

I would like to enter some code in the Open event of the workbook that
checks the environment and adds the correct reference without producing an
error.

Any help or references would be appreciated.




.

Relevant Pages

  • Machines Think They Outlook 2003 When They Actually Have a Previous Version...
    ... and Outlook to write Construction Management applications. ... All of these customers are using ... Project References a little closer. ... I've had to remove the 9.2 folder. ...
    (microsoft.public.office.developer.vba)
  • Re: activex address retrieve
    ... It should be listed in the Available References as Safe Address Book ... Sue Mosher, Outlook MVP ... >> Outlook 2003 includes an Address Book ActiveX control that installs on ... >> Outlook Express has such a minimal programming model that I doubt it has ...
    (microsoft.public.office.developer.outlook.vba)
  • Re: Two problems sending an E-mail for Outlook 2007 and VB 2005
    ... Sue Mosher would never post code that uses a collection object in place of an item object, my guess is that you modified her code improperly. ... I have no problems getting an Account object by using the name of the Account in place of the Index property for Accounts.Itemor by iterating the Accounts collection and checking for the Account display name. ... You should never use more than one Outlook reference in your code if I understand you correctly. ... In the project references you just reference the correct Outlook PIA for managed code and use that. ...
    (microsoft.public.outlook.program_vba)
  • Re: Programatically changing references between runtime environments 97-2000-2002
    ... >I support access applications that are run in runtime environments for our ... > the Outlook dll library for certain emailing abilities. ... the references are for Outlook 9 Library. ... > references upon installation or start up in a runtime environment. ...
    (microsoft.public.access.devtoolkits)
  • Re: Trim function wont work in VBA
    ... spreadsheet to Outlook 11. ... etc references will change to whatever the most current ... and then checked the Outlook 9 ref, the spreadsheet code worked. ... then you most likely will need to un-install Excel ...
    (microsoft.public.excel.programming)