+ Reply to Thread
Results 1 to 6 of 6

Check if a certain software is not responding.

  1. #1
    Forum Contributor
    Join Date
    08-16-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2019
    Posts
    209

    Check if a certain software is not responding.

    Hi,

    I am trying to automate data entry from Excel to our inhouse software. most of my looping can be done using Application.SenKeys Method, such as Ctrl+C, Alt+Tab, Ctrl+V, Alt+Tab (and repeat the process til the end of loop).

    However there are some issue with the inhouse software where when there are too many users using it at the same time causing the software to goes (NOT RESPONDING), therefore killing the sequence.
    I have tried to use application.wait however I cant judge when is the software gonna go to (Not Responding) mode.

    Is there any specific way to check using like LOOP (active application) is NOT RESPONDING then wait for x seconds, otherwise continue macro.

    Thanks
    Lex

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Check if a certain software is not responding.

    Hello lexusap,

    This code needs to be placed in a separate VBA module in your workbook's VBA Project. You can check if your application is hung by entering either the whole caption or part of it. If the application is found False is returned if it is not hung and True if it is. If the caption you supplied the macro does not match any of the running applications captions then Empty is returned.

    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Check if a certain software is not responding.

    .
    Leith ... been following this thread.

    Please explain "Caption".

    Thank you.

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Check if a certain software is not responding.

    Hello Logit,

    "Caption" refers the window caption of the Application. For instance, in Excel it might look like "Report Data.xlsx - Microsoft Excel".

    You can either use the full title or a partial match. If you use a partial match, it should be something that is unique like "Report Data.xlsx".

    Calling example...
    Please Login or Register  to view this content.
    You can iterrupt the loop by using the Ctrl+Break keys.

  5. #5
    Forum Contributor
    Join Date
    08-16-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2019
    Posts
    209

    Re: Check if a certain software is not responding.

    Hi Leith,

    Thanks for your input. i need to test it first. I am just wandering what should be the caption i use to feed my needs.
    The sample you gave me above is "Report Data.xlsx", in my scenario, it would be an app(in-house software) called Axiom, do i just use Axiom.exe or something similar?

    Thanks
    Lex

  6. #6
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Check if a certain software is not responding.

    Hello Lex,

    From what you posted, I gather Axiom is receiving data from Excel via cut and paste operations using SendKeys. If this is case then the Axiom program has a visible window open on the desktop. What information is in the title bar at the top of the window?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Simple "If Then" Check Responding Unexpectedly
    By rrdz89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2017, 01:31 AM
  2. How to check if excel file is Checked Out in SharePoing Check Out, run code, Check In
    By jrtraylor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-08-2016, 04:36 PM
  3. [SOLVED] VBA on Form is not responding
    By ChemistB in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-28-2013, 05:56 PM
  4. Automatically check one or more check boxes when a parent check box is manually checked
    By Steverizer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-28-2013, 01:56 PM
  5. [SOLVED] Not Responding
    By jaywenzel in forum Excel General
    Replies: 8
    Last Post: 08-28-2012, 07:39 PM
  6. How to check if Software is loaded on a users C: drive
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2005, 11:05 AM
  7. [SOLVED] VBA module not responding!??
    By alainr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1