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
Edited to use the code tags ~ Von Pookie
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
Code:
<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>
Edited to use the code tags ~ Von Pookie