Hi,

I ahve a situation where I have to convert a huge mutiple sheet workbook to a single tab delimited or fixed width text file to feed into the mainframe.

I need help in getting the macro code which can create the text file and overwrites the sdame evrytime instaed of appending to the old data. The macro should have capability to select particular columns and may be delete/select particular worksheets.

The data on the spreasheet has hedaings which are not of fixed width the heading looks this.

CURRENT REGULAR ROUTE SCHEDULE
BILL ORDER DISPATCH DELIVERY
STORE NAME MAPCD MTH R/S ROUTE STOP TYPE DAY CYCLE DAY TIME DAY TIME DAY OPEN CLOSE CASES/WK.

Please help me with the macro and your help would be highly apprecaited. Thanks in advance.