Problems with importing data

[gtg430i]

Hello - It has been a long time since I posted in this forum. I have had great help in the past.

Here is my issue:

I have an Excel/VBA file that imports historical data for stocks from Yahoo Finance. I used this file for few months and it was working with no issues.

I travelled overseas and the model stops working at all. It keeps giving me the following errors:

1 - Error 1004: The internet site reports that the item you requested could not be found.

2 - Error 1004: time allocated.....


I am very sure this the file itself is fine. This has to do maybe with the internet connection. Anyway id really appreciate if you can assist.

Here is the code:

Please Login or Register  to view this content.

[davesexcel]

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[AB33]

This thread has the same issue.

https://www.excelforum.com/excel-pro...ml#post4662915