Downloading a csv file from Google Trends

Hi,
I am writing a VBA for downloading a csv file from google trend.
In the first worksheet ,enter the search keyword in the excel file and the click a button to download the csv file and place it in another worksheet in the same excel file.
I have had some experience with downloading the stock stat. csv file from yahoo but then I realize this time is really a different story.In the google trend case, I cannot find a real URL of the csv file.

I strongly believe the solution is on
http://www.excelforum.com/excel-prog...ge-result.html
But I don't understand the solution provided by Kyle

I have tested the code in #1 .It runs but cannot return a proper csv file just like Lloyd said.
I do not understand what Kyle said. What do title and id refer to ?

Besides,I do not understand and cannot run the code in #6.
What is the input and ouput of this code?
When I run this, I face a Run- time error '-2147024891(80070005)'.

I am new in vba and sorry for my stupid questions.

would also be interestd in a solution, need to do excactly the same. Did you find a way to make it work colemanhk?

if someone esle stumbled over this, i got it to work with this java api.

https://github.com/elibus/j-google-t...ster/README.md