Help with Importing CSV from Dynamic URL

[Mike_Poserina]

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/search/overviewReport?q=excel%20help&cmpt=q&content=1&export=2[/URL]
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 help&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. (Not Ideal)

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.