This content has been marked as final. Show 2 replies
I have several straight charts that have total fields - I have a macro that will read and sum the totals from each chart upon a variable change. This works fine locally, but not when the document is published. The macro is below - the document macro security is set to allow system access - I have other macros that are running fine. Are any of the actions in the macro restricted by the publisher? Are users unable to write to variables?
Thanks in advance.
for i=0 to UBound(sheetObj)
set obj= ActiveDocument.GetSheetObject(sheetObj(i))
rowCount = obj.GetRowCount-1
colCount = obj.GetColumnCount-1
cellVar = cellVar + CDbl(ActiveDocument.GetSheetObject(sheetObj(i)).GetCell(rowCount,colCount).text)
ActiveDocument.Variables("vVarTotal").SetContent cellVar, True