Hello,

I am not sure I understand. When you copy over from one worksheet to
another, don't yopu simply copy the formulas? If I will co this copying for
all the sheets in the source workbook, shouldn't I recreate the exact
strucutre of the original workbook?

Also, is the Worksheet.Copy method working for copying from one workbook to
another? This supposedly copies everything.

Regards,
Levente


"macropod" wrote in message
...
Hi LF,

To make a complete replica, you'd be better off simply copying the file
with
Windows Explorer. Otherwise, if your source workook has multiple sheets
with
formulae referring to different sheets, you're likely to end up with the
links to the original source workbook, not the copy.

Having said that, if you really want to copy & paste everything, use
Ctrl-A
then Ctrl-C to copy the sourceworksheet, then Ctrl-V to paste it into the
target.

Cheers

--
macropod
[MVP - Microsoft Word]


"LF" wrote in message
...
Hello,

I have a workbook open and I want to populate it with the content of
another
xls file. How can I do that. I wan everything transferred: values,
formulas,
embedded object, formatting, everyhting. I figured that I coould do a
sheet
by sheet copy/paste (of course, enumerating the sheets and chart sheets
in
the source document, recreating them in the destination document and then
doing the copy), but I am having a hard time copying over anything else
than
values. Also, where are the macros stored? In each sheet or are they
workbook specific? Is there anything else to copy over to make the opened
document identic to the one I am copying from?

Because the destination workbook is already open, I cannot do a
SaveCopyAs
on the source workbook and then open that. I need to work with the one
that
is already opened.

Any help or guidance is greately appreciated, thank you.

Regards,
Levente