Tying an excel database together with a search engine

[DSNTNOENUF]

I have a large number of receivables in a spreadsheet that I am trying to locate. I can use relative reference to work down the spreadsheet one record at a time. Would anyone know how to take the active cell, populate a search engine, and auto-populate the name into it and conduct a search. This would greatly increase production in "skiptracing" these individuals.

Ex.

Database SEARCH ENGINE

TOMMY TEST WI "TOMMY TEST" WI [SEARCH]

Any assistance would be greatly appreciated.

Thanks,

 

[JoeMo]

Have you tried Excel's Find function (Home>Editing>Find & Select>Find)?

 

[Meggesto]

In my experience it usually takes a little troubleshooting to get this to work smoothly with each website as every webpage is different. This is a generic piece of code that may help you or get you started. It involved creating a ActiveX control button in your Developer Tools in Excel and linking this code to that button. It simply takes whichever cell is currently the active cell in Excel when the button is clicked and places it in Google's Search Engine and Clicks Search. You can adjust it for the website you're using by bringing up the Developer Tools in your browser and by Traversing the DOM to locate the Element ID, Class, Name or whichever tag you'll need to use to insert the name into the search engine.

Private Sub CommandButton1_Click()

Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

IE.Navigate "https://Google.Com"

While IE.Readystate <> 4
    DoEvents
Wend

    IE.Document.GetElementByID("lst-ib").Innertext = ActiveCell.Value
    IE.Document.forms(0).Submit
    
End Sub

You can manipulate the code as needed or if you can post the website you're using I may be able to adapt it for you.

 

[DSNTNOENUF]

You guys are amazing.

I can concatenate into a destination cell and get the values in the format I want, this will be so helpful.

Thank-you.