ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Version Number Property (https://www.excelbanter.com/excel-programming/369926-version-number-property.html)

geoffkb[_2_]

Version Number Property
 

I need to check the version of Excel which my users are running my
spreadsheet. info("relaease") gives me the version number (11.0 for
2003). How do I get this programmatically so I can include it in my
code?

Thanks


--
geoffkb
------------------------------------------------------------------------
geoffkb's Profile: http://www.excelforum.com/member.php...o&userid=37209
View this thread: http://www.excelforum.com/showthread...hreadid=570154


Ron de Bruin

Version Number Property
 
Use this

Val(Application.Version)

--
Regards Ron de Bruin
http://www.rondebruin.nl



"geoffkb" wrote in message
...

I need to check the version of Excel which my users are running my
spreadsheet. info("relaease") gives me the version number (11.0 for
2003). How do I get this programmatically so I can include it in my
code?

Thanks


--
geoffkb
------------------------------------------------------------------------
geoffkb's Profile: http://www.excelforum.com/member.php...o&userid=37209
View this thread: http://www.excelforum.com/showthread...hreadid=570154




Bob Phillips

Version Number Property
 
Val(Application.Version)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"geoffkb" wrote in
message ...

I need to check the version of Excel which my users are running my
spreadsheet. info("relaease") gives me the version number (11.0 for
2003). How do I get this programmatically so I can include it in my
code?

Thanks


--
geoffkb
------------------------------------------------------------------------
geoffkb's Profile:

http://www.excelforum.com/member.php...o&userid=37209
View this thread: http://www.excelforum.com/showthread...hreadid=570154




geoffkb[_3_]

Version Number Property
 

Thanks to you both, that was exactly what I needed. I really appreciate
that.

Geoff


--
geoffkb
------------------------------------------------------------------------
geoffkb's Profile: http://www.excelforum.com/member.php...o&userid=37209
View this thread: http://www.excelforum.com/showthread...hreadid=570154



All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com