ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Open multiple files into multiple worksheets of the same workbook (https://www.excelbanter.com/excel-discussion-misc-queries/116907-open-multiple-files-into-multiple-worksheets-same-workbook.html)

lil Matt

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.

Jim Cone

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.


All times are GMT +1. The time now is 06:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com