| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing all files in a folder to excel workbook
I am VERY VERY VERY new to VB programming. I am looking to import all
5 text files from a folder and then sort them into 5 separate columns in my workbook starting at A43 for the first file, B43 for the second file, etc... 5 new text files will be placed in this folder everyday with different extensions. One has extension .057, .092, .159, .278 and finally .714. I want the macro to only read the extensions from these files and not what comes before the extension. Does this make any sense? Any help would be greatly appreciated!! K. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| importing multiple text files into individual worksheets in workbook | Excel Programming | |||
| Importing all the .txt files of a folder in a same WB but in different WSheets | Excel Programming | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Programming | |||
| Importing multiple text files into single workbook | Excel Programming | |||
Threaded Mode
