How to start multiple macros in Microsoft Access with Uipath

Help Studio
, , , ,
1

Hi everyone,

I am in need for a solution on how to run/start multiple macros in Microsoft Access with UiPath.

I have seen the solution from the resolved question by the user [brian.c.hunt], but I am wondering whether this is the only solution for this case.

Any help is appreciated.

Thanks a lot in advance and kind regards,
Anastasia

Solution by the user brian.c.hunt to the question: How can I start a macro in MS Access with database activities?

"Try this: Use the start process activty.
First argument is the .exe of access. example : “C:\Program Files\Microsoft Office\Office16\MSACCESS.EXE”

Second argument is the database file “”“C:\User\Myself\Path with spaces works\MyDB.accdb”“” + " /x macro_name_here"

Triple quotes allows spaces in the name but doesn’t allow /x. So to handle both cases, you triple quote the path, then add on a single quote string. Note the space at the start of the second string ‘/x’ is a command line argument that allows specification of a macro name. I sometimes get a message saying I don’t have exclusive rights to the DB which may need to be handled separately. However, this should start Access, and then run a macro inside the DB specified."

2

@Anaskra

Welcome to the community

You can create a excel vba or use an invoke code and try running macros on the access

cheers