Hi
I have been trying to do a simple excel macro that would extract certain sheets from a workbook and save (values and page setup only) them separately into a defined folder.
Basically:
There will be a mapping sheet that contains a list of sheetnames. Next column there will be a simple letter to denote which folder it should go under.
Ex.
A1 Sheet1 B1 P
A2 Sheet3 B2 T
C1 Sheet1 D1 T
(T) = Test
(P) = Post
Result will be 2 folders (Test and Post)
Test will have Sheet2.xls and Sheet3.xls
Post will have Sheet1.xls
Hopefully this is clear enough..
many thanks <!-- / message --><!-- attachments -->
I have been trying to do a simple excel macro that would extract certain sheets from a workbook and save (values and page setup only) them separately into a defined folder.
Basically:
There will be a mapping sheet that contains a list of sheetnames. Next column there will be a simple letter to denote which folder it should go under.
Ex.
A1 Sheet1 B1 P
A2 Sheet3 B2 T
C1 Sheet1 D1 T
(T) = Test
(P) = Post
Result will be 2 folders (Test and Post)
Test will have Sheet2.xls and Sheet3.xls
Post will have Sheet1.xls
Hopefully this is clear enough..
many thanks <!-- / message --><!-- attachments -->
