Solved

Check version

Posted on 2016-10-18
13
79 Views
Last Modified: 2016-10-22
Hi,
I want to check the version details within Excel 2007. How?
0
Comment
Question by:HuaMinChen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
  • 2
13 Comments
 
LVL 51

Expert Comment

by:Ryan Chong
ID: 41849406
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
 
LVL 10

Author Comment

by:HuaMinChen
ID: 41849419
Many thanks Ryan.

Where to choose application below?
8p.png
0
 
LVL 51

Expert Comment

by:Ryan Chong
ID: 41849423
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 10

Author Comment

by:HuaMinChen
ID: 41849426
Sorry, can we check this, directly within Excel?
0
 
LVL 51

Expert Comment

by:Ryan Chong
ID: 41849428
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
 
LVL 10

Author Comment

by:HuaMinChen
ID: 41849438
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
 
LVL 51

Expert Comment

by:Ryan Chong
ID: 41849440
the image is a bit unclear, which info you wish to extract here?
0
 
LVL 10

Author Comment

by:HuaMinChen
ID: 41849452
To see the version details like
8q.png
0
 
LVL 51

Assisted Solution

by:Ryan Chong
Ryan Chong earned 250 total points
ID: 41849476
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
 
LVL 10

Author Comment

by:HuaMinChen
ID: 41849651
Thanks Ryan.

I sent you one message for one other thread. Did you see my message?
0
 
LVL 51

Expert Comment

by:Ryan Chong
ID: 41849739
Hi, I will only try to answer questions posted in EE.
0
 
LVL 23

Expert Comment

by:Eirman
ID: 41849903
Click on the round office button in excel 2007 .... then ....
Excel options > Resources > About Microsoft Office Excel 2007 (About button)
0
 
LVL 23

Accepted Solution

by:
Eirman earned 250 total points
ID: 41849911
ABOUT
No VBA needed!
It's the same method for Word 2007 etc.
0

Featured Post

Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article summaries thoughts and ideas from two years of sustained use. It provides good reasoning to make the jump to Windows 10.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question