+ Reply to Thread
Results 1 to 1 of 1

Macro to convert a mutiple sheet workbook to tab delimited text or fixed width text file

  1. #1
    Registered User
    Join Date
    06-25-2012
    Location
    usa
    MS-Off Ver
    Excel 2003
    Posts
    5

    Macro to convert a mutiple sheet workbook to tab delimited text or fixed width text file

    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.

  2. #2
    Valued Forum Contributor fredlo2010's Avatar
    Join Date
    07-04-2012
    Location
    Miami, United States
    MS-Off Ver
    Excel 365
    Posts
    762

    Re: Macro to convert a mutiple sheet workbook to tab delimited text or fixed width text fi

    Can you post a sample of you workbook? Its a little hard to tell.What you want i dont think its that hard.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1