Hi MS forums,



I am hoping a VB wiz in the forum group can help me with my requirements. My teaching team will be using numbers for a new style of marking schema. To save errors in basic sums I wanted to use VBScript to auto generate cals. The preferred work flow for the teachers is to use Word and then transfer the overall dimensions (grades) to Excel.

I can get the code to calculate one table but hoping to see if someone can help me work out how to get multiple sums from multiple tables. In this case, transfer (to pp3) of two assessment dimensions and then an overall sum (pp3) of both, all without integrating Excel etc.

Thanks in advance if you can help, Brendan

Attached Files

CALCULATOR.docm (49.9 KB, 15 views)

This would be simpler to do if you replaced the input content controls with formfields and, instead of the calculation content controls, formula fields. No macros required. See attached.

Attached Files

CALCULATOR.docx (41.7 KB, 12 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for the feedback Paul, I ended up moving onto Acrobat using JavaScript and check-boxes, it works a treat. I can also easily constrain max/min sums etc and export to csv. Cheers