Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing multiple text files into single 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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing multiple text files into single workbook
This should work:-
Sub Macro1() Workbooks.Open Filename:= "filename.txt" Selection.Copy Windows("Book1").Activate Range("A1").Select ActiveSheet.Paste MsgBox ("Complete") End Sub Just put the path and filename of "filename.txt" and the current workbooks name in "Book1" --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing multiple text files into the same worksheet | Excel Discussion (Misc queries) | |||
Importing multiple Text files into Excel 2003 | Excel Discussion (Misc queries) | |||
importing multiple text files URGENT!!! HELP | Excel Worksheet Functions | |||
importing multiple text files??? | Excel Discussion (Misc queries) | |||
Importing Multiple lines of text in a single Excel Cel | Excel Programming |