Max,
I already have the workbook opened where I want to bring things in (from a
file). I cannot use SaveAs.
Regards,
Levente

"Max" wrote in message
...
Why not just do a File Save As, within the existing .xls that you want
everything retained ?
(give it a new file name)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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