Author Topic: Excel sheet data viewing dynamicaly by mouse click on shapes  (Read 6300 times)

0 Members and 1 Guest are viewing this topic.

kabisurya

  • Newbie
  • *
  • Posts: 2
Excel sheet data viewing dynamicaly by mouse click on shapes
« on: March 25, 2011, 07:42:56 AM »
Hi Experts,

I searched forum, but could not find solution to my requirement. I apologize if I'm putting the query in wrong section.

I need to create some network documents/diagrams which would fetch data from Excel sheets.
The equipments in Visio diagrams, should show the fetched data in data graphic by any one of procedures "clicking on shapes", "right click and get menu to view relevent data", "viewing the data when mouse moved on to shape".
When i add any new shape, how can I enter data for new shape, and the entered data should be placed in a Excel sheet.

Thanks in advance
Kabi

aledlund

  • Hero Member
  • *****
  • Posts: 1412
Re: Excel sheet data viewing dynamicaly by mouse click on shapes
« Reply #1 on: March 26, 2011, 07:20:24 AM »
This might help you in understanding roundtripping of information between Visio and an external source (xml, excel, access).

http://visguy.com/vgforum/index.php?topic=2298.0

If you want to go deeper some of these have projects over on codeplex

http://www.youtube.com/my_playlists?p=BAFAAC68D36484CA

al
« Last Edit: March 26, 2011, 07:23:13 AM by aledlund »

kabisurya

  • Newbie
  • *
  • Posts: 2
Re: Excel sheet data viewing dynamicaly by mouse click on shapes
« Reply #2 on: March 28, 2011, 01:22:38 AM »
Thanks a lot Al for your reply and nice posts. ;D Currently I'm going through them to understand how it would be useful for me.