Bill,

I have a couple ideas on how you could do this:

One way would be to open both Excel files, then in the excel file you want
to move, right click on the sheet tab and select "Move or Copy...". In the
Move or Copy dialog box, select the "To book:" drop down list and choose the
workbook you want to place the data into. Then in the "Before sheet:" list,
select which sheet it should be placed in front of.

Make sure to also check the "Create a copy" option at the bottom of the
dialog box if you don't want to move the data there.

This probably isn't exactly what you were looking for, since it does place
the data in a new sheet, but at least it gets it into the workbook easily.

I guess the other option for moving the data quickly is to just do a copy
and paste from one spreadsheet to the other. When you go to paste the data,
right click the cell you want to paste it to and select "Paste Special...".
From this dialog box, you'll have a number of options on how to paste the
data. You can play around with the options until you get the data in the
form you want.

"Bill Coupe" wrote:

I know there has to be a simple way to do this, but I can't seem to find it.

What I want to do is to open an existing Excel file, 'into' the current
(ActiveSheet) of an already open file.

The way I found to do it was to use the 'Data\Import External Data' option.

My ultimate goal here is to 'gather up' a set of recently generated
spreadsheets (each containing only one worksheet) into one Excel file
contaiing all the individual files from within a VFP application.

But having to add a 'Connection' to native data just doesn't seem right to
me...

I'd love to hear anyone's thoughts on this.

Thanks - Bill