How to run a macro with Python?

Question

I want to run a Macro with python. I am doing:

import win32com.client as w3c

def ejecuntar_macro():
    xlApp_mrapp = w3c.Dispatch("Excel.Application")
    pw_str = str('Plantilla123')
    mrapp = r'D:\Proyectos\Tablero estados\Tablero.xlsm'
    xlApp_mrapp.Visible = True
    xlApp_mrapp.DisplayAlerts = False 
    wb = xlApp_mrapp.Workbooks.Open(mrapp, False, False, None, pw_str)
    xlApp_mrapp.Application.Run("'" + mrapp + "'" + "!Módulo1.guardar_archivo")
    wb.Close(True)
    xlApp_mrapp.Quit()

ejecuntar_macro()

but I keep getting an error:

File ".\ejecucion.py", line 244, in ejecuntar_macro xlApp_mrapp.Application.Run("'" + mrapp + "'" + "!Módulo1.guardar_archivo") File "", line 14, in Run File "C:\Users\Ruben\AppData\Roaming\Python\Python37\site-packages\win32com\client\dynamic.py", line 314, in ApplyTypes result = self.oleobj.InvokeTypes(*(dispid, LCID, wFlags, retType, argTypes) + args) pywintypes.com_error: (-2147352567, 'Ocurrió una excepción.', (0, None, None, None, 0, -2146788248), None)

Please, Can You help me to solve it?.

error message looks similar to stackoverflow.com/questions/36064723/… — chickity china chinese chicken
– chickity china chinese chicken, Commented Jul 13, 2021 at 19:30
I'd try to comment out the last two lines in the function. Probably the file/book is closed before the macros is start. Just a guess. — Yuri Khristich
– Yuri Khristich, Commented Jul 13, 2021 at 19:36
xlApp_mrapp.Run("'" + wb.Name + "'!Módulo1.guardar_archivo") You already have the Application referenced by xlApp_mrapp so no need to add it. — Tim Williams
– Tim Williams, Commented Jul 13, 2021 at 20:32
Hi Tim Willilams. Thanks for your anwwer, You are Right, I did what you say and it works perfect. Thanks you so much. — Ruben Guevara
– Ruben Guevara, Commented Jul 13, 2021 at 21:45

S Meaden · Accepted Answer · 2021-07-13 19:45:18Z

1

I do not believe you need to specify the whole file path of the workbook to run the macro. You need to specify whole file path to open the workbook, obviously. But once the workbook is open then to run a macro you only need to specify the workbook name. So something like the following ...

xlApp_mrapp.Application.Run("Tablero.xlsm!Módulo1.guardar_archivo")

answered Jul 13, 2021 at 19:45

S Meaden

8,3203 gold badges39 silver badges74 bronze badges

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

Comments

Ruben Guevara · Accepted Answer · 2021-07-13 21:54:40Z

0

Thanks for your answers. I solved the error the follows. First, I have to say that in my macro I have a code to close the file. I removed this part.

the code is:

import win32com.client as w3c

def ejecuntar_macro():
    xlApp_mrapp = w3c.Dispatch("Excel.Application")
    pw_str = str('Plantilla123')
    mrapp = r'D:\Proyectos\Tablero estados\Tablero.xlsm'
    tablero = 'Tablero.xlsm'
    xlApp_mrapp.Visible = True
    xlApp_mrapp.DisplayAlerts = False 
    wb = xlApp_mrapp.Workbooks.Open(mrapp, False, False, None, pw_str)
    xlApp_mrapp.Application.Run("'" + tablero+ "'" + "!Módulo1.guardar_archivo")
    wb.Close(True)
    xlApp_mrapp.Quit()

answered Jul 13, 2021 at 21:54

Ruben Guevara

571 silver badge6 bronze badges

2 Comments

chickity china chinese chicken Over a year ago

great to hear you solved the error! If this answers your original question, please feel free to accept and close your post per stackoverflow.com/help/self-answer

S Meaden Over a year ago

Your change is what I recommended in my answer.

Collectives™ on Stack Overflow

How to run a macro with Python?

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related