Returning a formula from another table

[Jules]

I have 2 tables in a document. I have a macro that does a lot of adding,
subtracting etc. in each table. I want to set up a formula in a cell in
table 1 that returns the result of adding 2 cells from table 2, (eg total of
adding cells C5 and D5 from Table 2 to show in cell H6 of Table 1) . Is this
possible?

thank you

 

[macropod]

Hi Jules,

You can probably do all the maths with field coding. To see how to do this and how to reference cells in other tables using field
codes, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442
If you use such an approach, then the only code your macro would need to force a recalc is:
ActiveDocument.Fields.Update

Cheers

 

[Jules]

Thanks, I found what I needed in the article and it will be good for future
reference