0

Hello,

I wanted to use visual basic macro in excel to pull search results from Google. Since I am not very familiar with how visually basic macro works in excel, I found the following code from a tutorial online.

Const GOOGLE_WEBSERVER = "www.google.com"

Function BuildSERPURL(ByVal term As String, ByVal start As Integer) As String
    BuildSERPURL = "http://" & GOOGLE_WEBSERVER & "/search?start=" & start & "&q=" & term
End Function

This code definitely works in excel, if and only if I'm running the macro in United States. When I tried to run this code from China, I am getting results from Google Hong Kong instead. Is there a way to stop the redirection, so that when I am using this macro in China, I'll be still getting search result from United States stored in the excel file.

I know this question is kind of out of nowhere, but your help is really appreciated.

2
Contributors
1
Reply
2
Views
6 Years
Discussion Span
Last Post by Joris Claassen
0

Google results depend allways on the country from which you are searching/querying (logged in at internet). If you really need the US results you have to use an intermediate US computer which acts as a server to your Excel and as a client to google.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.