×
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

How can I close an application from Excel

How can I close an application from Excel

How can I close an application from Excel

(OP)
I have an external application that I can start using the shell and path function. The application runs in my system tray.
I want to create a button in excel that will activate a macro that will stop this application.

I dont know the syntax or the proper function to use.

For example the program I want to stop is called Update.exe
When it runs, it is only in the tray at the bottom right of the screen.(It's not a minimized window) The path for this is C:\datalog\update.exe

Now how can I tell a Macro in Excel to stop and exit this application. A solution word for word would be nice.

Thank you to all.

RE: How can I close an application from Excel

Not very elegant, but you could use the "sendkeys" method. This basically mimics keyboard strokes, it takes a bit of fiddling to get it right, but it works. Its a way of automating applications that don't have any inbuilt programming language. Theres quite a bit about "sendkeys" in the VBA helpfile along with an example using the windows calculator.

Best regards

finnigan

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



News


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