how to have excel run a visio macro

[Irvine]

How do I call a Visio macro from an Excel macro? I have Excel make a series
of maps in Visio that indicate changes over time and I want it to save the
Visio map after each interation..

 

[David Parker [Visio MVP]]

Once you have got hold of the Visio object, ad checked that the Visio
document which contains your Visio macro is open, then you will probably
want to use the ExceuteLine method.

 

[Irvine]

Thanks, David. Once I figure out my Excel code :
vsPathFile = Cells(1, 1).Value & Cells(1, 2).Value
Set XLL = GetObject(vsPathFile)
Was giving me the Document object as XLL for the file I wanted, it worked
like a charm.