I have an application that can initiate linkage to ExampleMain.exe and
automatically passes "arguement1" "arguement2" as part of the command line.
The executable is compiled
VB code. I don't work in
VB but prefer Excel
VBA.
The question, is there a way to substitute Excel.exe 'MyFile.xls' and gain
the benefit of having the two arguments available as variables in VBA? Just
so you understand this will avoid typing in a file name and all the inherent
issues. My alternative is to start up the application and then use an input
box, or better yet code a directory point and click selection routine.
What is my best choice, or do I really have any? I have searched Google and
most of the well known Excel help sites without success.
Thanks in advance for your help!
Ray