Create Folder in Path mentioned in Cell

[Rahulwork]

Hello Everyone

I have a code to make new folder in path which is working as well.

Sub Button1_Click()

MkDir ("\\ABC\ragga\Desktop\Testing\Consolidated File")

End Sub

but i want that, path should be pick from the cell. Consolidated file would be folder name

i want this \\ABC\ragga\Desktop\Testing would be in C2 . i know it's possible but having some issue. please help

 

[Trevor G]

Will this work for you:

Sub MakeFolder()
Dim strFolder As String
strFolder = Range("C2").Value & "\Consolidated file"

MkDir strFolder

End Sub