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