Visio Guy

Visio Discussions => Programming & Code => Topic started by: Jarda on May 21, 2018, 11:45:31 AM

Title: External data - VBA - VISIO - linked shapes - generated table (excel)
Post by: Jarda on May 21, 2018, 11:45:31 AM
Hi,
i want to generate list from connection shapes.
Because i have several files visio and i need see, where shapes are used.

I see in the table External Data, which shapes are connected(first column).
But my table has 1 thousand items, only ten shapes is used(example: in the one file).

I want only this list ten items. (genereted for every visio dokuemnt)

Please, show mi, how i may get this list.

Thank you
Title: Re: External data - linked shapes - generated table (excel)
Post by: Jarda on May 22, 2018, 07:55:01 AM
This command: ActiveWindow.Select Application.ActiveWindow.Page.Shapes.ItemFromID(458), visSelect  marks one shape and 
I want to see connection  with external data.

Please, give me an advice
Title: Re: External data - VBA - VISIO - linked shapes - generated table (excel)
Post by: Surrogate on May 22, 2018, 09:13:34 AM
I don't use external data in my documents. Please read about DataRecordset Object (https://msdn.microsoft.com/en-us/vba/visio-vba/articles/datarecordset-object-visio).

Hope this link can help !

UPDATE: About Connecting to Data in Visio (https://msdn.microsoft.com/en-us/vba/visio-vba/articles/about-connecting-to-data-in-visio?ocid=AID647828_QSG_SCL_249140&utm_source=l.facebook.com&utm_medium=referral#accessing-data-in-data-recordsets-programmatically)