Calling Embedded Visio macros from Excel VBA module

S

Seption

Hi. I have an excel spreadsheet in which I have embedded a Microsoft Visio
object. If I edit the Visio Object, I can record macros within the Visio
Object (for changing shapes, etc.). I cannot figure out how to call these
macros from the main Excel VBA module.

Has anyone ever attempted this before? Any success? Any help would be
greatly appreciated. Thanks!

-Brian
 
D

David J Parker

Well, I haven't tried exactly the method that you have chosen.
You can either move your Visio macros into Excel, and just get a reference
to the Visio Application object, or you could attempt to leave the code in
Visio and use the ExecuteLine method.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio shape text disappears upon copy paste 1
Calling Embedded Object macros from Excel VBA 0
At a loss for simple Visio VBA actions 1
Editing an embedded Excel Worksheet Object 0
Importing Data Into Visio 2003 Pages 3
Find text in embedded Visio diagrams within a Word document. 0
Visio 2007 objects embedded in Word Files 1
Saving Visio objects in Word documents as Visio files 8

Top