run time error 1004 excel cannot access file

[merlin777]

I'm running a workbook which uses VBA.

It uses the yahoo finance data lookup function and it usually works fine but its started to report this error:

"run time error 1004 excel cannot access file"

This is the line in the VBA that the debugger highlights when I run it.

Application.Workbooks.Open ("http://download.finance.yahoo.com/d/quotes.csv?s=" & Tickers & "&f=" & Codes)

I can only think that for some reason the yahoo function isn't working at the moment.

Any thoughts?

 

[Kenneth Hobson]

Use Debug.Print to see the results after a Run in the Immediate Window (Ctrl+G).

Sub Test()
  Dim s$, Tickers$, Codes$
  'Tickers=?
  'Codes=?
  s = "http://download.finance.yahoo.com/d/quotes.csv?s=" & Tickers & "&f=" & Codes
  Debug.Print s
  Workbooks.Open s
End Sub

 

[merlin777]

Use Debug.Print to see the results after a Run in the Immediate Window (Ctrl+G).

Sub Test()
  Dim s$, Tickers$, Codes$
  'Tickers=?
  'Codes=?
  s = "http://download.finance.yahoo.com/d/quotes.csv?s=" & Tickers & "&f=" & Codes
  Debug.Print s
  Workbooks.Open s
End Sub

I copied your code and pasted it after my own code and then entered Call Test in my main code. I tried it before the suspect line and after but nothing is being displayed except the error when the VBA is run. Should I be doing something else?

 

[Kenneth Hobson]

Copy and paste the Immediate Window results into your browser. If it works, then you know that the string was built properly.

Did you remove the ()'s in your Workbooks.Open? Debug menu's Compile will usually show if ()'s or not is a problem.

 

[merlin777]

Copy and paste the Immediate Window results into your browser. If it works, then you know that the string was built properly.

Did you remove the ()'s in your Workbooks.Open? Debug menu's Compile will usually show if ()'s or not is a problem.

seems to be built OK which makes sense as it was working fine until it spontaneously stopped earlier today.

I just read somewhere that the yahoo finance API is down so this might well be my problem.

 

[silicon_beaver]

Did search, return is , , ,

[h=3]Looks like Yahoo Download API is now Dead - 11/1/2017 | Elite Trader[/h]<cite class="_Rm bc">https://www.elitetrader.com › Forums › Tools of the Trade › Data Sets and Feeds</cite>




Since Yahoo terminated their API back in the May/June time frame, I was still able to get web-based data to download into EXCEL from a query

 

[merlin777]

Same here. It was only certain aspects of it that disappeared. ... the historical data I think.