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
Bookmarks