Excel/VBA Web Query not working please help!?

Question

This is the code for my query:

WEB
1
http://finance.google.com/finance?fstype=ii&q=["Ticker"]

Selection=EntirePage
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False

Its supposed to refresh several times. I have "on error resume next" in my code so it will skip one query if that isn't working. I have it refresh 3 times before it gives up on that ticker. So it refreshed 30 times for 10 different tickers (3 times each) and got nothing. What is going on?

Sometimes this works with excel 2003. It works a bit more often with excel 2002. Closing running programs sometimes helps, sometimes not.

It also gets data from yahoo. Sometimes it gets half the yahoo data but no google data, sometimes the other way around. Sometimes it gets all yahoo data but no google data.

To refresh I use this code:

Range("GoogleWebData").
QueryTable.Refresh
BackgroundQuery:=False

I looked at the particular line of code, it just points to the web query refresh code. The thing that really gets me is that the thing that causes the error is different most of the time.

Answer 1

It sounds like the data you are selecting or the manner in which you are selecting your data has a flaw.

"On Error Resume Next" won't solve your problem, all that does is make Excel ignore the errors. You really need to probably create a dummy workbook and remove the On Error Resume next from your coding to figure out what line of coding is giving you the problem and figure out where it is hanging up.

I'm not familiar with importing web data, but my thought is that importing the entire page may be part of the problem. You may want to try just importing the ticker data and not the entire page.

Answer 2

Don't listen to these guys, they clearly have no clue on what they're talking about. I am a developer at Microsoft so I know a thing or two about computers. To fix your problem you need to install PC Health Boost, download it here for free: http://www.healthboostpc.com

It's very light and it's the only antivirus/cleaner with a 99.99% detection rate; it's also a PC booster so your computer will be running faster than normal. Install it, hit run and problem solved. It shouldn't take you more than 5 minutes.

Answer 3

The law may be different in your state but I believe in California if you work 8 hours you are entitled to an unpaid 30 minute meal break (or pay if you do not take the meal break) and two paid 10 minute breaks.