shell - VBA code to open two files using an application -

i'm relatively new @ vba, , developing excel based tool creates 2 .xls files, paths saved in 2 variables. next step user has select these 2 files, right click , select application called compare.

i wondering if process automated using shell commands in vba. please advise.

yes, possible. assuming compare takes 2 files arguments, this:

public function opencompare(strfileone string, strfiletwo string)      dim x variant     x = shell("compare.exe " & strfileone & " " & strfiletwo, vbnormalfocus) end function