Execute Macro in Access

Hi!
I run macros in access database via Execute Macro ( RPA Components - Bundles, Integration Packs | UiPath Marketplace) . In macros i have Message Box, where i need input text and then click ok.
How can I track this message via uipath to enter message and to press button “ok”?

Hi @Olegik_Super,

Can you share the Access ?

Regards
Balamurugan.S

No, sorry, this db contain personal information :frowning_face:

Hi @Olegik_Super,

Create a simple sample access db with your situation. send it to me.

Regards
Balamurugan.S

Hello @balupad14 and @Olegik_Super,

I was wondering if you ever found out if you could execute a macro within Access instead of Excel?

Thank you,
Logan

I think . Yes. Can you attach a sample which you mean…

Regards
Balamurugan.S

I don’t have a sample to send. Could you just elaborate on how you would go about doing it? A pure example shouldn’t be needed. I’m simply running a macro that’s attached to a button in Microsoft Access.

Thanks,
Logan

Hi @loganshea,

Take a look this example.

Regards
Balamurugan.S

1 Like

Thank you very much @balupad14

1 Like

Will it work with .mdb file?

Hi @NithyaSankar ,

Yes.It will work.

Thank you
Balamurugan.S

Thank you… How to pass parameters to the macro? Suppose macro has 2 parameters,

image

Could you please reply?
Thanks in Advance,
Nithya

1 Like

Hi @NithyaSankar ,

Can you please send me a sample to investigate ?

Thank you
Balamurugan.S

I am sorry for the delay. I was not aware of how to create a sample access DB file with macro. Now I have created one with the help of my colleague.
Sharing that here.
Sample_AccessDBFile.zip (362.4 KB)

When click on the macro in that file, it will ask for the parameters.
you can use 11 and 12 as the parameter values respectively. Please see below:

Execute Macro in the Access Activities package is not working with this(If input parameters are there).
Can you please help me with this?

1 Like

Hi Balamurugan
Could you please help me on this. I already shared the sample DB file.

Thanks,
Nithya