different versions of Excel

[bob engler]

I have WBs with various Macros I developed under Excel2002/WINXP.
The customer I developed it for has many different systems, from
WIN98, 2000, XP, NT and Excel 2002, 2000 and 97. I have gotten the
same set of WBs/Macros to work on their systems with Win2000, 98
and XP with Excel2000 and 2002. When I try it with Win98 with Excel97,
it works but says that the files were created using a later version of
Excel ( as they were ). The Macros create a set of WBs with many sheets
via a organizational chart from base WBs. Is there a way to regen these
WBs so they will not generate these messages since they will generate
calls by the users everyday eventhough all they have to do is select "Yes".

It all boils down to can I make 1 version of the WBs/Macros that will run
on all of their systems so we don't have to keep up with whom has which
version. Also, as they upgrade software versions, the WBs would work
without getting new versions of the WBs/Macros.



Thanks.......

 

[Harald Staff]

"bob engler" <[email protected]> skrev i melding
(..)

It all boils down to can I make 1 version of the WBs/Macros that will run
on all of their systems so we don't have to keep up with whom has which
version.

Develop on the lowest version and it runs fine on all later versions. So
write in Excel97, everything else is like working in total darkness.
When it comes to operating system it's a little worse. Win95/98/ME is the
last of DOS, while WinNT/2000/XP is ...ehhh... <censored>. But in general
those are the two Windows families and you have to test on some version of
both, there are a few differences. Windows XP is also <more deletions> when
it comes to refusing the user to do anything on her computer, everything is
a violation of some security rule, so test everything on Windows XP with
non-admin priviledges.

HTH. Best wishes Harald