Two Files, Separate worksheets

[kerryp]

I need to load Excel File A into the application, then load File B
into a second worksheet of the same instance. Can you point me to
where I can learn to do this. Thanks

 

[Ian]

Open the first file, then, from the file menu of that open application, open
the second file.

This will open both files in the same instance of Excel, but they are still
separate workbooks. If you want both files to become part of the same
workbook, that is a totally different thing.

 

[kerryp]

I meant I want to open two files in the same workbook, each in a
separate worksheet. Thanks ian for the response.

 

[Ian]

I suspected that might be the case, which is what I referred to in my last
sentence.

As a workbook is one file, the only way might be to copy everything from
workbook A to a sheet in workbook B. Unfortunately this would mean the
combned sheets would then be one file, unless you they copy it back after
editing. Not a reliable thing to do as there are too many chances of error.

One option might be to use the Insert object facility to link to the second
file. Insert>Object>Create from file possibly selecting Link to file. I've
no real experience of doing this, so you'd be as well trying the different
options out on COPIES of your files, before committing to the originals.

HTH