VBA Import from Web Pulls Search History (when I don't want it to!)

[ransomedbyfire]

I am trying to import a little bit of information from a website. This information is contained in a table along with a drop down box that lists every stock symbol I've ever searched for. (This list gets longer every time I run the query.) So, the import ends up pulling waaay too much information and causes the one piece of information I'm after to end up in a different cell every time.

How can I stop this import from pulling my search history?

Here is the code I am using.

    Sheet12.Range("d1").ClearContents

    With Sheet12.QueryTables.Add(Connection:= _
        "URL;http://research.tdameritrade.com/public/mutualfunds/profile/profile.asp?symbol=vfinx"_
        , Destination:=Sheet12.Range("d1"))
        .WebFormatting = xlWebFormattingNone
        .WebTables = """symbolHeaderTable"""
        .Refresh BackgroundQuery:=False
    End With

 

[CharlesH]

ransomedbyfire,

Hi, what info goes to different cells? Not knowing the full code you are working with I ran the bit you provided and it clears "D1" but the rest of the down load stayed the same, however it was probably copied over.

I'm not sure what you are referring too

How can I stop this import from pulling my search history?

 

[ransomedbyfire]

Charles, thanks for your reply; but I think I may have found an easy solution. It seems like if I set Internet Explorer to refuse all cookies from TDAmeritrade, it takes care of it.

 

[CharlesH]

Ok,

THanks for letting me know.