Copying many tabs from one file to an individual file for each tab
 

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

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

Many thanks for the macro, I have tried it and I receive the following error
message "Run time error "75": Path/File access error" and when I debug it
highlights the line MkDir FolderName.

Where am I going wrong.
--
CWH


"Ron de Bruin" wrote:

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

Hi CWH

Have you change the macro?
Which Excel version do you use?



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


"CWH" wrote in message ...
Many thanks for the macro, I have tried it and I receive the following error
message "Run time error "75": Path/File access error" and when I debug it
highlights the line MkDir FolderName.

Where am I going wrong.
--
CWH


"Ron de Bruin" wrote:

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

Ron

I have not changed the macros, I copied it from your message. I am using
Excel 2003,

--
CWH


"Ron de Bruin" wrote:

Hi CWH

Have you change the macro?
Which Excel version do you use?



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


"CWH" wrote in message ...
Many thanks for the macro, I have tried it and I receive the following error
message "Run time error "75": Path/File access error" and when I debug it
highlights the line MkDir FolderName.

Where am I going wrong.
--
CWH


"Ron de Bruin" wrote:

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