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,
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Have you tried Excel's Find function (Home>Editing>Find & Select>Find)?
 
Upvote 0
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:
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,506
Messages
6,114,027
Members
448,543
Latest member
MartinLarkin

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
Back
Top