| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing text files into a "cached" worksheet?
I have read lots of good info in the NG on how to import CSV files
into current workbook, worksheet etc. With these methods, if I import 5 files for example, I'll end up with 5+1=6 sheets, the 5 imported files plus the original sheet. However, I want to import the files, do something with the data in all of them, and put the final data into the ONE sheet, so my workbook ends up with this ONE sheet. Besides creating the worksheets and then deleting them later, can I just "cache" them? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting "Rolodex" text format for importing | Excel Discussion (Misc queries) | |||
| Macro that searches 5 files .xls and in every worksheet in every file is looking for "text". | Excel Programming | |||
| importing a text file - problem with dates "Americanising" | Excel Discussion (Misc queries) | |||
| Help importing "Text to Columns" repeatedly | Excel Discussion (Misc queries) | |||
| "Advanced" Text file importing | Excel Programming | |||
![Zilla[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
