Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Check version

Posted on 2016-10-18
13
Medium Priority
?
89 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 54

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 11

Author Comment

by:HuaMinChen
ID: 41849419
Many thanks Ryan.

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

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
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 
LVL 11

Author Comment

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

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 11

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 54

Expert Comment

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

Author Comment

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

Assisted Solution

by:Ryan Chong
Ryan Chong earned 1000 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 11

Author Comment

by:HuaMinChen
ID: 41849651
Thanks Ryan.

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

Expert Comment

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

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 24

Accepted Solution

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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

971 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