In VB6, Is there a way/solution to catch/get an Instance of an application running in background? Solution Reqd. Urgently.

Posted on 2003-03-28
Medium Priority
Last Modified: 2012-06-21
Please follow the link.


Here the problem is when the user opts to Overwrite an existing file but later on when the application asks to confirm the Overwrite the existing file... The code generates an error and the control flow shifts to label "err:" .. here though i've closed all the related instances .. still an instance of the "Excel" application is running in the memory.. How can I close that specific instance.. Or u can tell me is there a way to catch a ruuning instance of an application... Solution is required urgently and ASAP... All realated suggestion for changes in code are also welcome..


Question by:SunShines
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 16

Expert Comment

ID: 8229473
shorry, how do you run this code and in which line do you get the error?
Also, why do you set W to nothing afer populate the sheet and why do you use those labels?
LVL 16

Expert Comment

ID: 8229491
Also, if you could, excel has an intrinsic function of Range object called copyfromrecordset with a recordset parameter (97 with DAO recordset and 2000 with ADO recordset)
Yo wouldn't need a loop with it.

Expert Comment

ID: 8531379
Hi SunShines,
This old question (QID 20567137) needs to be finalized -- accept an answer, split points, or get a refund.  Please see http://www.cityofangels.com/Experts/Closing.htm for information and options.
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 8532741
Thanks Richie_Simonetti,

Sorry for responding so late ... But I've got my solution in some other way ... so plz dont bother abt the question and abt the grade/point part well i cant give any thing to any body (so dont mind) ... I do appreciate ur help ... and look futher for more in comming future ...

Author Comment

ID: 8532767
Hello CleanupPing,

I need help to close my question. Please close this question. As I've found the solution myself.

I dont know what to do now with the question. Plz help to close this question.


Accepted Solution

SpideyMod earned 0 total points
ID: 8650361
CleanupPing does not respond to posts.  In the future, please do not accept any answers from CleanupPing.  Inside of the CleanupPing message was a link to how to close the question and that link includes what to do when you have solved the question yourself.  Please take time to read this now.  I am handling this question by refunding your points so you won't have to do anything more with this one, but please be more careful in the future.  Thanks

Community Support Moderator @Experts Exchange

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month7 days, 20 hours left to enroll

765 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