Đã hoàn thành

Chrome scraping from Excel VBA

Hello, I am using Excel/VBA Office 2016. I used to be a VB coder... but years ago, so need a fast routine made. I want a working example of scraping of the following page: [login to view URL]

The following HTML are the sections I wish to capture, it would be the widget

<div class="ttl">

<div class="agency-header-w"><div class="agency-logo"><img src="/utils/view?id=ffbdcf4629ffa83a4156086c02eb4ccb&inline_disposition=1"

border="0" alt="DLA Acquisition Locations logo"></div><div class="agency-header"><h2>COAX STRIPPER </h2><div class="sol

num">

Solicitation Number: SPMYM219Q1093</div><div class="agency-name">Agency: Defense Logistics Agency<br>Office: DLA Acquisition

Locations<br>Location: DLA Land and Maritime</div></div></div>

</div>

-----------------------------------------------

<div id="ptls-w">

<ul id="ptls">

<li><a href="?s=opportunity&mode=form&id=a84f9d889c12cbf0db0d4497653368a7&tab=core&tabmode=list&print_preview=1" class="print"

target="print">Print</a></li> <li><a href="[login to view URL]" class="bkmrk

permalink">Link</a><div id="permalink_instr" class="acc_hide"><div class="hd">Copy or Bookmark this Page</div><div class="bd"><p><label

for="permalink_field">Copy the url below for a direct link to this page.</label><br><input type="text"

value="[login to view URL]" id="permalink_field" style="width:460px"></p><p style="line

height:

normal">Bookmark this page by right-clicking <b><a href="[login to view URL]"

style="color:#00f">here</a></b> and choosing "Add Link to Bookmarks"</p></div></div></li> </ul>

</div>

------------------

<div id="so_formfield_dnf_class_values_procurement_notice__procurement_type_" class="field first field-first default_field_tmpl

fld_procurement_type fld-ro">

<div class="label" id="dnf_class_values_procurement_notice__procurement_type__field-label">

Notice Type: </div>

<div class="widget" id="dnf_class_values_procurement_notice__procurement_type__widget">

Presolicitation

</div><!-- widget -->

</div>

<div id="so_formfield_dnf_class_values_procurement_notice__posted_date_" class="field default_field_tmpl fld_posted_date fld-ro">

<div class="label" id="dnf_class_values_procurement_notice__posted_date__field-label">

Posted Date: </div>

<div class="widget" id="dnf_class_values_procurement_notice__posted_date__widget">

February 20, 2019

</div><!-- widget -->

</div>

----------------------------------

So I want working code using selenium for the Chrome Browser. Please capture the items in the above code sections, one data per cell in sheet2 of an excel spreedsheet. Also want it all in VBA.

Thank you,

Jim Hartley

Kĩ năng: Excel, Visual Basic, Web Scraping

Xem nhiều hơn: excel vba chrome automation, excel vba web scraping in chrome, excel vba chromedriver, how to open google chrome using excel macro, web scraping selenium vba, extract data from website to excel vba, vba web scraping chrome, embed chrome browser in excel, web scraping using excel vba, excel vba increment value, excel vba original width picture, find repeat value column excel vba, excel vba csv number cell formatted text, excel vba sum based value column, excel vba rank value, web scraping excel vba, excel vba paste value internet explorer, change value text input field javascript, excel vba find value list, excel vba show records value

Về Bên Thuê:
( 6 nhận xét ) Bremerton, United States

ID dự án: #18916332

Được trao cho:

ilkecokay

Hello. I am frequently doing selenium jobs with VBA and i can help you with this very quickly. Message if interested. Thanks.

$30 USD trong 0 ngày
(36 Đánh Giá)
5.0

2 freelancer đang chào giá trung bình $23 cho công việc này

sivarnaren

HI I am new to this one..I don't know vba..But I know excel and web searching copy and paste....Can I eligible for that?

$15 USD trong 1 ngày
(1 Nhận xét)
0.0