I have Excel 2003 available. Some of my users may have Excel 2002 or
even 2000. I have the following libraries references in the VBA
project for this workbook:
-- Visual Basic for Applications
-- MS Excel 11.0 Object Library
-- OLE Automation
-- MS Office 11.0 Object Library
-- MS Forms 2.0 Object Library
-- MS Scripting Runtime

Will Excel automatically pick up the correct library reference when
the other user opens it? If not, how do I make sure the correct
library gets attached?

Are there any other libraries I'm likely to have problems with?

Ed

Ed,

You shouldn't have any problems supporting Office 2002 or 2000 as long as
you don't attempt to use any features that were added in a later release
than the user will have on a machine. Thus, as long as you stick to features
that were present in 2000, the code should work for all your users.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Ed from AZ" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have Excel 2003 available. Some of my users may have Excel 2002 or
> even 2000. I have the following libraries references in the VBA
> project for this workbook:
> -- Visual Basic for Applications
> -- MS Excel 11.0 Object Library
> -- OLE Automation
> -- MS Office 11.0 Object Library
> -- MS Forms 2.0 Object Library
> -- MS Scripting Runtime
>
> Will Excel automatically pick up the correct library reference when
> the other user opens it? If not, how do I make sure the correct
> library gets attached?
>
> Are there any other libraries I'm likely to have problems with?
>
> Ed
>

Thanks, Chip. I appreciate the boost.

Ed


On Aug 29, 12:43 pm, "Chip Pearson" <c...@cpearson.com> wrote:
> Ed,
>
> You shouldn't have any problems supporting Office 2002 or 2000 as long as
> you don't attempt to use any features that were added in a later release
> than the user will have on a machine. Thus, as long as you stick to features
> that were present in 2000, the code should work for all your users.
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consultingwww.cpearson.com
> (email on the web site)
>
> "Ed from AZ" <prof_ofw...@yahoo.com> wrote in messagenews:(E-Mail Removed)...
>
>
>
> >I have Excel 2003 available. Some of my users may have Excel 2002 or
> > even 2000. I have the following libraries references in the VBA
> > project for this workbook:
> > -- Visual Basic for Applications
> > -- MS Excel 11.0 Object Library
> > -- OLE Automation
> > -- MS Office 11.0 Object Library
> > -- MS Forms 2.0 Object Library
> > -- MS Scripting Runtime
>
> > Will Excel automatically pick up the correct library reference when
> > the other user opens it? If not, how do I make sure the correct
> > library gets attached?
>
> > Are there any other libraries I'm likely to have problems with?
>
> > Ed- Hide quoted text -
>
> - Show quoted text -