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

C

CWH

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>
 
C

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.
 
C

CWH

Ron

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