Solved

Check version

Posted on 2016-10-18
13
60 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
Comment Utility
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
Comment Utility
Many thanks Ryan.

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

Expert Comment

by:Ryan Chong
Comment Utility
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
Comment Utility
Sorry, can we check this, directly within Excel?
0
 
LVL 49

Expert Comment

by:Ryan Chong
Comment Utility
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
Comment Utility
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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 49

Expert Comment

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

Author Comment

by:HuaMinChen
Comment Utility
To see the version details like
8q.png
0
 
LVL 49

Assisted Solution

by:Ryan Chong
Ryan Chong earned 250 total points
Comment Utility
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
Comment Utility
Thanks Ryan.

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

Expert Comment

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

Expert Comment

by:Eirman
Comment Utility
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
Comment Utility
ABOUT
No VBA needed!
It's the same method for Word 2007 etc.
0

Featured Post

The problems with reply email signatures

Do you wish that you could place an email signature under a reply? Well, unfortunately, you can't. That great Exchange/Office 365 signature you've created will just appear at the bottom of an email chain. What a pain! Is there really no way to solve this? Well, there might be...

Join & Write a Comment

Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
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…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
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…

772 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

10 Experts available now in Live!

Get 1:1 Help Now