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

  • Thread starter Thread starter Ed from AZ
  • Start date Start date
E

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
 
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)
 
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 -
Click to expand...
 
Back
Top