Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-21-2015, 01:32 PM
ptmuldoon ptmuldoon is offline Updating/Format Objects Windows 7 64bit Updating/Format Objects Office 2013
Advanced Beginner
Updating/Format Objects
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating/Format Objects Can't add ActiveX Objects. MSOfficeGuy PowerPoint 5 12-14-2014 07:37 AM
Updating/Format Objects Format Painter doesn't work on Table Format? Joey Cheung Word Tables 1 08-20-2014 02:24 AM
Updating/Format Objects Convert equation objects to inline objects sumjoh Word VBA 1 01-29-2013 08:38 PM
Updating/Format Objects Shape Objects Space Cowboy PowerPoint 4 10-04-2010 07:14 PM
Updating excel link alters table format in PP dbmagnus PowerPoint 0 06-03-2010 12:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft