If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Button Macro for Caclulating in Word Tables
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. |
#2
|
|||
|
|||
Button Macro for Caclulating in Word Tables
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/show...?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] "Ned23" wrote in message ... 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. |
#3
|
|||
|
|||
Button Macro for Caclulating in Word Tables
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. "macropod" wrote: 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/show...?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] "Ned23" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|