Cannot run visio macro using python

Question

I'm trying to run a visio macro using python. I got this so far which doesn't work i get error: AttributeError: <unknown>.Run when calling doc.Application.Run

if os.path.exists("Drawing1.vsdm"):
    visio = win32com.client.Dispatch("Visio.Application")
    visio.Visible = 1
    doc = visio.Documents.Open("Drawing1.vsdm")
    doc.Application.Run("Drawing1.vsdm!test.Read_text_File")

I have seen some examples where people are running excel macros this way

if os.path.exists("excelsheet.xlsm"):
    xl=win32com.client.Dispatch("Excel.Application")
    xl.Workbooks.Open(os.path.abspath("excelsheet.xlsm"))
    xl.Application.Run("excelsheet.xlsm!modulename.macroname")
    xl.Application.Save() 
    xl.Application.Quit()
    del xl

Any ideas?

JohnGoldsmith · Accepted Answer · 2019-03-13 11:41:34Z

2

In Visio the Application object doesn't have a Run method, but there is an ExecuteLine method on Document.

So if your Visio document had a VBA procedure like this:

    Public Sub SayHello(ByVal name As String)
        MsgBox "Hello " & name & "!", vbOKOnly
    End Sub

then the following Python would work:

doc.ExecuteLine('ThisDocument.SayHello "Bob"')

answered Mar 13, 2019 at 11:41

JohnGoldsmith

2,70816 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rajesh Kumar Sahoo Over a year ago

doc.ExecuteLine('ThisDocument.SayHello "Bob"')? Can you please tell if i want to run the macro using ExecuteLine function how to do so ?

Vokoramus Yuriy · Accepted Answer · 2024-11-03 20:14:27Z

0

@Rajesh Kumar Sahoo I think you should use something like this (using the code example above):

Public Sub SayHello(ByVal name As String)
    Call YourMacroName
End Sub

answered Nov 3, 2024 at 20:14

Vokoramus Yuriy

1

Collectives™ on Stack Overflow

Cannot run visio macro using python

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related