View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] don_ingli@symantec.com is offline
external usenet poster
 
Posts: 1
Default Create a single xls file with each import csv file having its own tab

All,

I have 26 csv files named a.txt .. z.txt.

I want to be able to import all of these files using the name of
the .txt file as the name of a tab and import all data as text not
general.

The end result would be a single xls file with 26tabs of TEXT (not
general) imported data.

Any way i can automate this?

The format of the .txt files is from an output of my own app so i
could turn it into html if that helps any except these import files
are around 50,000 rows each.

Thanks.

Please email me your posts.