none
version number and Bit version of installed office RRS feed

  • Question

  • What is the definitive way to find out the version number and Bit version of installed office?. 

    I don`t want to read from c:\ProgramFiles.

    Monday, June 19, 2017 9:14 PM

All replies

  • Hi YashMSDN,

    to get the version number you can use Application.Version Property.

    MsgBox "Welcome to Microsoft Excel version " &; _ 
     Application.Version &; " running on " &; _ 
     Application.OperatingSystem &; "!"
    

    Output:

    Reference:

    Application.Version Property (Excel)

    to get the bit version you can use code below.

    Public Function Is64Bit() As Boolean
    #If VBA7 And Win64 Then
        Is64Bit = True
    #Else
        Is64Bit = False
    #End If
    End Function
    

    Output:

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, June 20, 2017 2:09 AM
    Moderator
  • Hi YashMSDN,

    I can see that you had not responded to this thread for a long time.

    is your issue is solved now?

    if yes then try to post the solution and mark it as an answer.

    if your issue is exist then try to refer the solution given by me.

    I can see that suggestion given by me can able to solve your issue.

    so I suggest you to check it and if you think that it can solve your issue then try to mark that suggestion as an answer.

    so that we can close this thread.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, June 29, 2017 8:34 AM
    Moderator