In that folder in the command processor do dir > dir.txt.
Open dir.txt and copy the contents to a new column next to the SKU-column. Sort both columns the same way and compare, or use a vlookup-function to check. You might need a little bit of manipulation to get rid of ".doc".
Hope this helps.
I work with Excel sheets, where in one coloumn I have SKU (stock keeping unit) numbers. I have a folder with templates in it (a few hundreds), named by the SKU (these are Word docs) From the Excel sheet I have to check, if we have the certain SKU file in that folder, but I don't want to do it one by one, it would be very slow.
Is there an easier way to do it? I don't need to open those files, just to check if we have those files named by the SKU number.