Save worksheets as seperate files

Closed
ujo Posts 8 Registration date Wednesday July 15, 2009 Status Member Last seen September 23, 2009 - Aug 17, 2009 at 04:10 AM
 Jiri - Aug 17, 2009 at 10:30 AM
Hello,

I want to save the sheets in a work book as seperate files. Also these files should have one of the vba module from the parent workbook

Ujo
Related:

1 response

Hello,
i am not sure that i help you. But i think, you can save an origin file, after that can you delete all sheets excepting one and these one can you save and than you have to open your origin file once more. These procedure can you repeat until all sheets are saved. You can write this makro in a sidefile or you can run this makro after every opening of origin file (you can have a makro for open this file by closing of foregoing) where can you save, how many sheets were saved (when all, no macro will be started)...
Best regards
Jiri