Solved

Check version

Posted on 2016-10-18
13
70 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 49

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 49

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
 
LVL 10

Author Comment

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

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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 49

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 49

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 49

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

896 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

15 Experts available now in Live!

Get 1:1 Help Now