Our Company just upgraded to Office 2013, and as I continue to my learning of VBA and so on, I’m trying to learn the best way to achieve the following.
Currently, I have created a Word Template file that the end user will create a new document from. Within that template is approximately 70+ OLE links to an Excel File to pull various tables and charts. And I have a separate macro (thanks Macropod!) in the Word Startup folder to let the user change the OLE links to a different excel (Workpaper) file. And it all works fairly well so far.

Now, my ‘problem’ is that if the end user deletes a table or chart, they really don’t know how to add that chart back to the document. So my thought was to have some kind of drop down menu/list of the all of the charts where the user could insert the chart back into the document.

So my first thoughts are:

1. The ability to reference the Excel file in a Custom Field, and have a macro where the user could change that Field Code value to the current excel workpaper file.

2. Then have a listing of all tables and charts that would look at that file and be able to re-insert them into document where needed. I think maybe each chart would also need a separate custom field code, and could a) reference the field code made in item 1 above to get the current file path/name, and b) also reference the appropriate cells/named ranges for the table or chart?

I’ve just started reading on the use of Field Codes, Autotext, and Building blocks, and think the use of these may be a start in the right direction. But I’m not sure which of these is the best approach or if I’m even going in the right direction.

Any help/push in the right direction would be great. I can then hopefully begin reading some more and begin work on VBA code, etc as I learn.

Thanks


Paul