|
Posted to microsoft.public.excel.programming
|
|
|
loop through the workbook and paste every sheet it into newly created workbook with same sheet name
See also
http://www.rondebruin.nl/copy6.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"vicky" wrote in message ...
i have a workbook which contain many sheets . i have to loop through
the workbook and paste every sheet it into newly created workbook
with same sheet name... hope this is possible .
|