nobleprince
New Member
- Joined
- Nov 12, 2013
- Messages
- 1
Hi,
The requirement is to capture the URL's from a search engine (e.g. Google, Bing or Yahoo, etc) and to insert the domain name into column H. The Macro should take the company name from the spreadsheet for example, Rockwell Collins, put Rockwell Collins into a search engine, and then do a search for the words "Rockwell Collins" AND .co.uk. OR .com within only the first page of the search engine. The matching result should then be put into the appropriate Column H within the spreadsheet.
If the company name within the search engine page is the same two or more times, then the returned domain name should be captured in the following order/preference:
.co.uk (first choice)
.com (second choice)
I have included a BEFORE and AFTER example for the expected output.
[TABLE="width: 341"]
<tbody>[TR]
[TD]BEFORE:
Senior Systems Engineer at Rockwell Collins
Core Infrastructure Engineer
at FactSet Research Systems
Network Installation Engineer at NG Bailey IT Services
Support Engineer at netConsult Ltd
Engineering Manager Land and Rail Systems
"senior systems engineer" at General Dynamics
Network Forensic Engineer at IBM
AFTER:
rockwellcollins.com
factset.com
ngbailey.co.uk
netconsulting.co.uk
generaldynamics.com
ibm.co.uk[/TD]
[/TR]
</tbody>[/TABLE]
Any questions, let me know.
The requirement is to capture the URL's from a search engine (e.g. Google, Bing or Yahoo, etc) and to insert the domain name into column H. The Macro should take the company name from the spreadsheet for example, Rockwell Collins, put Rockwell Collins into a search engine, and then do a search for the words "Rockwell Collins" AND .co.uk. OR .com within only the first page of the search engine. The matching result should then be put into the appropriate Column H within the spreadsheet.
If the company name within the search engine page is the same two or more times, then the returned domain name should be captured in the following order/preference:
.co.uk (first choice)
.com (second choice)
I have included a BEFORE and AFTER example for the expected output.
[TABLE="width: 341"]
<tbody>[TR]
[TD]BEFORE:
Senior Systems Engineer at Rockwell Collins
Core Infrastructure Engineer
at FactSet Research Systems
Network Installation Engineer at NG Bailey IT Services
Support Engineer at netConsult Ltd
Engineering Manager Land and Rail Systems
"senior systems engineer" at General Dynamics
Network Forensic Engineer at IBM
AFTER:
rockwellcollins.com
factset.com
ngbailey.co.uk
netconsulting.co.uk
generaldynamics.com
ibm.co.uk[/TD]
[/TR]
</tbody>[/TABLE]
Any questions, let me know.