View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lazzaroni Lazzaroni is offline
external usenet poster
 
Posts: 55
Default Open URL For Input

Anyone know a way to use Open For Input on a file from the Internet?

Dim oURL As String
oURL = "http://finance.yahoo.com/d/quotes.csv?s=JPYUSD=X&f=sl1d1t1&e=.csv"
Open oURL For Input As #1

That returns error "Bad file name or number."

Thanks for your help.