J
Jon
Is there a way, using VBA, to determine the version of Excel that is
running?
running?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
bigwheel
Jon said:Is there a way, using VBA, to determine the version of Excel that is
running?
This is from the help file ...
MsgBox "Welcome to Microsoft Excel version " & _
Application.Version & " running on " & _
Application.OperatingSystem & "!"
D
Dave Peterson
MsgBox Application.Version
Is there a way, using VBA, to determine the version of Excel that is
running?
C
CLR
Someone in the group gave me this a while back when I had 4 versions of
excel on my computer and couldn't remember which one I had open...........it
puts the "version" in the upper title bar..........
Sub Auto_open()
With Application
Select Case Val(.Version)
Case 10: .Caption = .Name & " 2002"
Case 9: .Caption = .Name & " 2000"
Case 8: .Caption = .Name & " 97"
Case 7: .Caption = .Name & " 95"
End Select
End With
End Sub
excel on my computer and couldn't remember which one I had open...........it
puts the "version" in the upper title bar..........
Sub Auto_open()
With Application
Select Case Val(.Version)
Case 10: .Caption = .Name & " 2002"
Case 9: .Caption = .Name & " 2000"
Case 8: .Caption = .Name & " 97"
Case 7: .Caption = .Name & " 95"
End Select
End With
End Sub