Comments:
I downloaded the mini app and saved it to my local drive.
I opened it up in Excel and entered several symbols and the historical prices updated without any problems. If you try to open the mini app in internet explorer it may not work. Make sure you save it locally and then open it with Excel.
I put the error message you are getting into the macro code if you are not able to connect to Yahoo's historical prices.
I suggest try setting up a web query in Excel to Yahoo's historical prices as described in the Willow Tip.
If you can set up a web query, I would rem out the line "On Error GoTo NoCanDo" in the macro code and step through the code to see where the error occurs.
Hope this helps.
|
