Can you use VBA to find a programs version?

[PuddinPie]

Hello.
I was wondering if it was possiable to use vba to find the version of a program. I know it can be done with windows and any office but can it be done to find the version of a non-microsoft application?


Thank you

[HansV]

You can use code like this:

Code: Select all

Sub GetVersion()
    Dim fso As Object
    Dim strVersion As String
    Set fso = CreateObject("Scripting.FileSystemObject")
    strVersion = fso.GetFileVersion("C:\Program Files (x86)\CCleaner\CCleaner64.exe")
    MsgBox strVersion
End Sub

[PuddinPie]

Thank you. It works like a charm.