I will post a example this evening

Also -where did the
macro go? I can't find it when I open a new spreadsheet.

What do you mean with that ?



--

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


"sherry" wrote in message ...
Ron,
This works but....can each text documrnt be it's own xls file instead of all
text in one file. Some of my files are really large. Also -where did the
macro go? I can't find it when I open a new spreadsheet.

thanks
Sherry

"Ron de Bruin" wrote:

Hi sherry

You can start here
http://www.rondebruin.nl/txtcsv.htm

--

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


"sherry" wrote in message ...
I have 250 text files(all different names) I need to make them excel files. I
need all columns to remain the same. Columns are fixed width.
Can this be done with a batch file ? I also use vfp9.

thanks
Sherry