Results 1 to 2 of 2

Thread: multiple text files into a single sheet

  1. #1

    Question multiple text files into a single sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello team,

    I am ver new toVBA programmingand reqested you to update the vba code to complete.

    scenario:
    1. I have multiple files in a folder
    2. each file containing 4 columns separated by "|"
    3. Each file contains 1000 or more records

    Suppose if i have 4 files in the folder one i have excuted the macro , my sheet should contain 4000 + records apprximately. I need a macro for this.

    thanks in advace.

  2. #2
    Acolyte patel's Avatar
    Join Date
    Feb 2014
    Location
    Italy
    Posts
    59
    Articles
    0
    attach please 4 sample files with 10 records, what about order ?

Posting Permissions

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