Results 1 to 16 of 16

Long running vb/a code Issues

Threaded View

  1. #1
    Registered User
    Join Date
    02-07-2012
    Location
    98052
    MS-Off Ver
    Excel 2003
    Posts
    15

    Question Long running vb/a code Issues

    Hi All,

    I need some advice to getting excel, a user form and vb/a to play nice with each other and the os.

    I have a user form w/ vb code that can run for a minute to an hour depending on what parameters the user selects.

    When the code is running and excel minimized, it can't be restored until the code completes.
    additionally,
    if I select the form and try to move it there is a few minute delay before it happens
    if a application is opened over the user form or excel, then closed, the user form and excel image is blanked and doesn't repaint for several minutes.
    on occasion, when I open task manager, I see excel and MS VB for Appl. in a non responding state
    There isnm't any issues displayed in task mngr, the machine is running at about 45% cpu utilization.
    However, other apps, appear slow to respond at times when the vb code is running.

    I've sprinkled do events and repaint through out the code modules but it's a poor attempt at best.

    Also the code appears to sporadically hang, if I hit a ctrl+Break, then resume, the code continues
    however, at the break point, I add another DoEvents

    Is there something I've over looked?

    thanks
    Last edited by toddbailey; 03-02-2012 at 02:19 PM.

Thread Information

Users Browsing this Thread

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

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