In my report document, I have macro to update all the OLE links to a new file. Now after it updates, I always need to go back to 4 links that are linking to graphs/charts in Excel and resize them. And those link codes look slightly different with the 'Chart number' included with the field code. A sample of one of those graphs/links in word looks like this:
Code:
{ LINK Excel.SheetMacroEnabled.12 C:\\Data\\AnyFileNameTest.xlsm "Receivable Charts![AnyFileNameTest.xlsm]Receivable Charts Chart 4" \p }
Now, I am thinking it may be possible to search the fieldcodes for the phrase 'Chart X' where X is the chart number. and if found, to resize the object height and width?