First, I'm using MS Office 2010 (both Word & Excel)
I have excel embedded objects in a word document and I'm trying to find a way to write some VBA to update the source links to all embedded objects. Currently if the file moves the link breaks and I need coworkers to be able to create copies of the templates and link them together. I've scoured google but nothing I'm coming across works. Presently I have to right click the OLE Object, select "Macro-enabled worksheet object", select links, and then change the source one by one. With over a dozen objects this is extremely cumbersome. Any help would be great. Please let me know if you need additional information or sample docs.