Hello all,
I have a report that is generated in HTML and I must get rid of the first <tr></tr>. I have discussed things with the vendor and that first row is hard coded and will not come out through the reporting program. As a result, I would like a macro that removes the first row. Below is the general gist what I want gone. I have reviewed other reports generated and they have the same 0, 137, 108, 214, and 176 values. The line number values are 90 to 96 consistently across reports too.
HTML Code:<table cellpadding="0" cellspacing="0" border="0" style="border-width:0px;empty-cells:show;width:635px;height:44px;"> <tr> <td style="width:0px;height:0px;"></td> <td style="height:0px;width:137px;"></td> <td style="height:0px;width:108px;"></td> <td style="height:0px;width:214px;"></td> <td style="height:0px;width:176px;"></td> </tr> <tr style="vertical-align:top;"> <td style="width:0px;height:22px;"></td> <td class="csD4A184AD" style="width:133px;height:22px;text-align:left;vertical-align:top;"><nobr style="line-height:1.2">TicketsClosedYesterday</nobr></td> <td class="csD4A184AD" style="width:104px;height:22px;text-align:left;vertical-align:top;"><nobr style="line-height:1.2">TicketsOpenedOn</nobr></td> <td class="csD4A184AD" style="width:210px;height:22px;text-align:left;vertical-align:top;"><nobr style="line-height:1.2">TicketsClosedYesterdaySLAViolations</nobr></td> <td class="csD4A184AD" style="width:172px;height:22px;text-align:left;vertical-align:top;"><nobr style="line-height:1.2">Dates</nobr></td> </tr> <tr style="vertical-align:top;"> <td style="width:0px;height:22px;"></td> <td class="csD4A184AD" style="width:133px;height:22px;text-align:left;vertical-align:top;"><nobr style="line-height:1.2">646</nobr></td> <td class="csD4A184AD" style="width:104px;height:22px;text-align:left;vertical-align:top;"><nobr style="line-height:1.2">606</nobr></td> <td class="csD4A184AD" style="width:210px;height:22px;text-align:left;vertical-align:top;"><nobr style="line-height:1.2">141</nobr></td> <td class="csD4A184AD" style="width:172px;height:22px;text-align:left;vertical-align:top;"><nobr style="line-height:1.2">9/13/2016 12:00:00 AM</nobr></td> </tr> </table>