| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open multiple files into multiple worksheets of the same workbook
I would like to open multiple text delimited files into the same workbook,
with each file open into a separate worksheet of the same workbook. Please show me a step by step how to do this. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Open multiple files into multiple worksheets of the same workbook
This post has code to do that.
Look for the R2 version of the code near the bottom of the post... http://tinyurl.com/yg7q8m -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "lil Matt" <lil wrote in message ... I would like to open multiple text delimited files into the same workbook, with each file open into a separate worksheet of the same workbook. Please show me a step by step how to do this. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
| How do I open several worksheets from the same workbook on screen | Excel Worksheet Functions | |||
| open multiple files | Excel Discussion (Misc queries) | |||
| How do you open multiple files in specifc order? | Excel Discussion (Misc queries) | |||
| How to search multiple worksheets in a workbook for information? | Excel Discussion (Misc queries) | |||
Linear Mode
