workbook sheets into separate files

Hi Markx

Try this one
http://www.rondebruin.nl/copy6.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"markx" <[email protected]> wrote in message news:ey$Da5%[email protected]...
> Hello guys,
>
> Any idea how to write a simple and "elegant" macro that could "convert" all the tabs from an open workbook into separate files
> (without destroying the original file)?
> - with the new files' names being the old tab names
> - with a kind of "paste special/values" applied to every sheet (in order to eliminate any particular issues that could arise from
> the (potentially) existing links between the initial tabs).
>
> Thanks a lot for any help on this!
> Markx
>
>
>

Hi Markx

Try this one
http://www.rondebruin.nl/copy6.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"markx" <[email protected]> wrote in message news:ey$Da5%[email protected]...
> Hello guys,
>
> Any idea how to write a simple and "elegant" macro that could "convert" all the tabs from an open workbook into separate files
> (without destroying the original file)?
> - with the new files' names being the old tab names
> - with a kind of "paste special/values" applied to every sheet (in order to eliminate any particular issues that could arise from
> the (potentially) existing links between the initial tabs).
>
> Thanks a lot for any help on this!
> Markx
>
>
>

Hello guys,

Any idea how to write a simple and "elegant" macro that could "convert" all
the tabs from an open workbook into separate files (without destroying the
original file)?
- with the new files' names being the old tab names
- with a kind of "paste special/values" applied to every sheet (in order to
eliminate any particular issues that could arise from the (potentially)
existing links between the initial tabs).

Thanks a lot for any help on this!
Markx

Hi Markx

Try this one
http://www.rondebruin.nl/copy6.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"markx" <[email protected]> wrote in message news:ey$Da5%[email protected]...
> Hello guys,
>
> Any idea how to write a simple and "elegant" macro that could "convert" all the tabs from an open workbook into separate files
> (without destroying the original file)?
> - with the new files' names being the old tab names
> - with a kind of "paste special/values" applied to every sheet (in order to eliminate any particular issues that could arise from
> the (potentially) existing links between the initial tabs).
>
> Thanks a lot for any help on this!
> Markx
>
>
>