Save worksheets as seperate files [Closed]

Report
Posts
8
Registration date
Wednesday July 15, 2009
Status
Member
Last seen
September 23, 2009
-
 Jiri -
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

1 reply

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!