Checking version of Excel from VBA in Access?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kjell - 16 Jan 2006 11:20 GMT

Hi,
How will the VBA-code look like to check which version an Office-program
(Excel)has. I need to do so and quit the macro if the Office program is too
old.

Signature

Kjell

Reply to this Message

Dirk - 16 Jan 2006 11:30 GMT

Assuming you want to check wether it's Excel 2003 (untested):

Dim objExcel as Object
Set objExcel = CreateObject("Excel.Application")
If objExcel.Version < 11.0 Then
MsgBox "Excel needs to be at least version 2003"
Exit Sub
End If

> Hi,
> How will the VBA-code look like to check which version an Office-program
> (Excel)has. I need to do so and quit the macro if the Office program is too
> old.

Reply to this Message