Is there a way to auto create windows explorer folders from an excel
spreadsheet? Like say we have a customer name list in the first column and
would like windows folders generated from that first column. TIA

Mike

Mike,
Yes and it's pretty easy to do. However it requires a macro.
If you are up to that then the following code creates a new
folder using text from the selected cell.
'--------
Sub CreateNewFolder()
'Prepare variables for use.
Dim strText As String
Dim strPath As String

'Get folder name from the selected cell.
strText = ActiveCell.Text

'User must enter the correct folder path below.
strPath = "C:\Documents and Settings\user\My Documents\Customer List\"

'Create the new folder using the path and folder name.
MkDir strPath & strText
End Sub
----------
Jim Cone
San Francisco, USA


http://www.realezsites.com/bus/primitivesoftware
"Mike"
<(E-Mail Removed)>
wrote in message
Is there a way to auto create windows explorer folders from an excel
spreadsheet? Like say we have a customer name list in the first column and
would like windows folders generated from that first column. TIA
Mike