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.
|