workbook sheets into separate files
 

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" wrote in message ...
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