I have a VBA Macro as shown below in an empty spread sheet. This works fine in Excel 2003, but in Excel 2010 it hangs with the message "Contacting the server for information".

The file exists - try pasting the URL into a browser and Excel starts - it just doesn't work in a macro under Excel 2010.

Sub Macro1()
'
' Macro1 Macro
'
'
Workbooks.Open Filename:= _
"http://www.google.co.uk/finance/historical?q=LON%3AAAL&safe=images&output=csv"

End Sub

I've tried changing trust settings along with other options, but to no avail. Anyone have any ideas?