I am building an script that searches multiple string in all files on a directory. It's working when my string doesn't contains spaces. If there's a space on that, the script seaches each word at a time (LOGICAL OR). Due to the amount of files, I can't open them as file text, so I call Excel...
you can check how to do it on WIndows Scripting guide, on
http://www.microsoft.com/technet/scriptcenter/scrguide/sas_ser_szxi.asp?frame=true
hope that helps
Guima1
Hi there.
I'm a network administrator and I have basic knowledge on vbs. I need to search into all Excel files in a folder, some words that are listed in a text file. My question is:
How can I do my script read ALL the content of an Excel file, without the need to export data to a text file...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.