Version Compatibility

[Trisha B]

Our business has Office 2000 deployed across the
enterprise and I do all the development involving Office
products.

Recently, due to dependencies in a new application, some
users required Office XP.

Now these users are asking me to do development for them
for Office XP.

Since XP came out quite a while ago and we didn't upgrade
then, I've lost any information I've ever had on what, if
any, limitations there might be between VBA in Office 2K
and XP.

What I need to know is if the code I write in VBA for
Office 2K will need to be massaged once it enters the XP
environment or if it will run as written? (Or, in other
words, do I need to get XP installed on my machine and
write the code in it for those using Office XP?)

Thank you for any information you can provide.

Trisha

 

[Tarjei T. Jensen]

:
What I need to know is if the code I write in VBA for

Office 2K will need to be massaged once it enters the XP
environment or if it will run as written? (Or, in other
words, do I need to get XP installed on my machine and
write the code in it for those using Office XP?)

MS Office XP is backwards compatible to Office 2000.

There are things that *may* break, but in general: if you develop for Office
2000 it should be compatible with Office XP.

Anyway; you should add Office XP to your test environment.

Where I work we are now still at Office 97. This year we will transition our
desktops to Win XP and our Office XP (2002). All development now will target
Office 97 and Office XP.

greetings,

 

[Trisha B]

Thanks very much for your feedback. I have requested
Office XP be made available in our test environment.
There's just nothing quite as much fun as discovering your
code won't run on deployment.

Trisha

 

[Tom Winter]

Our business has Office 2000 deployed across the
enterprise and I do all the development involving Office
products.

Recently, due to dependencies in a new application, some
users required Office XP.

Now these users are asking me to do development for them
for Office XP.

Since XP came out quite a while ago and we didn't upgrade
then, I've lost any information I've ever had on what, if
any, limitations there might be between VBA in Office 2K
and XP.

What I need to know is if the code I write in VBA for
Office 2K will need to be massaged once it enters the XP
environment or if it will run as written? (Or, in other
words, do I need to get XP installed on my machine and
write the code in it for those using Office XP?)

Thank you for any information you can provide.

Trisha

Make sure you read this article:
INFO: Writing Automation Clients for Multiple Office Versions
http://support.microsoft.com/default.aspx?scid=kb;EN-US;244167