Excel VBA - copy cells to another workbook

[cjh1984]

Hi.

Is it possible to use VBA in one workbook to copy a worksheet fro
another workbook into another different workbook?

If so....how?

Thank

 

[Frank Kabel]

Hi
try recoding a macro while doing this manually. And yes it is possible

 

[William Hamilton]

Hi.

Is it possible to use VBA in one workbook to copy a worksheet from
another workbook into another different workbook?

If so....how?

Thanks

A good place to start on this is http://www.rondebruin.nl/tips.htm a few
variants on offer.


cheers

W