How to pull specific data from HTML?

E

eboudrot

Hi,

I have this email that gets sent to me on a daily basis that contains
attachments in HTML format. The problem is there is too much data that
I don't need within the HTML.

I eventually end up opening the HTML file in Excel and editing out the
rows I don't need. Any suggestions on how to do this automatically?
Either by preprocessing the HTML or creating a macro in excel that can
recognize the name of the file and preprocess before it opens? The File
name and the structure are constant.

So for example in the data below how would I prohibit "ADJ Net Sales"
from coming into excel? Any help will be much appreciated!!!

Thanks Ed

Example of the rows

Gross Sales $5,881.02
Net Sales $5,495.90
Adj Net Sales $5,636.88

Source file HTML

<td class="FieldLabel">Gross Sales</td><td>$5,881.02</td>
</tr>
<tr>
<td class="FieldLabel">Net Sales</td><td>$5,495.90 </td>
</tr>
<tr>
<td class="FieldLabel">Adj Net Sales</td><td>$5,636.88 </td>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IE Automation - checkbox 7
Pick data from web page (no query) 14
Creating multiple html tables for products 2
Fails then continues without error 6
Pasting HTML from IE into Word 2007 2
Making a table and automating it throughout cells 2
Product description tables easily 0
Product descriptions easily made? 0

Top