Auto Serial number Generation and folder Creation

[Likith]

Hello ,

I am looking for a VBA program that creates a sequence of numbers with prefix "NLk" in Row A in the cell one after one Ex : NLk000001

After creating the above number , I would like Have a VBA that creates a folder in the system with that number ( Ex : D:\ Data\D Data\WORK\2019\January\NLK000001).

It would be great if VBA code creates the Folder on date wise (( Ex : D:\ Data\D Data\WORK\2019\01-Jan\NLK000001).

I am not sure is it possible , If yes please let me know .

I appreciate all your help on this

Regards ,
Likith