Thread: Getting Office Version Number from Excel VBA
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Raymond Allan[_2_] Raymond Allan[_2_] is offline
external usenet poster
  
Posts: 9
Default 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 With QuoteReply With Quote