I'm receiving a very large .csv file. It is too large to open it
directly in Excel. I need to manually split it in different file and
then open it in different Excel tab. I'm using Office 2003.

I'm looking to build a macro that open the .csv file as a text file,
and split it in different tab in Excel so I can view all the
information of the .csv file in the same Excel workbook; just in
multiple tab.

Is there a way to do that?

Thanks

See KB article for info and code.

http://support.microsoft.com/default...;en-us;Q120596

Alternative. Change the extension from csv to txt then break it into
manageable *.txt files and open those into separate worksheets.


Gord Dibben MS Excel MVP


On 17 Apr 2007 10:53:34 -0700, (E-Mail Removed) wrote:

>I'm receiving a very large .csv file. It is too large to open it
>directly in Excel. I need to manually split it in different file and
>then open it in different Excel tab. I'm using Office 2003.
>
>I'm looking to build a macro that open the .csv file as a text file,
>and split it in different tab in Excel so I can view all the
>information of the .csv file in the same Excel workbook; just in
>multiple tab.
>
>Is there a way to do that?
>
>Thanks

Thanks Gord. That was exactly what I was looking for.

You may want to try our Excel 2007.

The total number of available rows in Excel:
Old Limit: 64k (2^16)
New Limit: 1M (2^20)



"(E-Mail Removed)" wrote:

> I'm receiving a very large .csv file. It is too large to open it
> directly in Excel. I need to manually split it in different file and
> then open it in different Excel tab. I'm using Office 2003.
>
> I'm looking to build a macro that open the .csv file as a text file,
> and split it in different tab in Excel so I can view all the
> information of the .csv file in the same Excel workbook; just in
> multiple tab.
>
> Is there a way to do that?
>
> Thanks
>
>