How to export formula with Set analysis using macro

[Anonymous]

I need to export the value of this formula in an excel . Formula contains set analysis.

When I try to export formula it doesn't recognize the set analysis..can anybody please help?

testresult = activedocument.Evaluate("num(only({<Last8WeeksReferencedateOpened = {"$(=max(Last8WeeksReferencedateOpened))"}>}Aggr($(vAging_Incidents_weekly),Last8WeeksReferencedateOpened)),'#0.00')")

msgbox testresult

[Frank_Hartmann · Accepted solution]

1. create a variable e.g vTest

=num(only({<Last8WeeksReferencedateOpened = {"$(=max(Last8WeeksReferencedateOpened))"}>}Aggr($(vAging_Incidents_weekly),Last8WeeksReferencedateOpened)),'#0.00')

2. Change Macro to:

sub test

testresult = activedocument.Evaluate("vTest")

msgbox(testresult)

end sub

[Anonymous]

I used the following

set testresult = ActiveDocument.Variables("vAging_WeeklyReport_LastWeek")

testresult= testresult.getcontent.string

testresult = activedocument.evaluate(testresult)