| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy all sheets to a new workbook | Setting up and Configuration of Excel | |||
| why i cant copy sheets in excel workbook | Excel Discussion (Misc queries) | |||
| Change location of auto saved back up copy of shared workbook? | Excel Discussion (Misc queries) | |||
| How can I see a copy of a saved workbook before I saved it again? | Excel Worksheet Functions | |||
| how do i increase the sheets in a saved excel workbook? | Excel Worksheet Functions | |||
Hybrid Mode
