Excel VBA creating folders in

Martin St. George 1

I am making a macro that creates a new folder/folders in a particular hierarchy. I keep getting hung on the path for my first folder. Here is what I have. How do I get this to work

kinuasa 371 Reputation points

2022-03-11T04:08:28.803+00:00
You may want to modify the folder path.

Path1 = "Z:\****\Projects Information\" & Range("C1").Value & "\" & Range("D3").Value
Martin St. George 1 Reputation point

2022-03-11T17:06:06.443+00:00

Thank you so much. It worked !!!!!!!!!!!!!!!!!!!!!!

Share via

Excel VBA creating folders in

Your answer