If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Visio Integration with Excel or Access
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 |
#3
|
|||
|
|||
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" wrote: sounds like a classic 'bill-of-material' scenario. Take a look at this http://msdn.microsoft.com/library/en...asp?frame=true Al "Ryan B" Ryan wrote in message ... 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 |
#4
|
|||
|
|||
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...asp?frame=true al "Ryan B" wrote in message ... 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" wrote: sounds like a classic 'bill-of-material' scenario. Take a look at this http://msdn.microsoft.com/library/en...asp?frame=true Al "Ryan B" Ryan wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
Excel Reports Using Access | Jon E | General Discussion | 1 | September 24th, 2004 06:34 PM |
Keeping the Pivot View from Access in Excel | Ferd | General Discussion | 0 | June 25th, 2004 02:22 AM |
access ...excel and infopath integration | trey braid | Using Forms | 0 | June 14th, 2004 11:28 PM |
Linking Excel data through Access to use a Form as an Interface | Laura | Links and Linking | 0 | March 23rd, 2004 03:59 PM |