×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Using excel to activate another application

Using excel to activate another application

Using excel to activate another application

(OP)
I am using Excel to analyze data generated from a linear encoder and a pressure transducer(plotting pressure verses distance).I am using a shell execute command to open the proper motion profile file(Compumotor) and data aqusition file(Dasylab). Does anyone know a way Excel can actually start the data aquistion and motion profile. Now I have to manually activate the two. Thanks for the help.

RE: Using excel to activate another application

just some ideas.  IF you can use the create object to expose the other applications object models then send them commands.  and maybe an API spy to get the handels of the applications forms and controls then use the send message api to send commandes to the forms.  These may or may not be possible depending on the apps you ar trying to start

RE: Using excel to activate another application

Use the Shell command to get the program going, then the SendKeys command to send the same keys you would press if you were running it yourself from your keyboard.  It is kind of tricky if you need to send more than one set of keys.  Unless you do something tricky, the VBA program will send keys to the other program when it damned well wants to. (Using the Pause command doesn't work well because the timing of VBA programs is not consistent.)

RE: Using excel to activate another application

(OP)
Thanks for the reply, but I licked this one a couple of days after I posted. I used a shell execute command to launch the DAQ. I set the preferences of the DAQ file to begin collection of data at startup, and i used a message box to pause the execution of the code until the DAQ was running.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources