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

[Guest]

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>

 

[Ron de Bruin]

Hi

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

 

[Guest]

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.

 

[Ron de Bruin]

Hi CWH

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

 

[Guest]

Ron

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