×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

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!

*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

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! Already a Member? Login


Resources

Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close