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.