Turn on the macro recorder and do it manually.

If you want to copy an entire sheet, do that, via Edit/Move or Copy Sheet.
OTOH, if you only want to copy cell contents, do that: select the cells, Copy,
switch to the other book and paste.

Turn off the recorder and, if necessary, modify the code that was generated to
make it more general. Post back if you have problems with the latter.


On Sun, 10 Oct 2004 17:57:12 -0700,
wrote:

Hi,

I'm trying to write a macro that copies the data from one
excel file from a different workbook into another one,
can anybody help

Thank You