Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Advanced" Text file importing
Hi All,
I am receiving a quite large number of tab separated text files with information each week (50+), that I need to import into an Excel sheet and then work with=produce reports :( It is quite time consuming to run the File import utility for each file, and I would therefore like to create a macro assigned to a button that should do the following. For each text file in a folder, sorted by file name or creation date, do the following: 1. Import the tab separated data, and append it to the already existing data in the active sheet. The information should be imported like the example below 2. Move the file to another folder, an "archive" If I have this I can easily create a rule in Outlook that stores my text files in a certain folder, open excel, push the button, and be ready to work. Would be great! The file that should be imported looks like this: Header1 Header2 Colummn Header 1 Column Header 2 Column Header 3 ROW1-1 ROW1-2 ROW1-3 ROW2-1 ROW2-2 ROW2-3 ROW3-1 ROW3-2 ROW3-3 Footer1 Footer2 Footer3 Ideally, I would like the excel spreadsheet to look like this: Header2 ROW1-1 ROW1-2 ROW1-3 Header2 ROW2-1 ROW2-2 ROW2-3 Header2 ROW3-1 ROW3-2 ROW3-3 I have tried to write macros for this but cannot make it work. If all cannot be done (I realize this might be quite complex) I would appreciate any help with getting as close as possible to the ultimate solution! Many thanks, David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting "Rolodex" text format for importing | Excel Discussion (Misc queries) | |||
text string: "91E10" in csv file auto converts to: "9.10E+11" | Excel Discussion (Misc queries) | |||
Avoiding "0" importing blank cells from another Excel file | Excel Discussion (Misc queries) | |||
importing a text file - problem with dates "Americanising" | Excel Discussion (Misc queries) | |||
.csv drops "0" when saved, even if file was set as "text". | Excel Discussion (Misc queries) |