Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy sheets to workbook and save as sheet name
Hi There,
I have a spreadsheet over 40 sheets. What i like to do is to: 1) copy each sheet into its own workbook 2) name that workbook that matchs the sheet name 3) User selects the directory where the first file is saved and saves the directory for the rest of the sheets within the workbook 4) Closes the saved workbook that has one sheet in it Can you help? thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy sheets to workbook and save as sheet name
Try this one
http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "umpire_43" wrote in message ... Hi There, I have a spreadsheet over 40 sheets. What i like to do is to: 1) copy each sheet into its own workbook 2) name that workbook that matchs the sheet name 3) User selects the directory where the first file is saved and saves the directory for the rest of the sheets within the workbook 4) Closes the saved workbook that has one sheet in it Can you help? thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy sheets to workbook and save as sheet name
Hi Ron,
Worked great ty Just some fine tuning now "Ron de Bruin" wrote: Try this one http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "umpire_43" wrote in message ... Hi There, I have a spreadsheet over 40 sheets. What i like to do is to: 1) copy each sheet into its own workbook 2) name that workbook that matchs the sheet name 3) User selects the directory where the first file is saved and saves the directory for the rest of the sheets within the workbook 4) Closes the saved workbook that has one sheet in it Can you help? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy several sheets from a workbook to a single sheet in a new wor | Excel Programming | |||
Copy specific Sheets and save them as a workbook | Excel Programming | |||
copy 3 sheets & save them into new workbook | Excel Programming | |||
copy 3 sheets & save them into new workbook | Excel Programming | |||
Looking to save one sheet in a workbook of two sheets... | Excel Programming |