Help with 65536 macro

[kevinz]

Ok, I know excel has the 65536 limit.. but found the code that I guess
will split files up for you. Problem is, I cannot figure out how to get
to work.

Could anyone explain how to do that? I have a more than a few files I
would like to load in excel and are way more than 65k.. This would be a
life saver.

Thank you so much

 

[exceluserforeman]

What type of files are they? Text Files? XLS Files? Why load into excel?
Give example of file size. and maybe the code you describe...

 

[kevinz]

They are text files, but delimited with commas.. I need to load the
into excel because I need to remove some of those fields and add som
new fields. It makes it easy for me in excel, but I have a couple o
files that just grew too big.. Couple over 100,000 and 200,00

 

[Pete_UK]

With the Data Import Wizard you can specify to start importing at a
particular row. However, the maximum this can be is 32k (32768), so
this allows you to import up to 96k records in two passes - the first
pass will get the first 64k rows and the second pass will get 32k -
96k. You thus have the rows 32k-64k in both worksheets, and you will
need to delete the duplicates.

If you have files with over 96k records you will need a different
strategy - you could load the file into Access and then split it from
there into Excel-sized chunks, or try the same with Wordpad, or you
could use Quattro Pro or Lotus which will accommodate up to 1,000,000
rows.

Alternatively still, Microsoft posted a macro to work on large files
and automatically split them into 64k sheets - I don't have the
reference myself, but you could search their Knowledge Base articles.

Hope this helps.

Pete

 

[kevinz]

Pete, that was my problem.. I found the microsoft macro that is suppose
to split it up. I am just unsure how to use it

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q120596

It gives you the code, but I just can't get it to work. Little lost
using it.

 

[Door]

The code works as per the attached

You will need to highlight Column A and select Data, Text-to-Column
for your data.

Pete, that was my problem.. I found the microsoft macro that is suppos
to split it up. I am just unsure how to use it

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q120596

It gives you the code, but I just can't get it to work. Little los
using it

+-------------------------------------------------------------------
|Filename: Book2.zip
|Download: http://www.excelforum.com/attachment.php?postid=4563
+-------------------------------------------------------------------