VBA project migration Office 2003 to Office 2000

[wwcoop]

I have been developing a macro
using Microsoft Office 2003.
The macro uses both Excel and
Word Object model references.

I need to deploy this macro in an
office environment that only uses
Microsoft Office 2000.

Naturally, if I try to run the Macro
in the Office 2000 enviroment I
get an error, because the 2000
enviroment uses the 10.0 object
model reference and the 2003
environment uses the 11.0 object
model reference.

What is the best solution to migrate
my macro back to the Office 2000
environment?

Are there substantial differences
between 2000 and 2003 that will
effect my VBA coding?

What's the best way to proceed?

Thanks!

 

[Chip Pearson]

Your safest bet is to use Late Binding. Declare every Word and
Excel object As Object rather than, say, As Workbook. You'll have
to change all the symbolic constants, e.g., xlUp, to the numeric
values. This way, it won't matter what version your users have.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com