Macro Command to Determine to Determine		  
  Which Version of Excel and Windows is Running
  Back
 

A simple macro to determine which version of Excel and Windows is running: 

  Sub WhatVer()

  vXLVersion = Application.Version
 vWINVersion = Application.OperatingSystem
 MsgBox  vXLVersion & "    " & vWINVersion
  End Sub

The above macro uses variables and then displays the variables in a Message Box. The following macro accomplishes the same thing, a little more direct:
 

  Sub WhatVer()

  MsgBox ("Excel Version #:  " & Application.Version & _      "Windows Version: " & Application.OperatingSystem)
 End Sub 
 

This macro should run in Excel versions 5 and after.
 
 
 
 

 
 
Top

 
 
 
 
 

 

solutions@info-stat.com