Running other programs with VBA

  • Thread starter Thread starter NDBC
  • Start date Start date
N

NDBC

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.
 
Does the wedge program have a command line parameter to specify a settings
file?

Tim
 
Not that I can find. I did notice however if in explorer and I double click
on the configuration file it will open the program with that configuration
loaded. So I tried

shell("c:\program files\wedgelink\ndbc.wlc", 6)


where ndbc.wlc is the configuration file to try and fire it up but this
doesn't work. I also tried

shell("c:\program files\wedgelink\wedglink.exe c:\program
files\wedgelink\ndbc.wlc", 6)

to no avail. The exe and the configuration file are in the same directory.
 
Thanks for finding that. I haven't tried it yet as I don't even pretend to
understand what it means. I especially don't understand the variable me.hwnd
and why the form needs to be loaded. Can anyone explain this to me.

Thanks
 
Back
Top