0

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?

2
Contributors
3
Replies
6
Views
7 Years
Discussion Span
Last Post by AndreRet
0

Yes you can -

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

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.