Execute Macro in Access

[Olegik_Super (Oleg Gorelikov)]

Hi!
I run macros in access database via Execute Macro ( RPA Listings - Collections, 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”?

[balupad14 (Balamurugan)]

Hi @Olegik_Super,

Can you share the Access ?

Regards
Balamurugan.S

[Olegik_Super (Oleg Gorelikov)]

No, sorry, this db contain personal information

[balupad14 (Balamurugan)]

Hi @Olegik_Super,

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

Regards
Balamurugan.S

[loganshea]

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

[balupad14 (Balamurugan)]

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

Regards
Balamurugan.S

[loganshea]

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

[balupad14 (Balamurugan)]

Hi @loganshea,

Take a look this example.

BalaReva.Access.Activities

Hi , Here I have attached the sample for execute the macro in access. Namespace [image] Activity [image] Properties : [image] Sample: Access.zip (12.6 KB) Note: Let me if you have any errors. I would be happy to get more suggestions. Latest Package : BalaReva.Access.Activities.2.0.3.nupkg (12.6 KB) Regards Balamurugan.s

Regards
Balamurugan.S

[loganshea]

Thank you very much @balupad14

[NithyaSankar]

Will it work with .mdb file?

[balupad14 (Balamurugan)]

Hi @NithyaSankar ,

Yes.It will work.

Thank you
Balamurugan.S

[NithyaSankar]

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

Could you please reply?
Thanks in Advance,
Nithya

[balupad14 (Balamurugan)]

Hi @NithyaSankar ,

Can you please send me a sample to investigate ?

Thank you
Balamurugan.S

[NithyaSankar]

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?

[NithyaSankar]

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

Thanks,
Nithya