R
Ray Batig
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
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