Importing a CSV Generated from a Dynamic URL

Hello,
I've used it as a resource as much as I could, but I've hit a wall. I was hoping someone can point me in the right direction.

I've found one solution so far, but I know there has to be a better one.

I need to import a CSV file which is generated from this address:
Example:
http://www.google.com/insights/searc...ent=1&export=2

I'm currently using code along the lines of:

Set browser = CreateObject("InternetExplorer.Application")
browser.Navigate ("http://www.google.com/insights/search/overviewReport?q=excel%20help&cmpt=q&content=1&export=2")
SendKeys "{LEFT}"
SendKeys "{LEFT}"
SendKeys "{ENTER}"

But..
(a) It opens a new tab in IE7
(b) It assums control of the 'File Download' window to open the file.

I have also tried:

  Workbooks.Open Filename:="http://www.google.com/insights/search/overviewReport?q=excel%20help&cmpt=q&content=1&export=2"

But the file name is not in the URL and thus can not open it.

Does anyone have an idea on how to solve this problem or a prior post they can direct me to?

Thanks a bunch.