How to copy workbook?
Saruman,
I am only interested in doing this programatically.
Regards,
Levente
"Saruman" wrote in message
...
You must have one sheet left in the Workbook when you do this!! You may
need to insert a blank sheet to start with.
Why not open both files, group all the sheets together by holding down the
Shift key and clicking on the last sheet, which will highlight every sheet
from the start to where you are clicking.
Then right click on the grouped sheets and select the Move or Copy option.
In the dropdown box, select the file name where you want the pages to go
to.
Select before which current sheet where you want the sheets to appear.
Click OK.
Done.
Try it on a copy first just in case of problems.
Saruman
"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
|