Search results

Yes! Changing the obj definition solves the issue, thank you. Thank you very much for your help with this. Regards, Phil.

Hi, I just tried your code on a windows 10 pc and it works, I have windows 7, any ideas how to fix this? I tried a few supposed patches from a google search but did not fix the issue. Thanks.

Hi, Yes i know the search string needed tweaking but my bigger issue now is the error i get, your provided code still gives me the same error, i dont understand why? I can connect to random other urls ok via vba What could effect this? Run-time error '-2147012866 (80072efe)': The connection...

Hi, I am not sure whats going on now..? Now I'm getting a Connection Terminated Abnormally Error on any url i try? I would rather not post the address of the site i was originally wanting to scrape so am using a test site which has the same structure, if I can get this working I can adapt the...

Length is 16337

Hi, Still get same error... I just tried testing on chandoo too and also same error so I dont think its related to page content. url = "https://chandoo.org/forum/threads/extract-product-price-from-a-url-in-excel-vb.39758/#post-237970"

Hi, How can I determine the length ? Using Dim source As String * 1024, I get Invalid Procedure or Call on: output = Mid(source, findFirst + Len(searchstring), findSecond - (findFirst + Len(searchstring))) ' extract number as string

Hi Stevie, Thanks for your code, however when I run it I get an overflow error on findFirst = InStr(1, source, searchstring, vbTextCompare)

Hi, I am new to web scraping with Excel, I want to extract the product price to a variable from a url, the snippet of relevant HTML is below, the line <span class="price">$120.95 AUD</span> is the value I want to extract but I cant get my coding right to pick it up, what is the best way to do...