+ Reply to Thread
Results 1 to 6 of 6

Monitoring utility for a Batch Process

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,762

    Monitoring utility for a Batch Process

    Hi,

    I have a Workbook "Batch.xlsm"
    In which I have some Task Files listed that are opened one by one , some operation is performed and TaskFile is closed.

    The problem that is being faced is that on some files the operation is not successful and the whole Excel application is crashed.

    The purpose of a Batch Process is supposed to be the time saving and one cannot sit in front of PC till the batch completes.

    Your precious thoughts are needed on "How to keep the batch continues by skipping the problematic file"
    What should save the batch from stopping.

    Skipping files is affordable but of course stopping batch is not desirable.

    Help would be greatly appreciated

    Any utility will also be a good choice

    Brief description of the task: Basically every task file is scrapping data from a website. for different categories.

    Best Regards

    Imran Bhatti
    Teach me Excel VBA

  2. #2
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,518

    Re: Monitoring utility for a Batch Process

    can you upload your sample workbook?

  3. #3
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,101

    Re: Monitoring utility for a Batch Process

    Hello ImranBhatti,

    Skipping files is affordable but of course stopping batch is not desirable.
    Have you tried to add?:

    Please Login or Register  to view this content.
    Which goes in just before your Batch Processing starts?

    Be aware that by doing this you may not be alerted to any other problems in your Code. So it would be good to Check and see if you end up with the desired results.

    Regards
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  4. #4
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,762

    Re: Monitoring utility for a Batch Process

    Yes winon I did this at first but it also resume next if the problem is inside the code of Batch File

    I need not to resume next if the error occurs in the main code. it is like if I process an individual Task File by clicking different buttons and some error occurs and I skip this file and go to next file . Likewise the batch opens a task file uses the click events of different buttons in the Task file's userforms etc and waits untill the processing gets completed.Now if the problem is in Task File , the batch should skip this file and go to next file rather than stopping the batch at all

    "This is something Dictator Application and I just want your ideas what algorithm should be used to handle this situation."

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,241

    Re: Monitoring utility for a Batch Process

    What's with the big red text?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  6. #6
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,762

    Re: Monitoring utility for a Batch Process

    Hi Ford

    The Situation is described in small font in black.

+ 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. vba macro to batch process adding worksheets
    By SKooLZ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2015, 05:07 AM
  2. [SOLVED] Adapt macro to batch process files
    By beng404 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-27-2012, 07:09 PM
  3. [SOLVED] Formula to round down on a batch and exclude anything under a full batch
    By toomuchbrew in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-15-2012, 11:04 AM
  4. Replies: 0
    Last Post: 06-19-2012, 11:36 AM
  5. Reverse Geocode Batch Process
    By ernestgoh in forum Excel General
    Replies: 0
    Last Post: 01-19-2010, 03:35 PM
  6. [SOLVED] How to count process running time ( process not finished)
    By miao jie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2005, 06:06 AM
  7. How to count process running time ( process not finished)
    By miao jie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2005, 02:06 AM

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