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.
|