Hi

Here is a code example to do this
http://www.rondebruin.nl/copy6.htm


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


"CWH" wrote in message ...
Using Excel 2003

I have a file with 30 tabs, I would like to keep that file intact and the
have a new file for each of the tabs ie 30 new files. Is there an easy way
do this other than copy each tab in the normal way
--
CWH