Copy worksheets from file A to file B

[ikkyu]

Hi,

I would like to know how I can copy (not link) more than one worksheets from
file A.XLS to file B.XLS with everything (format, macros, etc)?


@+

Hepta

Time, is, the greatest thief

 

[Frank Kabel]

Hi
have a look at
http://www.rondebruin.nl/copy4.htm

 

[Dave Peterson]

Open both workbooks.

Select the worksheets in A.xls that you want to copy (click on the first tab and
ctrl-click on subsequent).

then Edit|Move or Copy Sheet
Check the bottom "create a copy" checkbox.

And make the "to book:" B.xls

The macros behind the worksheet will go with the copy. The macros in General
modules (and other spots like ThisWorkbook) won't.)

But you could copy those general modules by dragging and dropping (and the
ThisWorkbook module by copy|pasting).

 

[Hepta]

Many thanks, Dave.

Open both workbooks.

Select the worksheets in A.xls that you want to copy (click on the first tab and
ctrl-click on subsequent).

then Edit|Move or Copy Sheet
Check the bottom "create a copy" checkbox.

And make the "to book:" B.xls

The macros behind the worksheet will go with the copy. The macros in General
modules (and other spots like ThisWorkbook) won't.)

But you could copy those general modules by dragging and dropping (and the
ThisWorkbook module by copy|pasting).