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.