Thread: [Solved] Updating/Format Objects
View Single Post
 
Old 01-21-2015, 01:32 PM
ptmuldoon ptmuldoon is offline Windows 7 64bit Office 2013
Advanced Beginner
 
Join Date: Sep 2014
Posts: 93
ptmuldoon is on a distinguished road
Default Updating/Format Objects

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?
Reply With Quote