Is there a good way to tell the VBE to use an older version of excel's object
model. Either when generating code or compiling code? I have loaded
MSOffice XP 2003 and now I'm wanting to make sure that I create code that
will still work on older versions.

What are some "best practices" on how to accomplish this using only 1 PC for
development.

--
Regards,
John

You can have multiple versions of Excel on one machine. Just
install them oldest to newest in separate directories. Do all
your development in the earliest version you need to support.


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


"John Keith" wrote in
message
...
Is there a good way to tell the VBE to use an older version of
excel's object
model. Either when generating code or compiling code? I have
loaded
MSOffice XP 2003 and now I'm wanting to make sure that I create
code that
will still work on older versions.

What are some "best practices" on how to accomplish this using
only 1 PC for
development.

--
Regards,
John