web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Unable to call Excel m...
Power Automate
Answered

Unable to call Excel macro with parameters

(0) ShareShare
ReportReport
Posted on by 9

Hello,

 

I'm working on a desktop flow that gets data from an outside source, and then passes these values to an Excel macro which handles the logic for populating the spreadsheet. When I try to run the macro, I get the error "Failed to run macro (makes sure the macro containing file isn't included in the disabled items list)."

 

In this same flow I call another macro but with no parameters, which has worked perfectly. Both macros are in the same Module, which is tied to the specific workbook. This led me to believe that my issue is related to how the macro with parameters is referenced in PAD. I've tried a few different variants including the filename, but have had no success. Any help would be much appreciated.

I have the same question (0)
  • Verified answer
    maxr86 Profile Picture
    9 on at

    I was able to find out my issue. One of the external pieces of data comes from a remote scale, which will normally be a number, however during my testing the scale has not been on so the reading was "OFF". This was causing an error as the parameter type in VBA was Integer, and I was trying to pass a string.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 223

#2
David_MA Profile Picture

David_MA 210 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 175

Last 30 days Overall leaderboard