+ Reply to Thread
Results 1 to 4 of 4

endless loop

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    endless loop

    Hello. This mvp (who isn't so much of an mvp) gave this code:

    Please Login or Register  to view this content.
    It results in an endless loop. How do I fix it?

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: endless loop

    You're (he's) not telling it to move to the next file so you're constantly working on the one file.

    add

    Please Login or Register  to view this content.
    before
    Please Login or Register  to view this content.
    If someone has helped you then please add to their Reputation

  3. #3
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,176

    Re: endless loop

    use this....

    Please Login or Register  to view this content.
    Last edited by ranman256; 08-25-2015 at 03:19 PM.

  4. #4
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    Re: endless loop

    @pj's. That worked. Thanks.

    How does myfil= dir know how to push it to the next workboo?

+ 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. Endless loop with two activex listbox'
    By Bishonen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2013, 08:36 AM
  2. Endless Loop When Using BeforePrint Event
    By PosseJohn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2011, 09:35 PM
  3. Endless loop
    By kathhying in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2011, 01:17 PM
  4. Endless Loop?
    By teaker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2009, 10:39 AM
  5. Endless loop
    By freddie mac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2006, 10:25 AM
  6. [SOLVED] endless loop help
    By John in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-26-2005, 12:05 PM
  7. Endless loop?
    By John in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 08-02-2005, 02:05 PM
  8. [SOLVED] Interrupting an endless loop
    By davegb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-17-2005, 02:06 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