#1
|
|||
|
|||
Create Visio Diagram from Excel
Hi,
I need to write a code to create visio flow diagram with excel inputs(Excel 2007). Attached is the requirement. Please help. |
#2
|
||||
|
||||
If you're going to create a Visio document, san, you need to use the Visio object model. You can certainly do it in Excel; but you'll be referring to the Visio application and its objects from within your Excel program. Alternatively you can run the VBA program in Visio and from there refer to the Excel application and its objects. Actually that's probably how I'd do it—either that, or do it in VBScript and refer to both objects from one doubleclickable icon.
But none of this can happen without using the Visio object, however that looks. Is Visio part of MS Office, now? If so, I'm sure this can be done. |
#3
|
||||
|
||||
It never has been - it's a separate product that can integrate with Office.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
||||
|
||||
Cool! How does the integration work? Is there a VBA-accessible object, or what?
|
#5
|
||||
|
||||
Yes, Visio has a VBA object model. Office apps aren't the only ones to do so. Even completely independent products like Adobe Acrobat (Pro) have them and can both automate and be automated from Office or other VBA-enable apps.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create Visio Diagram from Excel | san1979 | Visio | 2 | 06-18-2014 05:44 AM |
Inputing Text from Excel sheet to multiple Word documents and Visio File | Jazz43 | Office | 1 | 05-30-2013 02:08 PM |
Create DDL from Excel source | BradleyS | Word | 1 | 01-30-2013 10:58 PM |
How can I create hidden cell in Excel? | itsolexpert | Excel | 2 | 05-15-2012 09:59 AM |
How Do I Create Excel Web Pages With Java | highbids | Office | 0 | 04-13-2006 06:53 PM |