Open multiple files into multiple worksheets of the same workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 (e-mail address removed)>
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking multiple worksheets in one workbook 2
Import Multiple CSV Files from Same Folder into Open Workbook 5
multiple workbooks in one file 3
Print selected worksheets in multiple workbooks? 1
Merge Multiple workbook sheets into one workbook 0
Embed Multiple Worksheets in PowerPoint 1
Excel shortcut options 0
consolidate workbooks to worksheets in one workbook? 1

Back
Top