View Single Post
  #6   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

I hadn't really noticed the forms part, but you can find other "non-form"
examples:

Eg;
http://www.suodenjoki.dk/us/producti...ellexecute.htm


Tim


"NDBC" wrote in message
...
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

"Tim Williams" wrote:

Maybe try this ?

http://www.vbforums.com/showthread.php?t=166743

Tim


"NDBC" wrote in message
...
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.


"Tim Williams" wrote:

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.