Hi,

I need to write a code to create visio flow diagram with excel inputs(Excel 2007). Attached is the requirement.

Please help.

Attached Files

Requirement_Specification.docx (83.0 KB, 13 views)

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.

It never has been - it's a separate product that can integrate with Office.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Cool! How does the integration work? Is there a VBA-accessible object, or what?

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]