convert multi-sheets file to single-sheet files
I have an excel file, let's say "file A", which contains 100 sheets and need to convert it to 100 excel files where each file has one sheet out of the sheets in "file A". And file name of the converted should be the same as the sheet contained. Please anybody help me in this.
I just realized my code simply makes multiple copies of the current workbook and its sheets, not each sheet separately. To do what you're asking, take a look at the code here: http://www.mvps.org/dmcritchie/excel/saveas.htm
I think it will do what you're hoping to accomplish.
Last edited by Paul; 04-22-2007 at 02:21 AM. Reason: Code was wrong.
Thank you very much, Paul.
I created a commandbutton, pasted the code into Private Sub CommandButton1_Click and then tried to run it but Microsoft Visual Basic errored out saying 'can not find the path' at 'MkDir xpathname' line. It would be great if you could give me any advise. I am asking of course the auther as well.
Thanks a lot,
yahata
Paul,
I created a folder "temp" under my C:, and then, the problem has been resolved.
However, now the VB has stopped at a different line.
Thank you for your advice.
yahata
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks