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
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