Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy text files into multiple sheets of 1 workbook
Hi everyone. I have a folder that receives data dumps from a
different system. The files are text files, contain data on only 1 sheet, and the names of the files are generated from the other system. I would like a macro that would allow me to select various files within the same folder, and copy the data into a seperate worksheet within the same workbook. So basically, I'd like to choose and consolidate multiple text files into 1 excel workbook containing many worksheets. I have very limited knowledge of VBA. Thanks so much!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy chart between multiple sheets in workbook | Charts and Charting in Excel | |||
Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
How do I copy print formatting to multiple sheets in a workbook? | Excel Discussion (Misc queries) | |||
copy data in one sheet to multiple sheets in same workbook | Excel Worksheet Functions |