Consulting

Results 1 to 4 of 4

Thread: Mulitple importing of text files

  1. #1
    VBAX Newbie
    Joined
    Nov 2007
    Posts
    1
    Location

    Mulitple importing of text files

    HI all

    I have searched quite a bit and found the article "Import Notepad and workpad text files" --->all the www's (wont let me paste the link)

    vbaexpress.com/kb/getarticle.php?kb_id=497#instr

    Which works great for me, however, i need to be able to select more then one file at a time to import.

    Any suggestions

    Thanks

  2. #2
    How many do you need ? (is it always the same number ? does it increase by 1 each month ? )
    It it a folder full ?
    What about click and drag ?
    What have you tried ?
    2+2=9 ... (My Arithmetic Is Mental)

  3. #3
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    This is the correct link from post #1
    http://vbaexpress.com/kb/getarticle.php?kb_id=497
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  4. #4
    VBAX Expert
    Joined
    Aug 2007
    Location
    Windermere, FL, a 'burb in the greater Orlando metro area.
    Posts
    567
    Location
    Stolie,

    Let's say that you have 5 files to import. Why not use the tool you found 5 times, pulling each file in, in turn?

    What drives the requirement to suck them all up at one time? How do you want to designate the files? Enter a list of names? Select them all from a list? or. ... (fill in your choice).

    Thanks,

    Ron
    Orlando, FL

Posting Permissions

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