Hello vba gurus, I have the VBA to launch IE, however am having an issue getting started on VBA for grabbing some specific data from a private website. I've searched a bunch of sites, and found some codes that are sort of remotely close, but usually looping through a table of same data, or it's just different enough to short circuit attempts. I have looked into definitions and am gaining some rudiment understanding, but you can probably smell the smoke from my brain after this week.
Anyhow I would appreciate any help with this. The html code for each item is listed below, if it was in a named item/class I included that. There's no bigger container item for the TD items (like a Div).
Here's the data that I need to pull in and put on a spreadsheet starting in A1. The items listed are in the order that they appear on the site with the text area box being at the bottom since it's big. There are page text items and there are field values needed.
Current Date: <div class='headerDetails'><b>Friday, May 10, 2019</b></div> Current User: <br>User:<span class='headerDetailsValues'> mememe </span> Item Status and ID#: <div class='reportTitle2' style='width=100%;overflow: auto;'> <span style='font-size:14px; font-weight:bold;padding-left:25px;float:left;'>ITEM Status: Pending</span> <span style='font-size:14px; font-weight:bold;padding-right:10px;padding-top:3px;float:right;white-space: nowrap;'>ITEM ID# 123456</span></div> Value of target Buy date: <td><input type='text' name='Target_Buy_Date' class='textfield_ro' readonly='readonly' value=05/21/2019></td> Value of Creator: <td><input type='text' name='creator' value="The Creator" class='textfield_RO' readonly='readonly'></td> Value of City: <td><input type='text' name='city' value="The City" class='textfield_ro' readonly='readonly'> Value of ZIP: <td><input type='text' name='zip' value="12345" class='textfield_ro' readonly='readonly'></td> Value of the Assigned #: <td style='font-weight:bold; line-height:90%'>Assigned #:</td> <td><input type='text' name='AssignedNumber' class="textfield" id='theAssignedNumber_ro' value=''1234567890" maxlength='15'></td> Value of the text area comments: <tr><td colspan='5'>Comments:</td></tr> <tr><td colspan='5'> <textarea name='comments' class='textarea100_ro' readonly='readonly'>Big bunch of comments --has any character free form text - </textarea></td></tr> </table>
Thanks for any assistance.