Completed

Fetch Data with VBA -- 2

From [url removed, login to view]" I want to fetch some data using VBA in Excel.

It takes me now 2.2 seconds to fetch this data. I need much faster code, ideally fetching in 0.1-0.2 seconds.

The data I need is highlighted in red in the image attached to this post.

Can you do it?

I tried with this code without success:

Sub RetrieveIt()

'Source: [url removed, login to view]

my_url = "[url removed, login to view]"

market=321&loan=150000&perc=20&prods=2&points=0"

Set IE = CreateObject("[url removed, login to view]")

With IE

.Visible = True

.Navigate my_url

.Top = 50

.Left = 530

.Height = 400

.Width = 400

End With

Do Until Not [url removed, login to view] And [url removed, login to view] = 4

DoEvents

Loop

my_rate = [url removed, login to view]("bg-quote")(1).getElementsByTagName("span")(0).innerText

'my_rate = [url removed, login to view]("br-col-2 br-apr")(1).getElementsByTagName("div")(0).innerText

End Sub

Skills: Excel VBA, XHTML

See more: excel vba get data from another workbook without opening, excel vba copy data from another workbook, get data from another workbook vba, how to read data from pivot table using vba, excel vba get cell value from another workbook without opening, excel vba get cell value from another worksheet, excel vba pivot table getdata, vba getpivotdata grand total, fetch data from website, fetch data from different websites, a web Page to fetch data from table, http www quikr com freelancers y276 adtype want, http www quikr com freelancers y276 ad_type want, data entry job from 2 days, fetch data site using curl php, perl login website fetch data, php fetch data website, fetch data excel sheet perl script, code extract view source data vba, odbc data vba excel

About the Employer:
( 15 reviews ) Basel, Switzerland

Project ID: #15129101

Awarded to:

PigtailXL

Hello Sr. Hope you read my proposal (also take a look into my Portfolio to know me). I'm an experienced web data extractor and I'd like to help you. Habilidades y experiencia relevante Experience building solutions li More

$15 USD in 1 day
(3 Reviews)
4.3

2 freelancers are bidding on average $23 for this job

$30 USD in 10 days
(2 Reviews)
1.9