| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying the Editing in one file to Another opened XLS file | Excel Worksheet Functions | |||
| how i make a pgm in excel for copying all the rows to a new file . | Excel Discussion (Misc queries) | |||
| Copying and renaming a file | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Copying Tabs in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
