Create "Folder and Directories" from Listed Directory name in excel

[Krishna Kinker Singh]

Hi I have Folder and Directory name in Excel Sheet,

I want to create Folder of all listed Directory name in hirerchy through VBA.

Like below, We have Three Columns in excel,

I want Result Output as Folder - ex.
a. In "Plant" Folder There are two folder 1.Engineering Management 2.Instrument
b.in Engineering Management - There are three folder 1.DB 2.DP 3.DG 4.SD 5.SF 6.SF ............so on

I want create folder from given below listed folder name by macro.
Can any one help on this.



Plant Engineering Management DB (Design Criteria or Design Basis)(0)
Plant Engineering Management DP (Design Procedure)(38)
Plant Engineering Management DP (Design Procedure)(38)
Plant Engineering Management DG (Design Guide)(0)
Plant Engineering Management SD (Standard Drawing & Detail)(0)
Plant Engineering Management SF (Standard Form)(0)
Plant Engineering Management SS (Standard Specification)(0)
Plant Instrument PB (Process Design Book)(0)
Plant Instrument DB (Design Criteria or Design Basis)(4)
Plant Instrument DB (Design Criteria or Design Basis)(4)
Plant Instrument DP (Design Procedure)(7)
Plant Instrument DP (Design Procedure)(7)
Plant Instrument DP (Design Procedure)(7)
Plant Instrument DP (Design Procedure)(7)
Plant Instrument DP (Design Procedure)(7)

 

[Ajesh]

Try this.

Macro File enclosed.

Thanks