Results 1 to 2 of 2

Thread: Import Multiple Text Files into Excel - for beginners

  1. #1

    Cool Import Multiple Text Files into Excel - for beginners



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

    I need some hand holding please. Zero experiences with VBA - step by step appreciated by me and the hordes of newbies...
    I need to import multiple text files into an Excel spreadsheet.
    the files are simple text, single line, single column no parsing needed.
    I want to import multiple files into a column in a worksheet
    folder = /filefolder/
    files = textfile-01.txt
    textfile-02.txt through textfile-250.txt

    I want textfile-01.txt to be in C1
    I want textfile-02.txt to be in C2 etc.

    I got as far as ALT+F11 opens VBA editor....
    thanks in advance

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    118
    Articles
    0
    Cross-posted at EF

Tags for this Thread

Posting Permissions

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