Visio Integration with Excel or Access

[Ryan B]

Does anyone know of a way to link a value in either Excel or Access to an
object in Visio?

I'm working with a parts catalog of 2000+ parts that each have a unique part
number. When I build a quote for a system, I would like to have a Visio
document automatically created based on the part numbers that have been
quoted.

The parts catalog resides in Access, but the final output is in Excel.

Any help would be appreciated.

Thanks

 

[Al Edlund]

sounds like a classic 'bill-of-material' scenario. Take a look at this
http://msdn.microsoft.com/library/en-us/dnvisio00/html/netconfig.asp?frame=true
Al

 

[Ryan B]

Thanks. This was helpful. It is the reverse of what I'm trying to accomplish,
but I think it points me in the right direction.

This seems to build a quote based on the objects in a Visio document. I'm
trying to build a drawing based on the items quoted.

I couldn't get any of the macros to work in this demo though.

Thanks again,

Ryan

 

[Al Edlund]

Ryan,
the two toughest parts are learning to get the office integration to work
(i.e. talk to access and excel) and then do the drawing. This example gets
the integration to work. I don't know your coding background but things to
consider are a.) the vba code is for v2000, and b.) the integration code was
probably o2000. So check the references. Regarding the drawing part I'd
strongly suggest getting the visio sdk from the msdn site. It has code you
can use for basic functions. Finally by going to the Developing Visio
Solutions you can get a lot of examples on how to tie this together.

http://msdn.microsoft.com/library/en-us/devref/HTML/DVS_01_Introduction__544.asp?frame=true

al