Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Saving worksheets within workbooks as individual files
HI all I have a small problem I can't solve: I have a workbook of 50 worksheets. Each worksheet in the workbook has different data. I want to save each individual worksheet out as a stand-alone xls file. When I go to save each of the worksheets , I find that excel saves the whole work book. How can I save the contents of individual worksheets as discrete files , containing just the data in the individual worksheet? Grateful for any help. Best Wishes Colin |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Saving worksheets within workbooks as individual files
Hi
With code you can do this http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Colin Hayes" wrote in message ... HI all I have a small problem I can't solve: I have a workbook of 50 worksheets. Each worksheet in the workbook has different data. I want to save each individual worksheet out as a stand-alone xls file. When I go to save each of the worksheets , I find that excel saves the whole work book. How can I save the contents of individual worksheets as discrete files , containing just the data in the individual worksheet? Grateful for any help. Best Wishes Colin |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Saving worksheets within workbooks as individual files
Colin,
You could right click individual sheet tabs, move or copy to new book (new file) Beege "Colin Hayes" wrote in message ... HI all I have a small problem I can't solve: I have a workbook of 50 worksheets. Each worksheet in the workbook has different data. I want to save each individual worksheet out as a stand-alone xls file. When I go to save each of the worksheets , I find that excel saves the whole work book. How can I save the contents of individual worksheets as discrete files , containing just the data in the individual worksheet? Grateful for any help. Best Wishes Colin |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Saving worksheets within workbooks as individual files
In article , Ron de Bruin
writes Hi With code you can do this http://www.rondebruin.nl/copy6.htm Hi Ron OK I tried this. I pasted the code from your page into my macro and hoped it would take each of the 50 sheets in turn and save them out as individual xls files. They're just numbered 1-50. Unfortunately , it only saved three files , all of them empty! I'm doing something wrong , clearly. I'll try again. Best Wishes Colin |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Saving worksheets within workbooks as individual files
I send you a private mail
-- Regards Ron de Bruin http://www.rondebruin.nl "Colin Hayes" wrote in message ... In article , Ron de Bruin writes Hi With code you can do this http://www.rondebruin.nl/copy6.htm Hi Ron OK I tried this. I pasted the code from your page into my macro and hoped it would take each of the 50 sheets in turn and save them out as individual xls files. They're just numbered 1-50. Unfortunately , it only saved three files , all of them empty! I'm doing something wrong , clearly. I'll try again. Best Wishes Colin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How many workbooks and worksheets can Excel understand? | Excel Discussion (Misc queries) | |||
Saving an Excel document after moving additional worksheets to it | New Users to Excel | |||
Convert excel worksheets into new workbooks (new files) | Setting up and Configuration of Excel | |||
Linking set of worksheets between different workbooks! | Excel Discussion (Misc queries) | |||
Converting worksheets to workbooks. Is there an easy way? | Excel Discussion (Misc queries) |