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