VBA help! on Copying values from wkbook from internet

[Alpacino]

Hi,

At the moment I am using this code to copy values

Sub Copy()
Windows("ALAN1.xls").Activate
Sheets("Summary").Select
Range("J77:J102").Copy Destination:=Sheet1.Range("C7")
Application.CutCopyMode = False
Windows("ALAN1.xls").Activate
Sheet1.Select
End Sub

How do I change this so I can do the same for the same name on the internet ??
Because when I try to do this now I get an error message as excel does not recognise the file.

Thanks in advance
Alan

 

[Alpacino]

Amy ideas peeps??