Detect Excel Version

[Stacy Haskins]

Anyone know the code, if possible, to detect which
version of Excel was used to open the file?

-Stacy

 

[Chip Pearson]

Stacy,

The Application.Version property will return a string indicating
the version of Excel you are using.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[losmac]

Sub nasdfgh()
MsgBox Application.Version
End Sub