Just checking but i don't think the files are available until you have opened (downloaded) them, but here's a code to open to a specific folder:[VBA]Sub Get_Data()
ChDrive "C:\" 'change drive to suit
ChDir "C:\Documents and Settings\user\Local Settings\Temporary Internet Files\OLKBD" 'Change path to suit
FileToOpen = Application.GetOpenFilename _
(Title:="Please choose a file to Open", _
FileFilter:="Excel Files *.xls (*.xls),")
''
If FileToOpen = False Then
MsgBox "No file specified.", vbExclamation, "No Selection"
Exit Sub
Else
Workbooks.Open Filename:=FileToOpen
End If
End Sub[/VBA]