XP

[jacqui]

I am an Excel 97 user and have coded several spreadsheets
using this version. I've just been told that the company
will be rolling out XP in a few weeks time. Can anyone
let me know, at a very high level, if there is anything I
should specifically watch out for because I've been told
by one of the departments here that my macros will not
work under XP. I don't really understand what they mean
by this, can anyone kindly help?
Many thanks
Jacqui

 

[Jan Karel Pieterse]

Hi Jacqui,

because I've been told
by one of the departments here that my macros will not
work under XP. I don't really understand what they mean
by this, can anyone kindly help?

As far as I know, macros created under XL97 work fine in Excel XP.
I haven't had to work around a problem yet in which a macro worked in
97 and not in XP. The other way around is a different story.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Nigel]

Hi Jacqui

I often develop applications in Excel 97 in an Windows NT environment then
pass them into my home setup XP / Excel 10 and have never had a problem. As
stated elsewhere making changes in the Excel 10 environment and passing them
back is another story....

Cheers
Nigel

 

[Rob van Gelder]

I've recently been involved with an Excel migration from 97 to XP. Macros
and worksheet formulas continued to work fine. It was probably one of the
smoothest version transitions I've been involved with.

One thing to watch is the security features in Office XP. Depending on your
security level, and whether the code is "trusted"...
VBA: It can prevent self-modifying code from running. It can ask the user
about whether to run the code or not.
Outlook: It can prevent code from doing non-interactive things, such as
searching the address book, sending e-mails on your behalf, etc...

Microsoft have tools/documentation for allowing your code to be trusted