Does this [http://www.rondebruin.nl/Google.htm] help?

<div>
I downloaded, installed, and tried out that program but I'm unsure on how to go about doing it. &nbsp;Basically what I'm looking for is an automated way to download information into a spreadsheet from a Google search (business name, address, etc). &nbsp;Is that possible?
</div>


I downloaded, installed, and tried out that program but I'm unsure on how to go about doing it.  Basically what I'm looking for is an automated way to download information into a spreadsheet from a Google search (business name, address, etc).  Is that possible?

<div>
This will get you started. It's a macro that will do a Google search based on what is in the active cell. I believe I've seen other threads that talk about downloading the results.<br />
<br />

<pre><code id="code-20-38150469-1">Sub GoogleSearch()
Dim newsite As Object

Set newsite = CreateObject(&quot;InternetExplorer.application&quot;)
newsite.Visible = True
newsite.Navigate &quot;http://www.google.com/search?hl=en&amp;ie=UTF-8&amp;q=&quot; &amp; ActiveCell.Text
End Sub</code></pre>
</div>


This will get you started. It's a macro that will do a Google search based on what is in the active cell. I believe I've seen other threads that talk about downloading the results.



Sub GoogleSearch()
Dim newsite As Object

Set newsite = CreateObject("InternetExplorer.application")
newsite.Visible = True
newsite.Navigate "http://www.google.com/search?hl=en&ie=UTF-8&q=" & ActiveCell.Text
End Sub

<div>
<a href="http://www.softpedia.com/get/Internet/Other-Internet-Related/Excel-Import-Multiple-Google-Search-Results-Software.shtml" rel="ugc">This</a> seems to be free.
</div>


This [http://www.softpedia.com/get/Internet/Other-Internet-Related/Excel-Import-Multiple-Google-Search-Results-Software.shtml] seems to be free.

<div>
That software will just get the title of the page, the description, and the URL. &nbsp;What I would like is the name of the business, the address, the manager, etc. &nbsp;It's what's shown in a Google Places search.
</div>


That software will just get the title of the page, the description, and the URL.  What I would like is the name of the business, the address, the manager, etc.  It's what's shown in a Google Places search.

<div>
<div class="content wysiwyg-content">
Can I program Excel to download information from my browser when doing a Google search? &nbsp;For example, I want to download the results of Google Places. &nbsp;I heard that I can use macros to accomplish this but wanted to hear your take.
</div>
</div>


Can I program Excel to download information from my browser when doing a Google search?  For example, I want to download the results of Google Places.  I heard that I can use macros to accomplish this but wanted to hear your take.

Can I program Excel to download information from Google?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.

Web Development

A Web service is a method of communication between two electronic devices over a network. It is a software function provided at a network address over the Web with the service always on as in the concept of utility computing. A web service has an interface described in Web Services Description Language (WSDL). Other systems interact with the Web service in a manner prescribed by its description using SOAP (Simple Object Access Protocol) messages. There are two major classes of Web services: REST-compliant web services, and Arbitrary web services.