MACRO to save worksheets as seperate files ?
Posted by Steven on November 13, 2001 9:53 PM
I would like to be able to run a macro which saves the various worksheets in a workbook under their respective names in seperate files.
To give a bit more background information: I have a file which contains many worksheets. Each worksheet contains personal information and is named after that person. In order to send the person the confidential information, I need to strip the workbook from all the other sheets and name the workbook (with one sheet left) after that person. Without a macro I have to do this many times (unfortunately !).
So my question is whether anybody knows about a macro that is able to split up a workbook with x sheets in x files and giving that file the name of that particular worksheet ?
Thanks in advance for your feedback.