Could you provide some example code that works in 2000 and bombs
in 2002?


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


"Wboson" wrote in message
...
Thank You Norman.

The reason I tried using the Excel 2002 (XP) version w/VBA
macros is because
people with Excel 2002 had errors running the workbook created
in Excel 2000.
This is because Microsoft changed the underlying object model
between the two
versions. There we no runtime errors in the Excel 2000 workbook
version
except when used with Excel 2002.

Thus the lower common denominator did not work for those who
upgraded.

There lies my dilemna; how do I support two different object
models w/VBA
code?
--
John



"Norman Jones" wrote:

Hi John,

Our firm deploys different versions of Microsoft Office:
Office 2000,
Office
XP and now Office 2005. How do I code in VBA from Office &
Excel XP (2003)
to be compatible across the object models of these versions
of Excel?

You should always code to the lowest common denominator, i.e.
develop your
code in the lowest version which may be encountered.

If, conversely, code is developed in a later version, then use
of new
features will, necessarily, cause run-time errors when the
code is run under
an older version.

2nd question: Is there a method to reduce the size of a
workbook with many
sheets and macros. The workbook size is above 1.5 mb; the
user community
desires smaller sizes to enable faster email upload/download
times.

If the workbook size seems disproportionately large:
(1) Consider downloading Rob Bovey's CodeCleaner addin
which is freely
downloadable at:

http://www.appspro.com/Utilities/Utilities.htm

(2) See Debra Dalgleish's notes on the UsedRange and
filesize at:

http://www.contextures.com/xlfaqApp.html#Unused


You might also wish to consider moving code from the workbook
to an addin.

---
Regards,
Norman



"Wboson" wrote in message
...
Our firm deploys different versions of Microsoft Office:
Office 2000,
Office
XP and now Office 2005. How do I code in VBA from Office &
Excel XP (2003)
to
be compatible across the object models of these versions of
Excel?

There seems to be differences in the object models and
functions and/or
constants that are available for setting properties. I am
having problems
with borders, colors and formatting of cells from one
version to the next.
VBA based macros that work in one version generate a
run-time error in a
different version.

2nd question: Is there a method to reduce the size of a
workbook with many
sheets and macros. The workbook size is above 1.5 mb; the
user community
desires smaller sizes to enable faster email upload/download
times.

Thank You for your consideration.
--
John