HTML to Excel while eliminating specific data or rows?

eboudrot

New Member
Joined
Jan 15, 2004
Messages
1
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

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
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,066
Messages
5,857,118
Members
431,857
Latest member
garyjames8

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top