Passing Data from Visio to Excel - Any Wisemen Here?

[SteveM]

I posted the note below to the Visio group. Can a reference. But I'm
trying here just to see how expansive the genius of this Group really
is. Thanks, SteveM

********************** OP ****************************

I'm lost. I'm not a programmer, but an optimization/simulation
modeler who often builds models using Excel as the User Interface for
model and data management. I can program fairly well in VBA for
Excel. I having been playing with Visio 2007 Professional as a
possible interface because my models usually map to real objects so
being able to adjust parameter values using Visio Shapes would be very
appealing to clients.

OK, so enough about me. I've looked and looked and can't for the life
of me find some end to end code that shows me how I can link 1 data
cell in a Visio Shape to 1 Range cell in an Excel workbook. Such that
a change in the Visio cell will update the workbook cell value.

I understand all of the one-way Excel to Visio data linking
functionality. But this apparently simple chore of going the other
way leaves me mystified.

Can anybody help me with advice and/or a reference to not too
complicated code on either the Visio and/or Excel end?

I.e. I don't want to build a BOM app. I just what say, "youExcelCell
= youVisioCell" Once I have that down, I'm pretty sure I could figure
out the rest.

Thanks Very Much,

SteveM

 

[John Bundy]

Very interesting concept, i've never tried anything like it but would like to
try. This looks like it holds the answers though, let me know.

http://support.microsoft.com/default.aspx?scid=kb;en-us;254591
http://support.microsoft.com/default.aspx?scid=kb;en-us;323451

 

[SteveM]

Very interesting concept, i've never tried anything like it but would liketo
try. This looks like it holds the answers though, let me know.

http://support.microsoft.com/defaul...crosoft.com/default.aspx?scid=kb;en-us;323451
--
-John
Please rate when your question is answered to help us and others know what
is helpful.













- Show quoted text -

John,

Thanks, but I've already plowed that ground. The Visio Data Wizard
only provides links in one direction, from the source (Excel here) to
Visio. You can update the linked cells in Visio but the updates are
not directly passed to Excel. The only complete example of the back
and forth linkage I could find is here:

http://msdn2.microsoft.com/en-us/library/aa701255.aspx

But it's for building a Bill of Materials (BOM) and it's coded in C
not VBA. I do not need anything nearly that complicated. My models
are on-off excursions to support analytical studies and then retired.
But I was thinking of a Visio interface to an Excel model would be
attractive to the customer. Visio has a much more complex data model
than the Excel Object. I'm just looking for code that takes me
relatively easily from A in Visio to B in Excel merely to adjust
parameters in an underlying model and change the properties of Visio
Shapes based on model solutions.

I'll fill you guys in if I learn more.

SteveM