Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 92
  • Last Modified:

Check version

Hi,
I want to check the version details within Excel 2007. How?
0
HuaMinChen
Asked:
HuaMinChen
  • 6
  • 5
  • 2
2 Solutions
 
Ryan ChongCommented:
try look into Application object.

Application.Version Property (Excel)
https://msdn.microsoft.com/en-us/library/office/ff193301.aspx

Excel version and Office language settings
http://www.rondebruin.nl/win/s9/win012.htm
0
 
HuaMinChenBusiness AnalystAuthor Commented:
Many thanks Ryan.

Where to choose application below?
8p.png
0
 
Ryan ChongCommented:
you got to do it in Macro. the VBA instead, if you want to return it into a cell, you will need to define a Function in macro instead.
28977303.xlsm
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
HuaMinChenBusiness AnalystAuthor Commented:
Sorry, can we check this, directly within Excel?
0
 
Ryan ChongCommented:
you're right!

find this:

=INFO("RELEASE")

Open in new window


MS Excel: How to use the INFO Function (WS)
https://www.techonthenet.com/excel/formulas/info.php
0
 
HuaMinChenBusiness AnalystAuthor Commented:
Hi Ryan,
I know VBA is one way to know Excel's release version. But how to get the following
8q.png
within Excel? This is what I've got, from some other people.
0
 
Ryan ChongCommented:
the image is a bit unclear, which info you wish to extract here?
0
 
HuaMinChenBusiness AnalystAuthor Commented:
To see the version details like
8q.png
0
 
Ryan ChongCommented:
if you want to get the build info, you can try refer to: Application.Build

Function GetVersion() As String
    GetVersion = Application.Version & " " & Application.Build
End Function

Open in new window

I can't find other methods to get such info.
0
 
HuaMinChenBusiness AnalystAuthor Commented:
Thanks Ryan.

I sent you one message for one other thread. Did you see my message?
0
 
Ryan ChongCommented:
Hi, I will only try to answer questions posted in EE.
0
 
EirmanChief Operations ManagerCommented:
Click on the round office button in excel 2007 .... then ....
Excel options > Resources > About Microsoft Office Excel 2007 (About button)
0
 
EirmanChief Operations ManagerCommented:
ABOUT
No VBA needed!
It's the same method for Word 2007 etc.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now