Excel VBA File Management

[camle]

I been looking for a way to do File Managing VBA and been unsuccessful.

I would like it to do the following:

1. Read a folder including subfolders on a network drive
2. Compare those filename to a database in excel

filename format = Name ####-##-## Name.ts or Name ####-##-##_# Name.ts

3.if there is a match, delete the file from the folder

I would Appreciate the help,

Thanks

 

[camle]

To the upper Brass, Sorry bout that. Won't happen again!

 

[camle]

OK finally able to get this file naming to take out the spaces.

So the latest file recorded is "Property Brothers-2014-06-21-Samira & Shawn.ts"

If "Samira & Shawn" is in the database then delete
"Property Brothers-2014-06-21-Samira & Shawn.ts"
In the database it is renamed to "Property Brothers 3x06 Samira & Shawn" so that it matched the TVDB website.

The "####-##-##" as stated before is the data that it was recorded.

Confusing?

 

[camle]

Did I lose my connection?

 

[camle]

Ok, Mr. Rothstein, Sorry that I lost you. I didn't mean any harm, I do thank you for your help.

I guess we can consider this tread closed

Thanks