Answered

Run A Excel VBA Code from Power automate

(2) Share

Report

Posted on by Kannan_n

499 Super User 2024 Season 1

Hi all i need help. I have an Excel file. That file is connected with 1 access file and it will generate a production report based on the business rules. But now i want to automate it. I want to run the Excel macro once it's run I want to send the table report data want to send mail to my team. Is it possible?

if it is not possible send me some other ways to do it.

Categories:

Business Process Flows

I have the same question (0)

All responses (5)

Answers (3)

lbendlin 8,355 Super User 2025 Season 2 on at

Like (1)

Report

Re: Run A Excel VBA Code from Power automate

Use Office Scripts instead of VBA.

Was this reply helpful? Yes No
Verified answer

Kannan_n 499 Super User 2024 Season 1 on at

Like (2)

Report

Re: Run A Excel VBA Code from Power automate

In the previous file they Wright more then 3 macro each more then 1500 lines of code. If I want to Wright each and everything from scratch.

I don't have that much experience in programing. Is that any other way

Was this reply helpful? Yes No
lbendlin 8,355 Super User 2025 Season 2 on at

Like (1)

Report

Re: Run A Excel VBA Code from Power automate

Review your choice of tools. If your process works in Excel then keep using Excel.

Was this reply helpful? Yes No
Verified answer

rzaneti 4,159 Super User 2025 Season 2 on at

Like (1)

Report

Re: Run A Excel VBA Code from Power automate

Hi @Kannan_n ,

An alternative is to use Power Automate Desktop for that, as there is a 'Run Excel Macro' action:

Before use it, make sure if your current Power Automate license covers Desktop flows.

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.
http://digitalmill.net/

Was this reply helpful? Yes No
Verified answer

Kannan_n 499 Super User 2024 Season 1 on at

Like (1)

Report

Re: Run A Excel VBA Code from Power automate

Hi @rzaneti if I want to use automat desktop I want to keep open my system. In my excel as well we have done automation. But once 24 hover done it's servers system so it will restart so again I want to login and want to open. To solve this I plan to use cloud flow.

My requirement is to send hoverly production report to my team.

Can I convert excel macro to script file?

Was this reply helpful? Yes No