+ Reply to Thread
Results 1 to 2 of 2

import multiple txt files in worksheet and formating

  1. #1
    Registered User
    Join Date
    08-08-2006
    Posts
    2

    import multiple txt files in worksheet and formating

    Hello,
    I'm newbie in macro but i know something of programing.
    My problem is somthing like this:

    I have folder with multiple txt files (eg. 546.txt. 432.txt, 343.txt)
    Content of every file have same formating but different data

    546.txt
    -----------------
    Header
    Number: 546
    Value1: 1345 675
    Value2: 323 245
    Value3: 4322 343

    432.txt
    -----------------
    Header
    Number: 432
    Value1: 32 444
    Value2: 78766 245
    Value3: 12 714

    Importing delimiter that i have to used is "fixed width" because i cannot get good import. For Values row there is two numbers i need that are delimited with multiple spaces (not tabs).

    From every file in working folder i want to import only rows Value

    And would like to my excel sheet look like this:

    Number Value1 Value2 Value2
    432 32 78766 12
    432 444 245 714
    546 1345 323 4322
    546 675 245 343


    Can someone help me with this?

  2. #2
    Registered User
    Join Date
    08-08-2006
    Posts
    2
    nobody knows, or nobody helps?

+ 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