Save excel pages as seperate files

[iansa]

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

[Ron de Bruin]

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" <iansa@discussions.microsoft.com> wrote in message news:A90AFA72-EFB3-45BD-B66C-F81099A6990C@microsoft.com...
>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

[iansa]

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" <iansa@discussions.microsoft.com> wrote in message news:A90AFA72-EFB3-45BD-B66C-F81099A6990C@microsoft.com...
> >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
>
>
>