Hello,
You can add the following code (some code gleaned from google searches) to the post processing tab within your Excel report and it should strip out all of the unwanted html tags:
Sub QC_PostProcessing()
Dim MainWorksheet As Worksheet
' Make sure your worksheet name matches!
Set MainWorksheet = ActiveWorkbook.Worksheets(''Query1'')
Dim DataRange As Range
Set DataRange = MainWorksheet.UsedRange
' Now that you have the data in DataRange you can process it.
Dim r As Range
Set r = Cells.Find(''*'', SearchOrder:=xlByRows, SearchDirection:=xlPrevious)
If Not r Is Nothing Then
Range(Cells(1, 1), r).Select
End If
Selection.NumberFormat = ''@'' 'set cells to text numberformat
With CreateObject(''vbscript.regexp'')
.Pattern = ''<.*?>''
.Global = True
For Each r In Selection
r.Value = .Replace(r.Value, '''')
Next r
End With
End Sub
Hope this helps,
Dan