Excel Version in VB6

[leverin4]

Is it possible to check which version of Excel a user's computer will open while in a VB6 application?

Some users will be using Excel 2003 and some will be using Excel 2007 and, in theory, a single command button will open one of two excel sheets based on which version they have. Is that possible?

[AndreRet]

Yes you can -

Dim objXL As Excel.Application
Set objXL = New Excel.Application
MsgBox objXL.Version

[leverin4]

I hoped/figured there was something simple like that. Thanks, you're a lifesaver.

[AndreRet]

Only a pleasure.