Macro to Create Folders and save the PDF Files

[hardeep.kanwar]

Dear Experts

I have thousands of PDF File ,each Client name have hundered of Files,Say 10000-Jaswant Motors-1,10000-Jaswant Motors-2,10000-Jaswant Motors-3

What i need to Macro create multiple Folders like 100000,100001,100003 and Paste the Files in particular Folders

PDF Files names are 10000-Jaswant Motors-1.pdf and First 5 Code are unique Codes.

Is it possible that Macro fetch the first 5 digit and create the Folder Name-10000 and paste all the Files related to 100000 into that Particular Folders

File Name

10000-Jaswant Motors

10001-Speedways

10003-S Goel & Goel

10004-N S Motors

10005-Kamal Enterprises

10006-R K Mahajan Enterprises

10007-K S Motorcycle Division

10008-Kalsi Motors

10009-B M Enterprises

10010-Duggal Automobiles

10011-Surya Motors

10012-Farid Service Station

 

[Yongle]

What i need to Macro create multiple Folders like 100000,100001,100003

Really ? Why 6 digits ?

Client codes are 5 digits :
10000-Jaswant Motors
10001-Speedways
10003-S Goel & Goel

I think the folders should be 10000,10001,10003

 

[Yongle]

Also ...

Will the new folders be subfolders of the current folder containing those files ?

 

[hardeep.kanwar]

Really ? Why 6 digits ?

Client codes are 5 digits :
10000-Jaswant Motors
10001-Speedways
10003-S Goel & Goel

I think the folders should be 10000,10001,10003

Thanks for the reply

It's a unique Code and always have 5 Digit code,sorry i have put 6 digit code

 

[hardeep.kanwar]

Also ...

Will the new folders be subfolders of the current folder containing those files ?

Current Folder name is Folder1,I want to create in New Folders in Current Folder each Folder name should be 10000-Jaswant Motors

 

[Yongle]

In post#1 you said create the Folder Name10000
In post#5 you said folder name should be 10000-Jaswant Motors (this is more difficult)

You said in post#1 that name of the files are 10000-Jaswant Motors- 1 , 10000-Jaswant Motors- 2
10000-Jaswant Motors- 1.jpg

Is EVERY file name like this ?
[ 1xxxx][Hyphen][Name of Company][Hyphen][Space][file number][.jpg]

It is VERY important that you do not tell me the wrong answer