How execute an Access Macro with arguments?

[jorge_10]

Hi everyone,
I need to pass the table name throught arguments but at the moment I can´t do this. How can achieve it?

@balupad14 I’ll really appreciate your support.

Thanks in advance!!!
Regards from PERU!!!

[Marius_Puscasu]

Hi @jorge_10 ,

It seems that additional packages aren’t needed to be installed.

Try this:
Use the start process activity.
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"

Source:

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…

Hope it helps
Best regrds,
Marius

[balupad14 (Balamurugan (BalaReva))]

Hi @jorge_10 ,

Thank you for using the package. Kindly I request you to send me a sample project with access file.

Thank you
Balamurugan.S

[jorge_10]

Hi @balupad14,

The package are really useful. This is the access file.

PlantillaBBDDConsolidadoAnual.zip (50.3 KB)

I hope you can help me.

[jorge_10]

Hi @Marius_Puscasu,
I need to pass the name of table throught arguments. I send you the access file. Thanks for your help.

PlantillaBBDDConsolidadoAnual.zip (50.3 KB)

I hope you can help me.

[balupad14 (Balamurugan (BalaReva))]

Thank you @jorge_10 ,

Let me check and get back to you.

[simone.trenta]

Hi @Marius_Puscasu, how can I pass some parameter in an Access Macro using this method?