Web Query jumps table upon refresh.. sometimes

[sidewayze40]

I am working to build a spreadsheet that will update retail pricing from

http://www.discounttire.com.

I create the web query get to the location I want and select the table that has the info I need, all is well. Then later I go to refresh it and the data is now pulling from a new table from the page? Is there a way to stop this? For example

http://www.discounttire.com/dtcs/ti...bmitProductSize.do?r=LAIINT|pc|92335&pc=18583

on this page i am only interested in the information... $92.00each
I select this table and later on a refresh I will get.... Average Customer Review... Please advise! Thank you in advance.

 

[sidewayze40]

BUMP!

 

[SkipVought]

Don't know why, but the link to DT times out and has for several days???

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[sidewayze40]

Hmmmmm... doesn't time out for me. I just clicked in now and it loaded quickly. If you are able to come back to this and have some time you can navigate to it

http://www.discounttire.com

select "by Brand"
Falken
then any line and any size inside that line

Again, all im interested in is the table with the price. Thank you very much for any help you can give.

 

[SkipVought]

I did not see any prices.

Here is my query...

Sub Macro2()
'
' Macro2 Macro
'

'
    With Sheets(1).QueryTables(1)
        .Connection = "URL;[URL unfurl="true"]http://www.discounttire.com/dtcs/tires/falken/home.do"[/URL]
        .WebSelectionType = xlSpecifiedTables
        .WebFormatting = xlWebFormattingNone[b]
        .WebTables = "11"[/b]
        .WebPreFormattedTextToColumns = True
        .WebConsecutiveDelimitersAsOne = True
        .WebSingleBlockTextImport = False
        .WebDisableDateRecognition = False
        .WebDisableRedirections = False
        .Refresh BackgroundQuery:=False
    End With
End Sub

One of the keys is the WebTables ID

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

It was probably our company security filtering, that I could not get a connection. I have one from home, as posted above.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[sidewayze40]

ok... i think we are getting closer with the "web tables" option. But i don't think i was good enough at describing how to get to the prices
from the URL in your query,

http://www.discounttire.com/dtcs/tires/falken/home.do,

you are now that page in which you must choose a tire line... you can choose "Falken FK452" from the Falken Passenger/Performance Tires section... from there your first time it will ask for a zipcode... i started with 92335... Now you get to a point where the page shows all the tire sizes they have available in the "Falken FK 452"...
Now you have to pick a size.. the first size is 205/50R16... Once you click on the size now you come to the price page...

I hope that describes it better.