detect - MS Excel version

[andrzej]

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

[sciguyryan]

Well, you could do something like this:

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