Copy Strings from XML into Visio File

[ShailShin]

Hello Team,

I got an requirement to copy the strings from xml file [Basically a visio report xml file] in to Visio file. This XML file contains Displayed Text and StaticID based upon these two references I would like to copy the strings into Visio file. Can you please suggest any macro or .VBS or any other way to automate this process. Attached Sample XML file for your reference.

Thanks In Advance!
Shail

[Paul Herber]

Assuming you get the strings out from the XML, what do you want to do with them in Visio? They are only text strings.

[ShailShin]

Hello,

I would like to merge back the translated text into Visio file. The xml file contains the static id and strings based upon this ID's needs to merge back into the visio file by finding the static IDs.

Flow:
Find Static ID in Visio file
Search the same in XML file
Copy the strings and replace it in Viso file.

Thanks,
Shail

[aledlund]

What's your skill set? How good are you at working with XML? If you're doing it with VBA this is a place to start on the parsing.
http://msdn.microsoft.com/en-us/library/aa163921(v=office.10).aspx
I'd be doing it with .Net. For working with Visio in an XML format here's some beginners material (not for beginners, consider as intermediate or above).
http://xmlvisio.codeplex.com/

al

[ShailShin]

Thanks Will Try with this option.