Hi there,
I have integrated an Excel-Diagram-Object in Visio. I have two views of the Excel-Diagram-Object:
a) the diagram
b) the Excel-Table (basis for the diagram)
Is there a means to access and use the data from the Excel-Table in Visio or maybe in another Excel-Diagram-Object?
I'm thakful for any information!
Best,
Daniel
Servus Daniel!
Look at this article over on my Visio Guy site:
Sales Force Automation With Visio (http://www.visguy.com/2007/06/03/sales-force-automation-with-visio/)
The example generates a BOM (Bill of Materials listing) in an embedded Excel object, similar to what you are doing. The VBA code should demonstrate how to get the Excel object.
- Chris
auf geht's zur wies'n!