How to run a MS Access macro from python

Question

I'm trying to run an existing Microsoft Access Macro from a python script. What I currently have is

import win32api,time
from win32com.client import Dispatch

strDbName = 'Exit.mdb'
objAccess = Dispatch("Access.Application")
objAccess.Visible = False
objAccess.OpenCurrentDatabase(strDbName)
objDB = objAccess.CurrentDb()
objAccess.run('test')
objAccess.Application.Quit()

When I run this I get the error

Traceback (most recent call last):
  File "accessmacro.py", line 10, in <module>  
    objAccess.run('test')  
  File "<COMObject Access.Application>", line 2, in run  
pywintypes.com_error: (-2147352567, 'Exception occurred.', (0, None, u"Microsoft    Office  Access can't find the procedure 'test.'", None, -1, -2146825771), None)

HansUp · Accepted Answer · 2019-04-23 13:16:10Z

6

The Run Method expects the name of a "user-defined Function or Sub procedure". But, if 'test' is the name of a macro, use RunMacro Method

objAccess.DoCmd.RunMacro('test')

edited Apr 23, 2019 at 13:16

answered Feb 7, 2012 at 15:06

HansUp

97.3k11 gold badges80 silver badges139 bronze badges

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

Collectives™ on Stack Overflow

How to run a MS Access macro from python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related