Tying an excel database together with a search engine

DSNTNOENUF

New Member
Joined
Aug 3, 2015
Messages
32
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,
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,413
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Have you tried Excel's Find function (Home>Editing>Find & Select>Find)?
 

Meggesto

Board Regular
Joined
Mar 8, 2016
Messages
216
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.

Code:
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.
 
Last edited:

DSNTNOENUF

New Member
Joined
Aug 3, 2015
Messages
32
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,398
Messages
5,624,500
Members
416,031
Latest member
Omega67

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top