|Hello, I have folders with .xls invoices in them which look like: "LastName FirstName AmountOwed" and if a customer has paid I change the file name to "LastName FirstName AmountOwed PAID"|
What I would like to do is search for invoices that DO NOT have the word PAID in them. Is this possible with windows search? (the one thats built in)
I currently have:
Set objShell = CreateObject("Shell.Application")
Set objFolder = objShell.Namespace("C:\")
Set objFolderItem = objFolder.ParseName("Invoices\2010")
And this opens up a search query, which I can put a customers name in and search for them.
What can I add to this to search (or a whole new .vbs) for files that dont have the word paid in them?