macro to check the version of excel that is running and proceed depending on the ver.

**wace** · 09-15-2009, 04:44 PM

Hi,

I am wondering if there is a way to have a macro check to see what version of excel is running and then based on the version perform one of two macros.

I.E.
If the user running the macro has excel 2007, then run the macro which creates the flashy themed pivot tables and reports.
If the user is running the macro in excel 2003, then run the macro which creates a 2003 friendly version without themes, etc.

Most of the workbooks I create are within excel 2007 but saved as .xls files as I send them out to users running excel 2003 as well as 2007.

Anyone know of a way to do this?

Thanks!!

Billy

**shg** · 09-15-2009, 09:48 PM

    Select Case Left(Application.Version, 2)
        Case "12"
            ' Excel 2007 - run fancy macro
        Case "11"
            ' Excel 2003 = run simple macro
        Case "10"
            ' Excel XP - run something else
        Case Else
            ' Excel 2000 & earlier - hope for the best
    End Select

Thread: macro to check the version of excel that is running and proceed depending on the ver.

Thread Tools

Display

macro to check the version of excel that is running and proceed depending on the ver.

Re: macro to check the version of excel that is running and proceed depending on the

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions