loop through the workbook and paste every sheet it into newly createdworkbook with same sheet name

  • Thread starter Thread starter vicky
  • Start date Start date
V

vicky

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 .
 
If you are not adding to an existing workbook, you could just as easily do a
SaveAs on the source workbook to the Filename you want to use for the new
workbook. This would give you the new workbook with the sheets having the
same name and content.
 
Back
Top