Visio From Within Excel

[K Kazinski]

I want to have my excel spreadsheet vb programs create a
diagram from the data on a sheet, but when I look at the
references to add a reference for the visio object, I see
about 10-15 different visio references.

Which reference is for visio?

Thanks,

Ken

 

[Al Edlund]

would you care to share with us where you are looking at these 'references'
so that we might have a point of commonality?
al

 

[John Marshall, MVP]

When you are in VBA in Excel, you have to tell VBA which objects are exposed
(the DLLs). From the menu it is Tools > Reference

In this case the reference to choose is Microsoft Visio xx Type library (xx
is 10 or 11 depending on the version of Visio available)

John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm

 

[Guest]

Thank you John worked great!

-----Original Message-----
When you are in VBA in Excel, you have to tell VBA which objects are exposed
(the DLLs). From the menu it is Tools > Reference

In this case the reference to choose is Microsoft Visio xx Type library (xx
is 10 or 11 depending on the version of Visio available)

John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm
at these
'references'


.