Does chart have records

[#1]

I have a chart the uses a set analysis to trap exceptions. I send this chart to excel and then email the excel file to a users to review the exceptions. This is all automated on reload. If the chart has no records (there are no exceptions today) I do not want to email an empty excel file. How do I determine if a chart has any records?

Thanks,

Stephen

[#2 · Accepted solution]

Figured it out. Using:

set obj = ActiveDocument.GetSheetObject("CH01")
set v = ActiveDocument.Variables("vCountRecords")
  v.SetContent  obj.GetRowCount,true

if v.GetContent.string = 2 then
msgbox ("Don't Send Email")
else
msgbox ("Send Email")
end if

The 2 record count represent the caption and the totals line in the straight table, so only if there are 3 or more records is the actual data in the table.

Stephen