Consulting

Results 1 to 6 of 6

Thread: Export Excel to .txt

  1. 09-03-2008, 07:55 PM #1
    magaupe
    magaupe is offline
    VBAX Newbie
    Joined
    Sep 2008
    Posts
    2

    Export Excel to .txt

    Hi guys,

    How can I export an Excel file to .txt following a pre-defined layout plus adding a space between the values of the columns?

    Example

    These are the columns:
    NAME: 04 DIGITS
    LOCATION: 03 DIGITS
    FINAL LOCATION: 03 DIGITS
    ZONE: 02 DIGITS
    FINAL SUBZONE: 04 DIGITS
    CODE: 02 DIGITS
    "WHITE SPACE": 39 DIGITS

    You guys have a macro for that?
    Reply With Quote Reply With Quote
  2. 09-03-2008, 10:15 PM #2
    shamsam1
    shamsam1 is offline
    VBAX Contributor
    Joined
    May 2008
    Location
    bangalore
    Posts
    199
    Location
    check this link

    http://www.cpearson.com/excel/ImpText.aspx
    Reply With Quote Reply With Quote
  3. 09-03-2008, 10:17 PM #3
    shamsam1
    shamsam1 is offline
    VBAX Contributor
    Joined
    May 2008
    Location
    bangalore
    Posts
    199
    Location
    check the attachment
    Reply With Quote Reply With Quote
  4. 09-03-2008, 11:17 PM #4
    magaupe
    magaupe is offline
    VBAX Newbie
    Joined
    Sep 2008
    Posts
    2
    Quote Originally Posted by shamsam1
    check the attachment
    What exactly does it do?
    Reply With Quote Reply With Quote
  5. 09-04-2008, 07:31 AM #5
    Kenneth Hobs
    Kenneth Hobs is offline
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    If you posted an example xls and txt file, it would help.
    Reply With Quote Reply With Quote
  6. 09-04-2008, 09:30 AM #6
    shamsam1
    shamsam1 is offline
    VBAX Contributor
    Joined
    May 2008
    Location
    bangalore
    Posts
    199
    Location
    cross posting with mrexcel.................

    please avoide that
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules