View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams[_2_] Tim Williams[_2_] is offline
external usenet poster
 
Posts: 298
Default Running other programs with VBA

Does the wedge program have a command line parameter to specify a settings
file?

Tim

"NDBC" wrote in message
...
I am using a wedge program to link a rs-232 device with excel. To help
streamline things for other users I would like to start the program from
within the excel worksheet that does the scoring. I have done a search and
found that I can start a program using

Shell "C:\path\wedge.exe", vbNormalFocus

What I want to know is can I use command to open a settings file within
the
wedge program. It has shortcut keys ALT F then O to open file. Is it
possible
to right code to run these keystrokes and type in the filename and path in
the open file window.

If not the settings file will always be number 1 on the list of recently
opened files and can be run by ALT F then 1.

Once the file is opened the wedge program is set to run mininimised
automatically and it automatically brings the focus back to excel so that
part should be okay but is there a way to force the focus back to excel
just
to be sure.