Get from Table + Search in Google + Enter to a new column
Hello forum,
I am a newbie here and I need your help.
I am trying to reorganise our customer database and I need to do this:
I have at least 10000 customers in a column, I need to enter their name into Google Search and take the first search result websıte to a new column called WebSite.
How can I do that?
Thank you...
Hi, Not a lot of information to go on, however you can try this.
This script will take any name in col "I" Google it. and will return the link to the page in col "J"
I have also attached a workbook for ease of use. If you are going to use in another workbook you will need to set some Ref in vba editior before it will work. such as:
Microsoft Internet Controls
A test workbook is below. It takes several seconds for the data to populate and I have only about 6 names entered. So I imagine that 10000 names will take a bit of time.
I would suggest you copy your names to this test book and try to run the script.
Let me know how it works out.
,
Please Login or Register to view this content.
...,,
Thank You, Mike
Some Helpful Hints:
1. New members please read & follow the Forum Rules
2. Use Code Tags...Place[code]Before the first line and[/code] After the last line.
3. If you are pleased with a solution mark your post SOLVED.
4. Thank those who have help you by clicking the scales at the top right of the post.
Here...
Hello,
It works but can not find a website of the companies. I don't know why but I entered about 20 entries and it could only find 3 of them.
Is it normal?
You could try to run a couple of times. I did notice that when I put the script together that at times it did skip some names.Originally Posted by tahiryildiz
Can you list a few of the names it left blank. I Like to run some tests on your data. This scrpt only looks for ".com" maybe I could work on it when I get some time.
.
These are some of my entries:
ÇAĞDAŞ TIP GEREÇLERİ SAN VE TİC.LTD
İNTERDEKOR İLYAS ADUT
ÖNALANLAR YAPI MALZEMELERİ A.Ş.
ÖZDEMİR MAKİNE DIŞ TİC.MURAT ÖZDEMİ
ADORE OYUNCAK VE EĞT.ARÇ.SAN.TİC.A.
It commands to search but nothing happens, no entries...
Maybe my proxy doesn't let Excel to do this,but I don't guess so.
There should be a problem about something...
After Edit:
MY second try was this:
Fotokritik http://www.fotokritik.com/
Sigorta
Turkiye http://www.turkiye.com/
England
DAF http://www.daf.com/
Last edited by tahiryildiz; 05-13-2011 at 10:31 AM.
Hi
Its Nice program......
Last edited by markandan26; 08-18-2012 at 03:31 AM.
Hi Markandan,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. IF you create your own thread any advice will be tailored to your situation so you should include a description of what you've done and are trying to do, if you feel that this thread is particularly relevant to what you are trying to do by all means include a link to it
Ya Sure..But am new to this..
Last edited by markandan26; 08-20-2012 at 09:37 PM.
Markandan26,
You will get all the help you need. But for that, you need to create a new thread as per what Kyle explained.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi,
I don,t no How to create thread. please guide me
Thank U.........
Go to the Excel Programming / VBA / Macros Forum and click on the Post New Thread button near the top of the page at the left side. Make sure to give a clear and concise title to your thread and explain in detail what you want. Post a link to this thread if you think it would help to explain your need.
Thank U Dude..............
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks