Button Macro for Caclulating in Word Tables

[Ned23]

Can anyone can point me to an example of a macro that you would assign to a
command button in Word 2007 that calculates a result based on values from
multiple cells in one table and puts that result in another cell in a
separate table?

I've been told that I cannot link Excel spreadsheets for this application;
it has to be stand-alone Word. So, I either have to do this in Word or not
do it.

Any help would be appreciated,
Thanks.

 

[macropod]

Hi Ned,

To see how to reference cells in another table in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled 'Reference Table Cells From Outside The Table'

To force a re-calc in the linked table, simply select the cell(s) concerned and press F9. Alternatively, you could insert a
MACROBUTTON field onto the linked table, coded as {MACROBUTTON CalcTable Update} and use the following macro:

Sub CalcTable()
Dim oFld As Field
For Each oFld In Selection.Tables(1).Range.Fields
oFld.Update
Next
End Sub

Note: The field brace pairs (ie '{ }') for the MACROBUTTON field are created via Ctrl-F9 - you can't simply type them or copy &
paste them from this message.

Similar macro code could be used for a command button.

 

[Ned23]

Thanks macropod. I've downloaded your file and am studying it and have
built a file with some macros in it and am fiddling around with it.

To anyone else out there, I'd like to say that I'm more of a visual
learner, so if anyone has an example of the process in action, I'd appreciate
it. By that I mean an example where someone actually has a Word 2007 file
with a couple of tables in it and a macro to go with it that calcualtes some
results when you press a command button. I think I could look at that and
very quickly adapt it to my forms.

Thanks,
Ned.

Hi Ned,

To see how to reference cells in another table in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled 'Reference Table Cells From Outside The Table'

To force a re-calc in the linked table, simply select the cell(s) concerned and press F9. Alternatively, you could insert a
MACROBUTTON field onto the linked table, coded as {MACROBUTTON CalcTable Update} and use the following macro:

Sub CalcTable()
Dim oFld As Field
For Each oFld In Selection.Tables(1).Range.Fields
oFld.Update
Next
End Sub

Note: The field brace pairs (ie '{ }') for the MACROBUTTON field are created via Ctrl-F9 - you can't simply type them or copy &
paste them from this message.

Similar macro code could be used for a command button.

--
Cheers
macropod
[MVP - Microsoft Word]

Can anyone can point me to an example of a macro that you would assign to a
command button in Word 2007 that calculates a result based on values from
multiple cells in one table and puts that result in another cell in a
separate table?

I've been told that I cannot link Excel spreadsheets for this application;
it has to be stand-alone Word. So, I either have to do this in Word or not
do it.

Any help would be appreciated,
Thanks.