Solved

Check version

Posted on 2016-10-18
13
74 Views
Last Modified: 2016-10-22
Hi,
I want to check the version details within Excel 2007. How?
0
Comment
Question by:HuaMinChen
  • 6
  • 5
  • 2
13 Comments
 
LVL 50

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 50

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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 10

Author Comment

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

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 50

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 50

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 50

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
How to record audio from input sources to your PC – connected devices, connected preamp to record vinyl discs, streaming media, that play through your audio card: Vista, Windows 7, Windows 8, Windows 8.1 and Windows 10 – both 32 bit & 64.
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

813 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now