Member Avatar for 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?

  • 2 Contributors
  • 3 Replies
  • 506 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by AndreRet

Recommended Answers

All 3 Replies

Member Avatar for AndreRet

Yes you can -

Dim objXL As Excel.Application
Set objXL = New Excel.Application
MsgBox objXL.Version
Member Avatar for leverin4

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

Member Avatar for AndreRet

Only a pleasure.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.