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

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

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

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

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