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.

Create a single xls file with each import csv file having its own tab
 

Try
http://www.rondebruin.nl/txtcsv.htm

Format the columns as text in the macro


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message oups.com...
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.