VBA code to open files in an application using Shell

[rahul92]

I'm relatively new at VBA, and I am developing this excel based tool that creates two .xls files, whose paths are saved in two variables. The next step is the user has to select these two files, right click and select an application called Compare.
I was wondering if this process could be automated using Shell commands in VBA. Please advise.

 

[Jon von der Heyden]

Hi

Perhaps, if you know where the Compare executable file is:

Public Sub OpenWithCompare(ByVal strFile As String)
    'C:\WINDOWS\SYSTEM32\compare.exe
    Call Shell("compare.exe " & strFile, 1)
End Function