MkDir issue in VBA

[anichols]

Hello all,

I have a very simple VBA code, that I use to create a new folder.

MkDir "C:\Users\aan\Desktop\" & [A1]

I keep trying and failing to make both parts of this a cell reference. I need both the location and new file name to be changeable.

Thank you!

 

[Rick Rothstein]

Since you show your new folder name as being in cell A1, I'll assume your existing path is in cell B1. With that said, this worked for me...

MkDir [B1&A1]

Two points to note...

1) Your existing path must always end with a backslash character

2) You cannot create more than one folder at any one time as all folders leading up to the one you are creating must already exist beforehand.

 

[anichols]

Awesome! That was super simple. thank you!