Solved

Check version

Posted on 2016-10-18
13
82 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 52

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 52

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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 10

Author Comment

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

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 52

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 52

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 52

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

752 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