Hello:

I have lots of pdf file in C:\Scannedfiles folder with following name standard.

MM-DD-YYYY-StoreName-Category.pdf

Example
05-09-2020-Store1-Utilies_Gas
04-29-2020-Store9-Insurance_WC


I need VB Code to move all these files in their respective folder for each store.


C:\Store1\Utililies
C:\Store9\Insurance.

If folder does not exist then create one.

Please let me know if you have any questions.
Thanks.

Riz