Fetch Data with VBA -- 2

$15 USD

Completed

Posted

over 6 years ago

$15 USD

Paid on delivery

From [login to view URL]" 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: [login to view URL] my_url = "[login to view URL]" market=321&loan=150000&perc=20&prods=2&points=0" Set IE = CreateObject("[login to view URL]") With IE .Visible = True .Navigate my_url .Top = 50 .Left = 530 .Height = 400 .Width = 400 End With Do Until Not [login to view URL] And [login to view URL] = 4 DoEvents Loop my_rate = [login to view URL]("bg-quote")(1).getElementsByTagName("span")(0).innerText 'my_rate = [login to view URL]("br-col-2 br-apr")(1).getElementsByTagName("div")(0).innerText End Sub

Excel VBA

XHTML

Project ID: 15129101

About the project

2 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

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 like: Windows Desktop Apps Scrapers Apps Scrape Services Automation Programs/Bots Web Apps/Systems Tools used: PHP, .NET, WinAutomation, Excel (VBA). Htos propuestos $15 USD - Job done. May using "[login to view URL]" Msg. me.

$15 USD in 1 day