Hi
First time poster and novice when it comes to Macro writing here so
please be gentle!... :)
What I need to do is as follows;
I have a workbook with 3 sheets, titled; "Prod" , "Die" , "Job"
Based on a value in a cell in "Prod"; eg A1: "P2380"I need to do the
following.
1. Create a new folder in a predetermined location named after the cell
value.
2. Split the workbook into 3 separate files in this new folder using
the naming convention CellValue_SheetName.xls;
-e.g.
P2380_Prod.xls
P2380_Die.xls
P2380_Job.xls-.
3. Close and Delete the original file.
I'm going to have a go at it, but my knowledge of
VB is very
limited.....
thanks for any help you can give
Kev
--
kevinho
------------------------------------------------------------------------
kevinho's Profile:
http://www.excelforum.com/member.php...o&userid=24984
View this thread:
http://www.excelforum.com/showthread...hreadid=385171