View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] beancurdjelly2003@yahoo.com.hk is offline
external usenet poster
 
Posts: 35
Default csv file convert to excel file

I run the report is csv file format, but I need to convert to excel
file, the problem is the csv file are very large, I need to manual
copy and paste to Sheet 1, Sheet 2, Sheet 3 ... ... because I'm using
excel 2003, each Sheet max only have 65xxx rows.

How can I write a marco to auto convert to excel file with header in
different sheet?