using visio to input datavalues into the already created sql dB/ex

[tushar]

Is it possible to use the parameters on visio flowsheet/diagram as input to
an external software/ or sql database?

I want to know that suppose i have a visio flowsheet and i have linked it to
sql database, is it possible to use this visio flowsheet to function as an
input interface to an external software or even as a point of input to sql
database which will use this data entered for further functioning?

To be clear i would like to state that I want to design a function through
visio to simulate working of a factory, so for that i need to model 'what if'
kind of scenario. So i want the user to have the flexibility to make changes
on the flowsheet itself and see what happens if he does so. Hence for that i
need to dynamaically link the flowsheet data to excel or database, from where
the simulator product will extract data and make further calculation. the
result of these calculations would have to be displayed on the visio
flowsheet via excel or database.
so basically i need to dynamically export and import data from visio to
excel or database

 

[AlEdlund]

dynamically roundtripping data (to/from visio) requires custom code to be
written.
al

 

[tushar]

so should i create macro for that? can you elaborate on the code please.
thanks

 

[AlEdlund]

Decisions to be made,
What will be the data/source sink
What code will you write in (vba is in the product, visual studio
express is free)

Skills
Gathering data from shapes (and handling visio events), a lot of this is
in the visio sdk
If you use sql server, how are your sql skills? (sql express is free)

Reading and writing from shape property examples are in the sdk, there
are a ton of
examples on moving data back and forth between sql and user code on various
microsoft sites.

al