| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save excel pages as seperate files
I am trying to find a way to save a one worksheet document with page breaks
as several separate files, one for each page. Any help with this would be appreciated. thanks in advance ian |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save excel pages as seperate files
Try this
http://www.rondebruin.nl/hpagebreaks.htm Then this one http://www.rondebruin.nl/copy6.htm Or change the code from the first macro to do it in one step -- Regards Ron de Bruin http://www.rondebruin.nl "iansa" wrote in message ... I am trying to find a way to save a one worksheet document with page breaks as several separate files, one for each page. Any help with this would be appreciated. thanks in advance ian |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save excel pages as seperate files
Perfect, many thanks
ian "Ron de Bruin" wrote: Try this http://www.rondebruin.nl/hpagebreaks.htm Then this one http://www.rondebruin.nl/copy6.htm Or change the code from the first macro to do it in one step -- Regards Ron de Bruin http://www.rondebruin.nl "iansa" wrote in message ... I am trying to find a way to save a one worksheet document with page breaks as several separate files, one for each page. Any help with this would be appreciated. thanks in advance ian |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save excel pages as seperate files
Ron,
How would one remove the password protection on the original file when copied to the new file and folder? -- Rock "Ron de Bruin" wrote: Try this http://www.rondebruin.nl/hpagebreaks.htm Then this one http://www.rondebruin.nl/copy6.htm Or change the code from the first macro to do it in one step -- Regards Ron de Bruin http://www.rondebruin.nl "iansa" wrote in message ... I am trying to find a way to save a one worksheet document with page breaks as several separate files, one for each page. Any help with this would be appreciated. thanks in advance ian |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save excel pages as seperate files
The sheet protection ?
Have all sheets the same password ? -- Regards Ron de Bruin http://www.rondebruin.nl "rockflier" wrote in message ... Ron, How would one remove the password protection on the original file when copied to the new file and folder? -- Rock "Ron de Bruin" wrote: Try this http://www.rondebruin.nl/hpagebreaks.htm Then this one http://www.rondebruin.nl/copy6.htm Or change the code from the first macro to do it in one step -- Regards Ron de Bruin http://www.rondebruin.nl "iansa" wrote in message ... I am trying to find a way to save a one worksheet document with page breaks as several separate files, one for each page. Any help with this would be appreciated. thanks in advance ian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I have seperate headers for seperate pages in 1 worksheet? | Excel Discussion (Misc queries) | |||
| How do I save/update work to appear in 2 seperate files? | Excel Discussion (Misc queries) | |||
| save worksheets as seperate files (I know how to do it one by one) | Excel Discussion (Misc queries) | |||
| Matching data from seperate excel files | Excel Worksheet Functions | |||
| Concatenate excel files in one with seperate worksheets | Excel Programming | |||
Linear Mode
