Macro's & Equations

[Macro's and Equations]

I'm developing a word document with macro's in it that when opened in another
program; are pulling the value of those macros and placing them in the
document.

How do I create an equation that when opened in this other program allow for
the equation to be updated?

I've got my macro in a table, and the forumla is setup correctly, but does
not "update" when pulled to the othe program.

My Table is setup simiar to this:

Grand Total Down Payment
&DH_GrandTotal { = a2/a3 }
2

 

[macropod]

If the equation is using a formual field, as appears to be the case, then:
ActiveDocuemnt.Fields.Update
should do it. Note that this will also update any other fields in the body of the document so, if you have multiple equations,
you'll only need to execute that line once to update all of them.