Programmatically create shapes and Customer Properties from an Access db or Excel sheet

[Fabian]

Hi all there,

I would like to develop a VBA macro for Visio 2003 that creates/sets up
shapes based on the content of a Ms database (or an excel table). Then
I would also like to be able to create a list of Custom Properties for
each shape based on another table in the same database. The source
could also be an excel sheet, it does not matter so much.I am quite
confident I can develop the "reading" the input part.On the contrary, I
am not familiar with the Visio objects.

Can you please indicate me a link, an example of where I could find
something as described above

Thanks a lot for your support.

Rgds,
Fab.

 

[Mark Nelson [MS]]

There is a sample flowchart application available in the Visio 2003 SDK.

http://msdn.microsoft.com/office/understanding/visio/tools/default.aspx

"Shows how to create a Component Object Model (COM) add-in that automates
the creation of a flowchart drawing from a Microsoft® Office Excel
spreadsheet, uses command bars in the Visio user interface, and publishes
the drawing to the Web or to a Microsoft® Office Word document. "


--
Mark Nelson
Office Graphics - Visio
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Al Edlund]

Mark,
Can we put a vote in for a future version of the orgchart example. Rather
than programmatically calling the orgchart wizard a little more detail on
how to change the layout and connections similar to what the wizard does.
tks,
al