My question is:
how can I programmatically detect MS Excel Version , like for example Excel 2000 or 2002, 2003, 98 .... and so on
thanks a lot for your help
Printable View
My question is:
how can I programmatically detect MS Excel Version , like for example Excel 2000 or 2002, 2003, 98 .... and so on
thanks a lot for your help
Well, you could do something like this:
VB Code:
Dim xlApp As Object Dim dblVersion As Double Set xlApp = CreateObject("Excel.Application") dblVersion = xlApp.Version Set xlApp = Nothing
Version 7.0 = Excel 95
Version 8.0 = Excel 97
Version 9.0 = Excel 2000
Version 10.0 = Excel 2002
Version 11.0 (Current) = Excel 2003 :)
Cheers,
RyanJ