Cable Forum - View Single Post - Excel VBA web query problem since new cable connection (text/numbers format problem)

sfnch · 21-01-2009, 20:10

I recently moved house from an adsl only area to a cabled area. I took the cable. Everything is running good... except..

Ever since the house move there has been a constant problem with running some VBA code in Excel that has been running OK for years in adsl...

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

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

etc, etc.

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'. The 'text', of course, is messing up the charts that result from the data.

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.

21-01-2009, 20:10	#1
sfnch Inactive Join Date: Jan 2009 Posts: 2	Excel VBA web query problem since new cable connection (text/numbers format problem) I recently moved house from an adsl only area to a cabled area. I took the cable. Everything is running good... except.. Ever since the house move there has been a constant problem with running some VBA code in Excel that has been running OK for years in adsl... ..downloading stock market data every 15 minutes from Yahoo via code that runs itself from 8am to 9pm without any user interaction.. .OnTime TimeValue("09:00:00"), "RunMacro" etc, etc. 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'. The 'text', of course, is messing up the charts that result from the data. 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.