Search Through Excel Sheet Using VBScript
Posted on 2002-04-16
Hello Experts. I have the following question:
I have a list of about 300 folders in Excel spreadsheet. When I go to that directory, there are actually 550 folders in the directory. I need to compare the folders in the directory with those in Excel sheet to determine which folders are extra. I am fairly confident with VBScript, but I don't know what properties (or objects) the Excel.Application has and how to use them.
In Excel file I have three sheets each with a listing of files that are in a specific directory. I don't know how to go to a specific sheet to do the search. Can anyone help?