SAving into Excel 2003 or 2007

August 12th, 2009, 09:08 AM

Hi

We are currently migrating our users from Office 2003 to 2007.
I have worksheets which include VBA modules, as some users are using 2003 and some 2007 I need the code to recognise the version being used, so that the code will save it correctly.
2003 needs to be "FileFormat:=xlNormal" and
2007 needs to be "FileFormat:=xlOpenXMLWorkbookMacroEnabled"

Any assistance would be gratefully received

Regards
Peter

stanleydgromjr · August 12th, 2009, 09:19 AM

ppenn,

This should help you get started in the right direction.

This will return the Excel version the user is using.

Code:

 
Sub ReturnExcelVersion()
    If Application.Version = "12.0" Then
        MsgBox "You are using Excel 2007."
    ElseIf Application.Version = "11.0" Then
        MsgBox "You are using Excel 2003."
    ElseIf Application.Version = "10.0" Then
        MsgBox "You are using Excel 2002."
    ElseIf Application.Version = "9.0" Then
        MsgBox "You are using Excel 2000."
    ElseIf Application.Version = "8.0" Then
        MsgBox "You are using Excel 97."
    ElseIf Application.Version = "7.0" Then
        MsgBox "You are using Excel 95."
    End If
End Sub

Have a great day,
Stan

August 12th, 2009, 09:35 AM

Works okay

Seems so simple when you know how

Peter