How to create folder based on the cell value

[ThrottleWorks]

Hi,

I have a excel file. I need to create a folder using a particular cell value.

For example value in cell A1 is ‘Chandoo is Awesome’. I need to create folder named as ‘Chandoo is Awesome’ and save the processed file in this folder.

Can anyone please me about how to create folder in VBA based on cell value.

 

[shrivallabha]

Example syntax for creating new folder:

MkDir "C:\Temp\" & Range("A1").Value

 

[ThrottleWorks]

Hi @shrivallabha thanks a lot. Wishing you (belated) happy independence day.

 

[shrivallabha]

Hi @shrivallabha thanks a lot. Wishing you (belated) happy independence day.

Thank you, Sachin. Wish you the same.