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