Scriptbox - Find your Script, VBScript VBScripts VB-Script VB-Scripts Scripting

Loading

:: { Category } ::

0-9


	Search Options: Compare a List of Names in One Excel Column to a List of Names in Another Column Content of Compare a List of Names in One Excel Column to a List of Names in Another Column.vbs MD5 Hash: 68BF79BC08D79BBD47FF7E70A9E14827
	Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True Set objWorkbook = objExcel.Workbooks.Open("C:\Scripts\Test.xls") Set objWorksheet = objWorkbook.Worksheets(1) Set objRange = objWorksheet.Range("B1").EntireColumn i = 1 Do Until objExcel.Cells(i, 1).Value = "" strName = objExcel.Cells(i, 1).Value Set objSearch = objRange.Find(strName) If objSearch Is Nothing Then Wscript.Echo strName & " was not found." Else Wscript.Echo strName & " was found." End If i = i + 1 Loop

© 2008 - 2013 Boris Toll :: Scripts available: 6.481 :: :: scriptbox.toll.at :: :: powered by www.toll.at ::