Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 81
Default checking Excel version number

Hi all,

I use this:

xlVer = CLng(Left(Application.Version, 2))

Do you think it's reliable for any version, system,
language?

Regards,
Peter

-----Original Message-----
"Alan Beban" skrev i melding
...
Hi Harald,

I ran the following in xl2000 (Version 9.0)

(snip)
and it printed this

1 9.0 newer than 8
3 9.0 newer than "8"
5 9 newer than 8

What's going on?


Beats me Alan. This is the result from my XL2000 on

norwegian WinXP /
regional settings:

1 13 Type mismatch
1 9.0 newer than 8
2 13 Type mismatch
2 9.0 older than 8
3 9.0 newer than "8"
5 9 newer than 8

I don't have anything but 9 and 11 on this machine, so I

can't test further
until tonight.

Best wishes harald


.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TRacking Version Number in Excel 2007 deejay Excel Discussion (Misc queries) 2 June 5th 08 11:05 PM
how can you insert a version number in excel ? deejay Excel Worksheet Functions 2 June 4th 08 10:30 PM
Is the Excel Version Number Embedded in a File Tim Childs Excel Discussion (Misc queries) 2 April 26th 07 07:02 AM
From where i can get list of all released version number of Excel Dev Excel Discussion (Misc queries) 0 December 14th 05 09:19 AM
Recover earlier version of excel sheet after new version saved? stephanie38 Excel Discussion (Misc queries) 3 June 17th 05 03:52 AM


All times are GMT +1. The time now is 09:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"