moving a sheet to new workbook

**share knowledge** · 07-22-2011, 01:45 AM

Dears
I have a workbook with some 60 (59+1) sheets. 59 will be different all the time but 1 worksheet will always be named as ""Master"".

Now I want every worksheet to be saved as a new workbook along with the Master sheet. Ultimately after running the macro I want to see 2 sheets in the new workbook out of whih this MASTER sheet is common in all the workbooks

The below code allows me to save every active worksheet as a new workbook in one particular folder.
However I couldn't move/copy the MASTER.

Your help is appreciated.Thanks"

Please Login or Register  to view this content.

**share knowledge** · 07-22-2011, 01:54 AM

With the help of the above code I could save the sheets as a new workbook, but my MASTER sheet is not getting saved along with the other worksheets.

**share knowledge** · 07-22-2011, 09:50 AM

any help on this pls?

I have crossed more than half a bridge using Ron's code.......

**MaczaQ** · 07-22-2011, 12:13 PM

hi,

what about my code ?

Please Login or Register  to view this content.

Best Regards
MaczaQ

**share knowledge** · 07-22-2011, 01:07 PM

thank you for the code.

Does this code saves master sheet alone as a new workbook? or

by default it moves the master sheet to the every other workbook in a particular folder?

i could not test this now as i dun have excel with me...

**MaczaQ** · 07-22-2011, 01:11 PM

my solution create copy for each sheet with name other then Master so if you have sheets: Master + 10 worksheets (diffrent names) you will get 10 xls files containt 2 sheets each (Master + 1 of other name sheet). Source workbook will be not changed.

Best Regards
MaczaQ

**share knowledge** · 07-25-2011, 01:41 AM

Hi

getting below error mesage

compile error:

Wrong number of arguments or invalid property assignment

**share knowledge** · 07-25-2011, 01:42 AM

is it possible to add an argument to my existing code?

**MaczaQ** · 07-25-2011, 09:57 AM

make sure that your master sheets is called "Master" and that you are not using characters not allowed in system files name ({}_+,.?> etc.)

In attached file you will find working example.

Best Regards