Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using foreign characters | Excel Discussion (Misc queries) | |||
Excel in a foreign language | Excel Discussion (Misc queries) | |||
Foreign Exchange | Excel Discussion (Misc queries) | |||
how do I add accents for foreign words when using excel? | Excel Discussion (Misc queries) | |||
Help: foreign key reference in Excel | Excel Programming |