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.

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


<(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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.
>