View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ray Batig Ray Batig is offline
external usenet poster
 
Posts: 74
Default High Tech Question ?

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