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" wrote in message
ps.com...
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" 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" wrote in glegroups.com...



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 -