I don't know of any existing programs that will do this for you. However, you can create a macro to do this yourself. Just follow the steps below. This was tested briefly in Excel 2003 & seems to work.
1) Go to Tools > Macro > Record New Macro 2) Name it 'CreateFolders' & click OK 3) Click the little square to 'stop recording' 4) Go to Tools > Macro > Macros... 5) Select the 'CreateFolders' macro & click 'Edit' (will open a new Editor window) 6) Replace the existing text with the text below, so it now looks like this:
Sub CreateFolders() Dim outputFolder As String outputFolder = "C:\newFolders" MkDir (outputFolder) For Each cell In Selection Dim path As String path = outputFolder & "\" & cell.Value Application.StatusBar = "Creating folder '" & path & "'" MkDir (path) Next Application.StatusBar = "Finished creating folders in '" & outputFolder & "'." End Sub
7) Click the disk icon to save, then close the editor window. 8) Select the cells you want to make into folders i.e. the list of customer names. 9) Go to Tools > Macro > Macros... 10) Select the 'CreateFolders' macro & click 'Run'
If all is well, your new folders should have been created here: C:\newFolders. All that remains is to move them to wherever you really want them.
Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly
to your computer or smartphone by using a feed reader.
