Save worksheets as seperate files [Closed]

Question

Save worksheets as seperate files [Closed]

Report

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

Save worksheets as seperate files
Save ping to text file - How-To - Windows
Save bookmarks chrome to file - How-To - Google Chrome
Save image as icon file - How-To - Windows
Split excel worksheets to individual files online - How-To - Excel
Save png as icon file - How-To - Multimedia

1 reply

Ask a question

Jiri · Answer 1 · 2009-08-17T10:30:37-0400

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

Save worksheets as seperate files [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!