Word Document_ContentControlOnExit Macro to Update a Table

macropod · #1 04-15-2019, 01:38 AM

Quote:

Originally Posted by illwill

i uploaded here https://ufile.io/d85xfciu

Instead of directing users to files hosted elsewhere, please attach them to the actual post. You do so via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen. In this case, I've done that for you.

illwill · #2 04-15-2019, 02:14 AM

Quote:

Originally Posted by gmayor

See the attached which should do what you require, however using a repeating section content control to duplicate the table doesn't appear to produce the desired results, so I would suggest using a button either on the document (as in the attached) or on the ribbon to add tables as required.

The process recalculates the totals after each change so the totals should remain valid if the user changes a control.

awesome! the table update works well in your example,
only issue is 'critical' doesnt show in the chart for some reason not sure why
other times
if i copy/paste all of this into another doc and press the "add a Table" button, it pastes all the way at the end of document, is there any way to send it to a certain spot in the document? I have a tables of contents reference called 'Vulnerability Details' that the button should add under

also trying to figure out how to copy the button from your test doc properly, sometimes when i copy/paste it i get a reference errors
"the requested member of the collection does not exist" for : Set oCell = oTable.Cell(5, 2)
i need to move the chart and table to a different part of the doc than the table created

if i were to put the button in a ribbon how would i go about doing that? otherwise the button prints out on the page, or is there a way to prevent the button from printing

Quote:

Originally Posted by macropod

Instead of directing users to files hosted elsewhere, please attach them to the actual post. You do so via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen. In this case, I've done that for you.

thanks! sorry i missed that button

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word Macro to update the layout of document	joaoossilva	Word VBA	4	11-07-2016 01:11 PM
How can I use a Macro to automatically update all the pictures in a word doc	GezLundy	Word VBA	3	06-12-2014 03:23 AM
Document_ContentControlOnExit	Catty	Word VBA	2	11-29-2013 04:49 AM
Update Word table based on another table input	mpdsal	Word VBA	10	10-29-2012 07:40 AM
How do you update existing Outlook calendar item from Word with macro?	Joe Patrick	Word VBA	0	07-09-2011 05:32 AM