Are web queries the only answer? There must be another way!

**VBA Beginner** · 01-30-2007, 11:37 AM

Hi all,

I was wondering if there is an alternative way to pull data from a web page into an excel file to make it workable other than web queries? The problem with web queries for me is that every morning when I refresh the data in the spreadsheet, sometimes the data I need are populated into slightly different cells, thus screwing up my formulas pretty badly. I need something that will consistently pull in the data into the same spot, if thats even possible.

Another solution I did think of was some kind of lookup formula because I do get all the data into the excel, just not in the same place. Any help or suggestions is muchly appreciated.

**MSP77079** · 01-30-2007, 11:43 PM

I was wondering if there is an alternative way to pull data from a web page into an excel file to make it workable other than web queries?

I do not know of another way.

Suggestion would be to build some logic in VBA to find the "starting point" after the query is run. Then, use VBA to re-write the formulas accordingly. If you can upload the workbook, would be happy to look at it (you don't need to upload the whole thing, just the part with the web query and a couple of the formulas).

Of course, if the web site you'll pulling from is protected, there isn't much I could do to test it. But, even in that case, if you could describe the sorts of ways the data might shift, I could do some rudimentary testing. In any case, it would give you some ideas of how you could tweak the code.

If the data is proprietary or private, just replace it with dummy data. The headers are what one would key off of, I would think. Not the data itself.

**VBA Beginner** · 01-31-2007, 03:05 PM

Hello,

I added the worksheet.. to refresh the data just click on the refresh tab. It is still in the testing state so it isn't quite done yet, but basically I have to pull the data from the websites ever morning. I can make a formula to get the High and C out so that isn't a problem, but sometimes when it refreshes it goes to the wrong formula. Thanks for your help.

Chris