Results 1 to 16 of 16

Macro neede to open text files from folder and remove all the lines except specific lines

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-09-2013
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    176

    Macro neede to open text files from folder and remove all the lines except specific lines

    Hi to all VBA Programmers,

    I have a folder, it contains some 15 text files. Each files contains some headings like -chromosomes from 1 to 12 and some lines under each chromosome. Now i want keep one heading (for example Chromosome1) with its lines and remove rest of the headings. for example i want to keep this -Chromosome 1 and its lines (BTX) until next _Chromosome start like this i want do it for remaining -Chromosomes) I am doing this manually but it is taking lot of time to complete one single time like this i have to do 12 times.
    Can any one help me with macro code? if yes your efforts would be highly appreciated. I am attching one of the sample file for better understanding of what i am saying.
    Thanks in advance,

    Regards,
    Genetist
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. pull specific lines from multiple txt files ?
    By brianlg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2014, 06:00 PM
  2. Macro to Open specific files in a Folder
    By lorena.tgarza in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-15-2012, 09:01 AM
  3. [SOLVED] Macro to Delete useless lines, rearrange by dates and skip lines between different days.
    By Tmc2159 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-12-2012, 02:15 PM
  4. Open .TXT file Replace Specific Lines with Cell Values
    By Tellm in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-09-2011, 12:08 PM
  5. Formulas to remove specific lines of text from a spreadsheet
    By visionwindowfilms in forum Excel General
    Replies: 11
    Last Post: 02-28-2010, 06:04 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