Multiple files

[Clayton L. Wilson]

I have six files. Each one with 65535 lines. The most
excell will hold per sheet. What I need to do is to load
all six files into one workbook with each file being in
its own sheet. How do I do this? Thanks.

 

[Paul Corrado]

Clayton,

Easiest way is probably to open the files and Copy the worksheets to the
same workbook.

Right click on the worksheet tab and select Move Or Copy, select the Copy
option then select New Workbook for the first one and since that should be
Book1, select Book1 for the remainder.

While I can't say for sure, it would seem that the workbook will be slow to
calculate and it may be better to look into database software and then using
XL's Data|Get External Data to query the database and import the information
you need.

PC

 

[Laura Cook]

Thinking really hard about exactly what you want and then it happening.

Maybe throw in a wiggle of the nose.



Laura Cook
Appleton, WI