Create New Folder Based on Cell Name and Copy Files into it

Hi All,

I am new in VBA.
I would like to create new folder based on cell value in a sheet (Sheet3 (Cover Page) Cell B4) and with this new folder, I would like to copy multiple documents from the list (Sheet 4 Cell B5:B30) from source folder into created folder. The document list is with extension (.pdf, .docx, etc). In addition, I also would like to prevent to create folder with same name.
At this moment, I can make new folder based on cell and also can copy document in the list, but don't know how combine this two things.
Any help would be appreciated.
Thanks in advance.

Please Login or Register  to view this content.

your first routine is fine. so what doesn't work in the 2nd one? you are using a const to store a range, then throwing it into an array. if that does indeed work, than you can just expand on it.
loop the array and use the fileCopy method and/or call DOS command called xCopy. the DOS cmd would need the appropriate switches though

Hi,
if you have same problem, I have already solved this. you can find it in this link

https://stackoverflow.com/questions/...86429#63886429

Have a good day