News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Accessing Excel-Diagram-Object in Visio

Started by gruenefeder, September 18, 2008, 11:38:31 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

gruenefeder

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

Visio Guy

#1
Servus Daniel!

Look at this article over on my Visio Guy site:

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!
For articles, tips and free content, see the Visio Guy Website at http://www.visguy.com
Get my Visio Book! Using Microsoft Visio 2010

Browser ID: smf (is_webkit)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 168 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1054KB.
Tokens: post-login.
Cache hits: 13: 0.00162s for 26,766 bytes (show)
Cache misses: 2: (show)
Queries used: 16.

[Show Queries]