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

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 .
 
J

JLGWhiz

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to prevent a graph update 2
Copy cell value from one worksheet to matching worksheet in another workbook 4
How to copy and paste a sheet by pressing a button to another work 1
Create new worksheet and use a number as its name.. 1
Code to 'unbundle' and array 1
Export Sheet Values to new workbook 20
Copy worksheet, trying to paste to new workbook error assistance. 1
Move to every record on every worksheet 3

Top