+ Reply to Thread
Results 1 to 18 of 18

Extrect data from text file to Excel

  1. #1
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Question Extrect data from text file to Excel

    Dear masters,
    i had text files and i want to export text to excel from text file with some specific format in excel. kindly provide suitable macro.please find attached text file and required excel formats.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Re: Extrect data from text file to Excel

    Quote Originally Posted by pvsvprasad View Post
    Dear masters,
    i had text files and i want to export text to excel from text file with some specific format in excel. kindly provide suitable macro.please find attached text file and required excel formats.

    Sorry Masters i am upload updated format of excel File.please find and make a wonder full code.
    Thank you all.
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,377

    Re: Extrect data from text file to Excel

    Try
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Re: Extrect data from text file to Excel

    Dear sir,
    Thank you for providing.
    i will test your code and give feedback
    Last edited by pvsvprasad; 07-30-2016 at 09:04 AM.

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,377

    Re: Extrect data from text file to Excel

    How to install your new code
    1. Copy the Excel VBA code
    2. Select the workbook in which you want to store the Excel VBA code
    3. Press Alt+F11 to open the Visual Basic Editor
    4. Choose Insert > Module
    5. Edit > Paste the macro into the module that appeared
    6. Close the VBEditor
    7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

    To run the Excel VBA code:
    1. Press Alt-F8 to open the macro list
    2. Select a macro in the list
    3. Click the Run button

  6. #6
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Re: Extrect data from text file to Excel

    Dear sir,
    Kindly find attached file. this file ca not developed.kindly check and modify the code.

    Thanking you sir.
    Attached Files Attached Files
    Last edited by pvsvprasad; 07-30-2016 at 11:08 AM.

  7. #7
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Re: Extrect data from text file to Excel

    Thank you for valuable basics.
    Last edited by pvsvprasad; 07-30-2016 at 11:08 AM.

  8. #8
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Re: Extrect data from text file to Excel

    My Excel sheet is hanged, any solution for this bug? because my anl file contains 800 pages. so please tweak the code.

    Thanking you sir.
    Last edited by pvsvprasad; 07-30-2016 at 09:45 AM.

  9. #9
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,377

    Re: Extrect data from text file to Excel

    Change to
    Please Login or Register  to view this content.

  10. #10
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Re: Extrect data from text file to Excel

    Very Nicely executed sir and processing fast is greatly improved. thank you for modification. with help of this code developed only named as "C O L U M N" these items. but missing "B E A M" items named. kindly check the code.

    Thanking you sir.
    Last edited by pvsvprasad; 07-30-2016 at 11:07 AM.

  11. #11
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Question Re: Extrect data from text file to Excel

    Kindly find attachment of output Excel sheet.
    Attached Files Attached Files

  12. #12
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,377

    Re: Extrect data from text file to Excel

    1) Edit your posts and remove all full quote of my post. Should be quoted only when it is needed.

    change 1st pattern
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

  13. #13
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Re: Extrect data from text file to Excel

    Dear sir,
    What a Execution.marvelous sir.you saved my day.now it is perfectly working sir.

    Thank you very much sir.

  14. #14
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Question Re: Extrect data from text file to Excel

    Dear sir,

    Please add some columns to your code.you are greatly developed for BEAMS and COLUMN data extraction to excel from ANL file.
    can you prepare same code but i want to separate the sheets as Sheet No.1 is BEAMS data and Sheet No.2 is COLUMN data.
    Both are in one Excel File. and i am adding some columns from Text file data.please find the Output Excel Sheet example.

    Sorry for Your Trouble.

    Kindly make a smooth code for me.

    Thanking you sir.
    Attached Files Attached Files

  15. #15
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Re: Extrect data from text file to Excel

    Dear sir,
    Kindly prepare a code for me. i am waiting for your valuable reply.

    Thanking you sir.

  16. #16
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,377

    Re: Extrect data from text file to Excel

    You are almost asking different question now and too much work for a free forum.

    I suggest you to go to http://www.excelforum.com/commercial-services/

  17. #17
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Re: Extrect data from text file to Excel

    Kindly anybody help me for my projectwork.

  18. #18
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Question Re: Extrect data from text file to Excel

    Quote Originally Posted by jindon View Post
    1) Edit your posts and remove all full quote of my post. Should be quoted only when it is needed.

    change 1st pattern
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Dear sir kindly make a small modification in your code.
    with help of your code i need to export "No" column should be developed as a ascending order. kindly find the sample out put attachment.

    please execute a modification for me.

    thanking you sir,

    Best regards.
    Attached Images Attached Images
    Attached Files Attached Files

+ 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. Replies: 0
    Last Post: 02-09-2016, 06:14 PM
  2. Data from a text file into excel
    By vutienhp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-23-2014, 05:27 AM
  3. [SOLVED] extrect unique data
    By ZHANG0 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-06-2014, 10:29 AM
  4. How to get data from text file to excel
    By lakshmisanthi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2012, 03:58 AM
  5. How to extract Information from an Excel File and entering those data in a text file?
    By bikash.nitk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2012, 12:13 PM
  6. Macro to collect data from a text file into an excel file
    By Calibri in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-01-2012, 11:47 PM
  7. Get Data From Text File And Convert To Excel File
    By nuriez1906 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-29-2012, 09:51 AM

Tags for this Thread

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