Open multiple files into multiple worksheets of the same workbook

[lil Matt]

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]

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 [email protected]>
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.