Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Excel Version
I need an API (I think) to find out the Excel version of the current user.
Based on that information I am going to create different macros. I made a spreadsheet with a "Sort" button in Excel 2003. One of my users is on Excel 2000, and it gives them a "variable not defined" error when trying to run the macro. So I was going to record it in Excel 2000 also, then when they click sort, figure which version they are running, and select the appropriate macro. I'm basically a noob at programming, so any help is appreciated. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Excel Version
You can use Application.Version to return the version of Excel.
Select Case CInt(Application.Version) Case 8 ' 97 Case 9 ' 2000 Case 10 ' 2002 Case 11 ' 2003 Case 12 ' not yet.. End Select -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "jweasl" wrote in message ... I need an API (I think) to find out the Excel version of the current user. Based on that information I am going to create different macros. I made a spreadsheet with a "Sort" button in Excel 2003. One of my users is on Excel 2000, and it gives them a "variable not defined" error when trying to run the macro. So I was going to record it in Excel 2000 also, then when they click sort, figure which version they are running, and select the appropriate macro. I'm basically a noob at programming, so any help is appreciated. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Excel Version
Hi jweasl
You can use If Val(Application.Version) = 9 Then -- Regards Ron de Bruin http://www.rondebruin.nl "jweasl" wrote in message ... I need an API (I think) to find out the Excel version of the current user. Based on that information I am going to create different macros. I made a spreadsheet with a "Sort" button in Excel 2003. One of my users is on Excel 2000, and it gives them a "variable not defined" error when trying to run the macro. So I was going to record it in Excel 2000 also, then when they click sort, figure which version they are running, and select the appropriate macro. I'm basically a noob at programming, so any help is appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you find the version of the EXCEL program??? | Excel Discussion (Misc queries) | |||
How do I find/open older version of file in Excel 2007? | Excel Discussion (Misc queries) | |||
download trial version excel 2003? can only find trial version 200 | Excel Discussion (Misc queries) | |||
Find Version of Excel workbook is saved as | Excel Discussion (Misc queries) | |||
How to find the version of Excel in code | Excel Programming |