Lengkap

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

Kemahiran: Excel, Visual Basic, Pengikisan Web

Lihat lagi: 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

Tentang Majikan:
( 6 ulasan ) Bremerton, United States

ID Projek: #18916332

Dianugerahkan kepada:

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 dalam 0 hari
(36 Ulasan)
5.0

2 pekerja bebas membida secara purata $23 untuk pekerjaan ini

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 dalam sehari
(1 Ulasan)
0.0