LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 204
Default Running other programs with VBA

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Programs running slow Omaha Tony Excel Discussion (Misc queries) 0 March 7th 10 03:47 PM
Going Between Programs bscuga Excel Discussion (Misc queries) 1 May 6th 08 03:43 PM
running command line programs from Excel Thomas Moen Excel Programming 6 January 11th 08 05:38 PM
Running external programs Alan Beban[_4_] Excel Programming 4 December 20th 03 03:06 PM


All times are GMT +1. The time now is 10:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"