Working With 1 Million Records

  • This is a nice piece of VBA code which adds seperate worksheets onto the bottom of each other as long as they have the same field structure. I have tested this and it works fine in Excel 2003. However, when you have large worksheets ie. over 65536 records then the files are naturally split into different sheets. With Excel 2007 having a record capacity of 1 million records I have been trying to adapt the VBA to allow the addition of up to 1 million records to a worksheet. Obviously I have tried changing the number of records in the code but this causes the VBA to crash as more adaptions are needed which I can't figure out as I'm very new to VBA. Can anyone help??

    Also found at this link

  • Re: VBA code to merge Worksheets Of Up To 1 Million Records In Ex. 2007


    you should definetly move to Access or Oracle for this kind of experiments!


  • Re: Working With 1 Million Records


    MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!