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
|
|||
|
|||
read spreadsheet from VISIO
INTRO
I'm a long time Visio user, limited to creating electrical diagrams and system interface drawings etc. I have created some of my own shapes. Now I need to do something a bit more hard core! THE POINT I have created a cabling diagram that has identifying text (labels) for each component in the signal path; cable numbers, connector numbers etc. The system contains 555 duplicate paths. In Visio we have created a diagram showing one "example" path and have a supporting spreadsheet that lists all other components. I would like to create an interactive sheet that I could click a drop down menu for the component at the end of one of the circuits lets say end device #5 and have the diagram fill the drawing with the data corresponding to device 5. Can I do this in Visio, if so can someone point me in the right direction. I have used VBA for excel |
#2
|
|||
|
|||
read spreadsheet from VISIO
It sounds as if what you want to create is a template with custom/user
properties for objects that have a direct correlary to cells in the spreadsheet. i.e. column 1 will always be the parameter 1 for object A in the drawing, column 2 will always be parameter 2 for object A, etc. and you just want to populate the data. That's fairly straight forward in Visio. You can check either David Edson's book or Graham Widemans for examples of working back and forth. David has some good examples of integrating MS Office. "Robert" wrote in message om... INTRO I'm a long time Visio user, limited to creating electrical diagrams and system interface drawings etc. I have created some of my own shapes. Now I need to do something a bit more hard core! THE POINT I have created a cabling diagram that has identifying text (labels) for each component in the signal path; cable numbers, connector numbers etc. The system contains 555 duplicate paths. In Visio we have created a diagram showing one "example" path and have a supporting spreadsheet that lists all other components. I would like to create an interactive sheet that I could click a drop down menu for the component at the end of one of the circuits lets say end device #5 and have the diagram fill the drawing with the data corresponding to device 5. Can I do this in Visio, if so can someone point me in the right direction. I have used VBA for excel |
#3
|
|||
|
|||
read spreadsheet from VISIO
"It sounds as if what you want to create is a template with
custom/user properties for objects that have a direct correlary to cells in the spreadsheet. i.e. column 1 will always be the parameter 1 for object A in the drawing, column 2 will always be parameter 2 for object A, etc. and you just want to populate the data." Thats exactly what I want, thanks for pointing me to the books. Ill be checking them out ASAP Robert "Al Edlund" wrote in message ... It sounds as if what you want to create is a template with custom/user properties for objects that have a direct correlary to cells in the spreadsheet. i.e. column 1 will always be the parameter 1 for object A in the drawing, column 2 will always be parameter 2 for object A, etc. and you just want to populate the data. That's fairly straight forward in Visio. You can check either David Edson's book or Graham Widemans for examples of working back and forth. David has some good examples of integrating MS Office. "Robert" wrote in message om... INTRO I'm a long time Visio user, limited to creating electrical diagrams and system interface drawings etc. I have created some of my own shapes. Now I need to do something a bit more hard core! THE POINT I have created a cabling diagram that has identifying text (labels) for each component in the signal path; cable numbers, connector numbers etc. The system contains 555 duplicate paths. In Visio we have created a diagram showing one "example" path and have a supporting spreadsheet that lists all other components. I would like to create an interactive sheet that I could click a drop down menu for the component at the end of one of the circuits lets say end device #5 and have the diagram fill the drawing with the data corresponding to device 5. Can I do this in Visio, if so can someone point me in the right direction. I have used VBA for excel |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Delivery and Read Receipts | hwhite | General Discussion | 0 | July 22nd, 2004 10:40 PM |
Visio files in Word | Beth | General Discussion | 0 | May 31st, 2004 12:36 PM |
excel spreadsheet from another spreadsheet | Chris | New Users | 3 | May 29th, 2004 12:01 AM |
Show the product of a formula calculated in spreadsheet one in spreadsheet 2 | Ronnie | Worksheet Functions | 1 | December 5th, 2003 02:20 AM |
multi-user lockout of linked excel spreadsheet | Tim Schiermeyer | Setting up and Configuration | 0 | November 15th, 2003 01:56 AM |