How Pass Input Data From Visio To Excel?

[SteveM]

I have an Excel data base linked to a Visio document. The Excel
workbook contains a model. Change the parameters of the model, the
outputs to Visio are updated. But I'd like to keep the user in the
Visio environment if I could.

So is there a "Best Practice" for passing data values back to Excel
ranges from Visio?

I'm guessing that this topic has been addressed before. So I'm just
asking for any references to sample code first before I start
unloading questions.

Thanks much for the assistance.

SteveM

 

[AlEdlund]

I certainly wouldn't raise this as a 'best practice', but it does include
examples.

http://www.visguy.com/2009/04/08/path-analysis-in-visio/

al

 

[SteveM]

I certainly wouldn't raise this as a 'best practice', but it does include
examples.

http://www.visguy.com/2009/04/08/path-analysis-in-visio/

al

Al,

Thanks much for the response. Very elaborate piece of work. Nicely
done.

While I noodle through your code, let me ask you then:

The simple UI solution for collecting parameters from a user is a
standard VBA form?

The Visio data links only go one way right? I.e., the source to
Visio?

Hmm? Will Visio 2010 continue to be one-way only? I was thinking, if
it were two-way, I could map a single row Excel range to a
"Parameters" Shape that set my own model parameters, have the user
update that single shape data and launch the model using a Command
button like you do.

I suppose two-way linking from a shape is possible just by updating
the shape data and sending it back to Excel using your export
routines. But in the grand scheme of things, parameter management via
a Shape rather than a Form is only eye candy?

Regards,

SteveM

P.M. I noticed a reference in your code to Dijkstra's algorithm. Are
you an Operations Research (OR) guy?

 

[AlEdlund]

The drawing was meant as an example to look at some of the issues revolving
around those that wanted to understand the connectivity and path analysis of
a drawing. It has examples for both reading (with recordsets) and writing
(to cells in excel), but that was only to make the external information more
accessible to those that might want to experiment with it.

"The Visio data links only go one way right? I.e., the source to Visio?"
Datarecordsets are a one way trip (inbound) even in v2010.

" I could map a single row Excel range to a "Parameters" Shape that set my
own model parameters, have the user
update that single shape data and launch the model using a Command button
like you do."
Check out the visio sdk (available on msdn), Visio is aware of changes to
the drawing and the events that wrap around it and is certainly not limited
to 'forms based' data entry. VBA is great for sandboxing and there are
examples all over the 'net on how to integrate back and forth between the MS
office stuff.


"Are you an Operations Research (OR) guy?"
Nope, Network Architect/Consultant/Analyst

al

 

[SteveM]

The drawing was meant as an example to look at some of the issues revolving
around those that wanted to understand the connectivity and path analysisof
a drawing.  It has examples for both reading (with recordsets) and writing
(to cells in excel), but that was only to make the external information more
accessible to those that might want to experiment with it.

"The Visio data links only go one way right?  I.e., the source to Visio?"
Datarecordsets are a one way trip (inbound) even in v2010.

" I could map a single row Excel range to a "Parameters" Shape that set my
own model parameters, have the user
update that single shape data and launch the model using a Command button
like you do."
Check out the visio sdk (available on msdn), Visio is aware of changes to
the drawing and the events that wrap around it and is certainly not limited
to 'forms based' data entry. VBA is great for sandboxing and there are
examples all over the 'net on how to integrate back and forth between theMS
office stuff.

"Are you an Operations Research (OR) guy?"
Nope, Network Architect/Consultant/Analyst

al

Al,

Great feedback. Thanks a lot.

I'm an OR guy and many of the models I build are one-off with not many
users. And I'm someone who programs, but not a programmer. So I
never get out of the VBA sandbox.

I'll check out the sdk and see what kind of havoc I can wreak.

SteveM

 

[Betty Carson]

There are some great new Practise Visio Diagrams help guides available for IT and business professionals worldwide to visualize, analyze, and communicate complex information, systems, and processes with tools, such as HP Visio Stencils.
http://visiotoolbox.com/Practices/



AlEdlund wrote:

I certainly would not raise this as a 'best practice', but it does
01-Oct-09

I certainly would not raise this as a 'best practice', but it does includ
examples

http://www.visguy.com/2009/04/08/path-analysis-in-visio

al

Previous Posts In This Thread:

I certainly would not raise this as a 'best practice', but it does
I certainly would not raise this as a 'best practice', but it does includ
examples

http://www.visguy.com/2009/04/08/path-analysis-in-visio

al

The drawing was meant as an example to look at some of the issues
The drawing was meant as an example to look at some of the issues revolvin
around those that wanted to understand the connectivity and path analysis o
a drawing. It has examples for both reading (with recordsets) and writin
(to cells in excel), but that was only to make the external information mor
accessible to those that might want to experiment with it

"The Visio data links only go one way right? I.e., the source to Visio?
Datarecordsets are a one way trip (inbound) even in v2010

" I could map a single row Excel range to a "Parameters" Shape that set m
own model parameters, have the use
update that single shape data and launch the model using a Command butto
like you do.
Check out the visio sdk (available on msdn), Visio is aware of changes t
the drawing and the events that wrap around it and is certainly not limite
to 'forms based' data entry. VBA is great for sandboxing and there ar
examples all over the 'net on how to integrate back and forth between the M
office stuff

"Are you an Operations Research (OR) guy?
Nope, Network Architect/Consultant/Analys

al

How Pass Input Data From Visio To Excel?
I have an Excel data base linked to a Visio document. The Exce
workbook contains a model. Change the parameters of the model, th
outputs to Visio are updated. But I'd like to keep the user in th
Visio environment if I could

So is there a "Best Practice" for passing data values back to Exce
ranges from Visio

I am guessing that this topic has been addressed before. So I am jus
asking for any references to sample code first before I star
unloading questions

Thanks much for the assistance

SteveM

Al,Thanks much for the response. Very elaborate piece of work. Nicelydone.
Al

Thanks much for the response. Very elaborate piece of work. Nicel
done

While I noodle through your code, let me ask you then

The simple UI solution for collecting parameters from a user is
standard VBA form

The Visio data links only go one way right? I.e., the source t
Visio

Hmm? Will Visio 2010 continue to be one-way only? I was thinking, i
it were two-way, I could map a single row Excel range to
"Parameters" Shape that set my own model parameters, have the use
update that single shape data and launch the model using a Comman
button like you do

I suppose two-way linking from a shape is possible just by updatin
the shape data and sending it back to Excel using your expor
routines. But in the grand scheme of things, parameter management vi
a Shape rather than a Form is only eye candy

Regards

Steve

P.M. I noticed a reference in your code to Dijkstra's algorithm. Ar
you an Operations Research (OR) guy?

ngofingore?"yedMSude..eestyifa
n
o
in
or
?

e
M
ud
..


s

i
a


Submitted via EggHeadCafe - Software Developer Portal of Choice
More Fun with Fluent NHibernate Automapping
http://www.eggheadcafe.com/tutorial...9-81ee42171b00/more-fun-with-fluent-nhib.aspx