How do you copy saved excel sheets to a new workbook
 

I'm using Ron De Bruin's code to copy worksheets to a folder. How can I copy
these
sheets to a new workbook?

How do you copy saved excel sheets to a new workbook
 

On Feb 14, 11:00*am, chrisnsmith
wrote:
I'm using Ron De Bruin's code to copy worksheets to a folder. *How can I copy
these
sheets to a new workbook?

A simple way could be to copy the file, name it and then delete the
extra sheets you don't need.

How do you copy saved excel sheets to a new workbook
 

Right-click on the tab for a sheet, then choose "Move or Copy Sheets", and
choose which workbook you want as the destination for the copy.
--
David Biddulph

chrisnsmith wrote:
I'm using Ron De Bruin's code to copy worksheets to a folder. How
can I copy these
sheets to a new workbook?

How do you copy saved excel sheets to a new workbook
 

You can't save just a sheet to a folder so you must be mis-interpreting the
function of Ron's code.

His code probably copies one sheet from a workbook to a new workbook before
saving to a folder.

Post the URL for the code from Ron's site.


Gord Dibben MS Excel MVP

On Sat, 14 Feb 2009 00:00:01 -0800, chrisnsmith
wrote:

I'm using Ron De Bruin's code to copy worksheets to a folder. How can I copy
these
sheets to a new workbook?