Any library issues when giving XL2003 wkbk to XL2000/2002 users?

[Ed from AZ]

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

 

[Chip Pearson]

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]

Thanks, Chip. I appreciate the boost.

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 Consultingwww.cpearson.com
(email on the web site)








- Show quoted text -