We have a bunch of Word 2003 documents that have images "linked" in from Visio 2003 files, all on Windows XP systems. There are two problems with that:
- Sometimes the links become randomly corrupted (Word stores the link paths as absolute but somehow the link mostly gets preserved when the files are copied to a different computer).
- We may need to rename all the documents, including the Visio files, in the near future.
Since the linked images are just LINK fields, I created a VBA script that updates the fields' codes with the correct file name and updates the links. It works...unless the drawing name contains a forward slash or sometimes a space (at other times it works if there is a space). If there is a forward slash, I get "Error! Cannot update link." instead of the desired image.
I went to plan B -- getting VBA to emulate the manual process of inserting the linked image by opening Visio, copying the image and doing Paste Special in the desired Location in Word. It tells me the "data type is not available".
Does anyone know how I might overcome either of the abovementioned obstacles? Any help would be greatly appreciated.
Thank y'all so much for your time,
Ria.