Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Office Version Number from Excel VBA
Hi,
I am using verNum = Application.Version to pull the current office version, without declaring the variable it brings in 16.0, when declaring this as a single it only brings in 16, 16.0 is required as I am using this to read & write registry setting. TIA for any help on this Raymond |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Office Version Number from Excel VBA
On 29/11/2019 10:01, Raymond Allan wrote:
Hi, I am using verNum = Application.Version to pull the current office version, without declaring the variable it brings in 16.0, when declaring this as a single it only brings in 16, 16.0 is required as I am using this to read & write registry setting. Declare the variable as Variant -- Adrian C |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Office Version Number from Excel VBA
On Friday, 29 November 2019 11:33:55 UTC, Adrian Caspersz wrote:
On 29/11/2019 10:01, Raymond Allan wrote: Hi, I am using verNum = Application.Version to pull the current office version, without declaring the variable it brings in 16.0, when declaring this as a single it only brings in 16, 16.0 is required as I am using this to read & write registry setting. Declare the variable as Variant -- Adrian C Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What version of Excel comes with Office 2003? | Excel Discussion (Misc queries) | |||
Excel Services help - any trial version of Office Pro PLUS ? | Excel Discussion (Misc queries) | |||
How to obtain Excel (or Office) FULL Version? | Excel Programming | |||
What version of Excel comes with Office 2004 for Mac? | Excel Discussion (Misc queries) | |||
Office automation application which will work with any version of office C#.NET | Excel Programming |