how to check strings in Excel files using vbscript?

[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?

Some files have many sheets and i need to checks all cells in all sheets against the word list.

Any help will be welcome

tks

 

[PHV]

If you know how to do that job in VBA, you can do almost the same things in WSH via OLE automation.

Set X = WScript.CreateObject("Excel.Application")

And then you manage the X object as the excel application object.

Hope This Help
PH.