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

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

If you do File Save As (for the "complicated" source .xls), you could then
build it up further from there. I'm presuming of course, that the "other"
workbook you have is almost like a "new" workbook which contains only some
work easily copied & pasted over into this "saved as" copy, in new sheets
for example. Anyway, this is the route I'd naturally take for such
instances.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"LF" wrote in message
...
Max,
I already have the workbook opened where I want to bring things in (from a
file). I cannot use SaveAs.
Regards,
Levente

If you do File Save As (for the "complicated" source .xls), you could then
build it up further from there. I'm presuming of course, that the "other"
workbook you have is almost like a "new" workbook which contains only some
work easily copied & pasted over into this "saved as" copy, in new sheets
for example. Anyway, this is the route I'd naturally take for such
instances.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"LF" wrote in message
...
Max,
I already have the workbook opened where I want to bring things in (from a
file). I cannot use SaveAs.
Regards,
Levente