KennyJ
05-05-2009, 07:53 AM
I have a spreadsheet with part numbers in column A and descriptions of those parts in column C. What I would like to do is create a macro that will create Sub-Directories named with the part number then the description after it like this:
-Example Directory Name-
12345 (Part Description)
Inside of a directory called "TESTERS"
"12345" will be in Column A without ""
"Part Description" will be in Column C again no "" and will not have the () that I need added.
Is this something that can be done? Does anyone have a link to some code to get me started? or would it be faster to just create the directories 1 by 1 manually instead of trying to make a macro?
-Example Directory Name-
12345 (Part Description)
Inside of a directory called "TESTERS"
"12345" will be in Column A without ""
"Part Description" will be in Column C again no "" and will not have the () that I need added.
Is this something that can be done? Does anyone have a link to some code to get me started? or would it be faster to just create the directories 1 by 1 manually instead of trying to make a macro?