Dear all

I am trying to download a list of csv's. My Excel file is organized like this:
Number | Link
0 http://www.google.com/trends/trendsR...ent=1&export=1
....

I have tried the solution from this thread:
http://www.excelforum.com/excel-prog...22#post3123822

Adjusting the "test" code as
Sub test()

    Dim b As Boolean
    Dim URL As String
    
    URL = Range("b1").Value

Application.Wait Now + TimeValue("0:00:01")
    
    b = DownloadFile(URL, Application.ActiveWorkbook.Path & "\" & Range("a1").Value & ".csv", OverwriteKill, "BLUB")

End Sub
I get an error from Google: I get an htm file saying that "An error was encountered". I get the same error if I "click" on the link from Excel (and I am suddenly signed out of my account). If I copy and paste the cell content (aka the link): I get a download without an error.

Any suggestions, pretty please?