I recently moved house from an adsl only area to a cabled area. I took the cable. Ever since the house move there has been a constant problem with running VBA code that has been running OK for years...

..downloading stock market data every 15 minutes from Yahoo via code that runs from 8am to 9pm without any user interaction..

.OnTime TimeValue("09:00:00"), "RunMacro"

etc, etc.

http://i44.tinypic.com/ztzn5y.png

You can see from the .png that sometimes the data is formatted OK as the required 'number' but sometimes is randomly formatting itself as 'text'. Not to worry, I found the perfect piece of code to instantly convert all highlighted 'text' numbers to 'numbers', but it's really bugging me.

Any ideas as to what is causing it? tia.

PS: If I go to the actual sheet that has the Query and refresh the query when it is in 'text' mode it usually reverts right back to 'numbers' immediately.