Solved

VBA - How to close an external application though code

Posted on 2006-11-10
6
625 Views
Last Modified: 2008-03-17
I have a backup & update procudeure that I run which starts off with an external VB6 application copying / remaning a new databse into the databse directory and then launching the new databse to start the data transfer. I need to know if there is code that I can, on load or completion of data transfer to the new databse, close the external VB6 application?

Regards,
Daniel
0
Comment
Question by:garygrouse
  • 2
6 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 17920152
why cant u get your vb6 app to close down?  can u not code it in there?

if your vb6 has a window, u can use this code I posted whereby u get the window handle of a window then issue a close using that
http://www.experts-exchange.com/Databases/MS_Access/Q_22056331.html

this example closes outlook, I find by looking at the window caption
0
 
LVL 65

Accepted Solution

by:
rockiroads earned 125 total points
ID: 17920320
some code here to kill apps by name rather than window title
http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20792368.html
0
 
LVL 4

Assisted Solution

by:GordonPrince
GordonPrince earned 125 total points
ID: 17920774
What about putting "Unload Me" in the VB app, which will close the application after the work is done.
0
 

Author Comment

by:garygrouse
ID: 17921352
I did not create the VB app, that is why it does not close how I want it too.

I will give those solutions a go,thanks again for your help.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now