+ Reply to Thread
Results 1 to 3 of 3

Overflow error in middle of processing loop

  1. #1
    Registered User
    Join Date
    07-17-2014
    Location
    Edmonton
    MS-Off Ver
    2010
    Posts
    29

    Overflow error in middle of processing loop

    Hi all,

    Working on trying to get this code finished. I am running into an 'OVERFLOW' error after the code has successfully processed 30 of the 150 files. Once I post this I am going to strip a few of the files to see if anything within the idividual files is doing it, but I have already adjusted column formats in the (seemingly) problem workbooks to no avail.

    Your help would be greatly appreciated.

    Thanks again community

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,626

    Re: Overflow error in middle of processing loop

    You don't say where the error is but it might help if you change all the Integer declarations to Long.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    07-17-2014
    Location
    Edmonton
    MS-Off Ver
    2010
    Posts
    29

    Re: Overflow error in middle of processing loop

    That was the thing... there was no place it died, as it died mid process (after 30 files successful). I just found in my previous thread someone pointed out the "to long" and that did it. Simple but effective thanks.

+ 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. [SOLVED] Overflow error, long processing time
    By nokia6100 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-24-2014, 10:01 AM
  2. [SOLVED] OverFlow Error in For Loop
    By Excel_Fan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-28-2014, 02:43 PM
  3. Explanation of the Run-time error '6': Overflow Error
    By mgphill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2012, 10:46 AM
  4. Want to do a while-loop but get error message: run error '6' overflow
    By danzi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2011, 01:48 PM
  5. Loop Array Iteration and Processing
    By Bigced_21 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-01-2010, 11:16 AM

Tags for this Thread

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