Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VLookup

Status
Not open for further replies.
kadara

kadara

Programmer
Mar 2, 2012
26
DE
Hi,
Is there any possibility to write a vlookup function in vbscript?
I would like to search values in excel worksheet and return a value in the same row.
 
Sort by date Sort by votes
What is "vlookup"?

If I'm properly assume what a "vlookup" is, you could open the file using an excel objects and search through it

Code: 
set objExcel = CreateObject("Excel.Application")
set objWorkbook = objExcel.Workbooks.Open("c:\file.xls")

intRow = 2
intCol = 1
do until (objExcel.cells(intRow, intCol).value = "")
    if (inStr(objExcel.Cells(intRow, intCol).Value, "myValue")) then
        msgbox "MyValue found in row" & intRow & " col" & intCol
    end if
    intRow = intRow + 1
loop

objExcel.Quit

-Geates

 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top