VB for Excel/Foreign OS
 

I've written a small macro which includes the following two commands:
varVer=Application.Version
varBld=Application.Build

When I run this macro on a machine with Excel 2000 (fully patched with
Office Updates) running on a Windows XP (U.S. installation) the version is
returned as 9 and the build is 8924.

When I run this macro on a machine with Excel 2000 (fully patched with
Office Updates) running on a Windows XP (German installation) the version is
returned as 9 and the build is 90 and the build is 2719.

I guess I would have presumed that the OS language would not affect the
build number. And most definitely would not have affected the version number.

Can anyone tell me . . .
1. Can I safely anticipate that all non-U.S. language versions of Windows XP
running Excel 2000 will return a version of 90, versus 9 when using a U.S.
language OS? Would this be the same for other versions of Excel (v10/v100 or
v11/v110)?
2. Can I safely anticipate that all non-U.S. language versions of Windows XP
running Excel version x will have the same build number?
3. Is there a definitive chart anywhere showing current versions and builds
for Excel 9 (Office 2000), Excel 10 (Office XP), and Excel 11 (Office 2003)?

Thanks to anyone who can give me some pointers.

VB for Excel/Foreign OS
 

the version is returned as a string e.g. "9.0"

depending on regional settings the "."
MAY be interpreted as a decimal separator.
on assigning it to a variant.

assign it to a STRING variable and you'll see.

use varVer = VAL(application.version) to get consistency.




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Nyle wrote :

I've written a small macro which includes the following two commands:
varVer=Application.Version
varBld=Application.Build

When I run this macro on a machine with Excel 2000 (fully patched
with Office Updates) running on a Windows XP (U.S. installation) the
version is returned as 9 and the build is 8924.

When I run this macro on a machine with Excel 2000 (fully patched
with Office Updates) running on a Windows XP (German installation)
the version is returned as 9 and the build is 90 and the build is
2719.

I guess I would have presumed that the OS language would not affect
the build number. And most definitely would not have affected the
version number.

Can anyone tell me . . .
1. Can I safely anticipate that all non-U.S. language versions of
Windows XP running Excel 2000 will return a version of 90, versus 9
when using a U.S. language OS? Would this be the same for other
versions of Excel (v10/v100 or v11/v110)?
2. Can I safely anticipate that all non-U.S. language versions of
Windows XP running Excel version x will have the same build number?
3. Is there a definitive chart anywhere showing current versions and
builds for Excel 9 (Office 2000), Excel 10 (Office XP), and Excel 11
(Office 2003)?

Thanks to anyone who can give me some pointers.

VB for Excel/Foreign OS
 

To complete your enquiry:

2. No, patches might be language specific, and MS does not roll out
patches for all languages in one go.

3. No (but maybe at MS;) this build number is a running target that
changes with each patch that is issued.

DM unseen