troubleshooting Question

Bulk adding Shape Data to all connectors in Visio to export screen tips to excel

Avatar of Jonathan Roberts
Jonathan Roberts asked on
Office ProductivityMicrosoft Visio
2 Comments1 Solution328 ViewsLast Modified:
I am trying to find a Macro that will apply shade data to all my shapes and connectors so that I can export out the tips to excel. I have manually done it for the shapes but there are too many connectors to do this on. I have seen in another post a macro to do this but it didnt seem to work on my document.

I need to insert shape data to ones that do not already have it and then add a label of ="SHAPE TIP" and a value of =Comment to all the newly inserted shape data objects and anything that had shape data but did not have the label and comment. I need this to insert the shape data even if there are no tips as I will export this to excel to find any ones I have missed.

I have added a reduced version of my document for refference. I have tried to play around with macros but to no avail. could someone let me know what the code would need to be. Thanks
logistics-Space-test.vsd
ASKER CERTIFIED SOLUTION
Chris Roth

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros