Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create multiple folders and name them by cells in a column excel vba
I have a workbook with student information. I want to grab each last
name to name folders where thier files can be stored. there are about 1000 names, some are repeats (ex adams, mike and adams, jeff). can this be done? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
create multiple folders and name them by cells in a column excel vba
sseyerle,
I would use full names, just for clarity - but, in any case, paste this code into a regular codemodule of a new workbook, save the workbook into the parent folder where you want all the new folders, select the cells with your desired folder names and run this macro. HTH, Bernie MS Excel MVP Sub MakeFolders() Dim myC As Range On Error GoTo FolderExists For Each myC In Selection MkDir ThisWorkbook.Path & "\" & myC.Value ResumeHe Next myC Exit Sub FolderExists: Resume ResumeHere End Sub "sseyerle" wrote in message ... I have a workbook with student information. I want to grab each last name to name folders where thier files can be stored. there are about 1000 names, some are repeats (ex adams, mike and adams, jeff). can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Multipe folders and naming them by Cells in Columns using vba | Excel Programming | |||
Can excel automatically create folders | Excel Discussion (Misc queries) | |||
Create folders from excel | Excel Programming | |||
Create Folders From Excel | Excel Programming | |||
how do I create multiple column width in the same column in excel | Excel Discussion (Misc queries) |