+ Reply to Thread
Results 1 to 4 of 4

Import TXT files from a specific folder into Excel - TXT file names change hourly

  1. #1
    Registered User
    Join Date
    05-26-2013
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    13

    Question Import TXT files from a specific folder into Excel - TXT file names change hourly

    I need to create a macro that will IMPORT TXT files (the number of files will vary from 2 to 10, their size will be a constant 4 columns) from a specific folder (always the same folder). The names of the TEXT files will never be the same. I need to IMPORT each file into a separate tab within the same workbook. The files need to be imported as delimited, comma separated, with the first column formatted as TEXT. (If this could be made to operate all by itself at set intervals, deleting the original TEXT files it used each time, that would be a bonus)

    Now, if you really want to get dirty...what would be EVEN MORE helpful (I don't even know if this is possible or not) would be to create something that would poll a remote FTP folder and download a TEXT file, import it into a specific EXCEL spreadsheet to a specific tab, save a different tab within that spreadsheet that has made calculations based upon the imported text file and then upload that newly save file to an internet site.

    I would be VERY HAPPY if somebody could just help me get the first part right. I've done a lot of searching on the net and I just can't get it figured out. I keep getting errors with everything I try. So, I'm hoping for some assistance from you nice folks.

    Thanks in advance!

    Jeff

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Import TXT files from a specific folder into Excel - TXT file names change hourly

    You need something like:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-26-2013
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Import TXT files from a specific folder into Excel - TXT file names change hourly

    Looks great ! Thanks!

    Is there any way to keep Excel open and have it poll the folder periodically?

    Thanks, again!

  4. #4
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Import TXT files from a specific folder into Excel - TXT file names change hourly

    Try a google search/ask that in a separate thread.

    Personally I wouldn't use excel for that sort of task.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 17
    Last Post: 12-06-2011, 11:50 AM
  2. [SOLVED] Change names of Files in a folder
    By TISR in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2006, 05:45 AM
  3. Replies: 1
    Last Post: 01-24-2006, 11:35 AM
  4. Replies: 1
    Last Post: 01-24-2006, 11:00 AM
  5. Replies: 1
    Last Post: 01-24-2006, 12:25 AM

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