+ Reply to Thread
Results 1 to 3 of 3

conversion of text file(delimited) into Excel file using macro

  1. #1
    Registered User
    Join Date
    08-04-2014
    Location
    Mysore
    MS-Off Ver
    2007
    Posts
    35

    Question conversion of text file(delimited) into Excel file using macro

    Hi,

    Data existing in .txt file. with enclosed file format.(this format of txt file will generated from one of the ERP system)
    But Required in Excel Format file
    one method is Open text file(Ctrl+O) using "Text import wizard"
    with Fixed delimited --->breaking at semicolon --finish..
    then taking all data in notepad replace ; with blank then formatting cells as text/date/custom format in excel
    then pasting all data from notepad to excel.


    EMP_CODE --- Text format
    ATTN_DATE --- Date foramt as yyyy-mm-dd
    DEPT_CENTER_CODE --- Text format
    MONTH_CODE--- Text format
    FROM_TIME --- foramt as yyyy-mm-dd hh:mm:ss
    TO_TIME--- foramt as yyyy-mm-dd hh:mm:ss
    SECTION_CODE --- Text format

    required such that what ever in text file(delimited) has to open in regular format of excel..
    Please suggest me how to write a macro script with Run button.


    Thanks,
    Thara
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,811

    Re: conversion of text file(delimited) into Excel file using macro

    Heres a fairly comprehensive tutorial
    http://www.jkp-ads.com/articles/importtext.asp
    If someone has helped you then please add to their Reputation

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    30,465

    Re: conversion of text file(delimited) into Excel file using macro

    It would look something like this:

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. need macro to create pipe delimited text file from excel
    By nefkho in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2012, 12:03 PM
  2. Saving multi-tab excel file created from comma delimited text file
    By Marcus Aurelius in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2005, 01:20 PM
  3. Replies: 1
    Last Post: 05-03-2005, 06:06 PM
  4. [SOLVED] Export excel file to semicolon delimited text file
    By capitan in forum Excel General
    Replies: 5
    Last Post: 04-06-2005, 11:07 PM
  5. [SOLVED] Export excel file to semicolon delimited text file
    By capitan in forum Excel General
    Replies: 5
    Last Post: 04-06-2005, 11:07 PM

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