Computing.Net > Forums > Programming > VBA code to check application

Computing.Net: Over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to sign up now, it's free!

VBA code to check application

Reply to Message Icon

Original Message
Name: losorio64
Date: November 10, 2005 at 20:04:02 Pacific
Subject: VBA code to check application
OS: WIN XP
CPU/Ram: Centrino 1.7 512mb
Comment:

Can anyone help me construct a VBA code in Excel that would check if an external application (not Microsoft) is open or not? If it is open, can the code close it.

I'm new in VBA programming and I'm construction an executive dashboard that gets data from external source.

Any help is appreciated....

losorio64


Report Offensive Message For Removal


Response Number 1
Name: Chi Happens
Date: November 16, 2005 at 06:22:33 Pacific
Reply: (edit)

You can use the Win32 APIs
EnumerateWindows
GetWindow
and
SendMessage (to close it)

Hope this helps,
Chi

They mostly come at night...mostly.


Report Offensive Follow Up For Removal







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home








Do you have your own blog?

Yes
No
I did before
I will soon


View Results

Poll Finishes In 4 Days.
Discuss in The Lounge
Poll History




Data Recovery Software