New sub-folder in Excel using a formula
 

I would like to read a cell value then create a Windows folder using the
value in the cell as the folder name

New sub-folder in Excel using a formula
 

In an arbitrary cell, enter:

C:\brian
and Select that cell. Then run:

Sub stitute()
v = Selection.Value
MkDir v
End Sub

--
Gary''s Student - gsnu200742


"Brian Connolly" wrote:

I would like to read a cell value then create a Windows folder using the
value in the cell as the folder name