joel,

i removed the spaces as you suggested. I still get that error. The total
number of records is approx. 600.

I don't think this data set is large. maybe the code is creating this
complexity. can this code be written in a more efficient way?

Naraine


"Naraine Ramkirath" wrote in message
...
Hi All,

On a monthly basis I import a text file into excel and "massage" the data
to
fit into the columns. However, this is a long and tedious process. I am
wondering if some one could provide a vb script that will do this for me.

Any help would be greatly appreciated.

Regards,

Naraine