I have a MS Word macro that opens an Excel file then copies certain
information from the Word document and places in in specified locations
in the Excel spreadsheet. No problem there. What I would now like to
do is extend the macro to open an additional Excel file and copy
certain data from the second file into the first file.

I would list the macro here but it is long and I am having no problems
with it. The key is to be able to open the second Excel file while
keeping the first Excel file open.

Any suggestions?

Garry