cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ffritz
Advocate II
Advocate II

Run Excel Macro

Hi,

is it possible to execute an Excel Macro via flow for a Excel Document stored on OneDrive/Sharepiont Online or otherwise?

I could not find any activity for that.

Thx

Fritz

25 REPLIES 25
ashwinsa
Power Apps
Power Apps

Unfortunately not right now, we don't support execution of excel macro. But that is an amazing suggestion i will forward it to see if we can include it in our plans. Thanks a lot for reporting this.

Add my vote in it too. Ned the ability to run the Macro within Excel.

Anonymous
Not applicable

I would like to see this functionality as well! I hope it gets added soon.

ET
New Member

I concur, could use this feature today!

emhanna
Advocate I
Advocate I

Yes, we need to be able to run macros from a Flow. But not just Excel macros. We need to be able to run any VBA macros.

 

Here is a real world example of why we need this--in this case for quickly and easily building automated interfaces. Accounting passes us an Excel file containing some data that we need to import into Microsoft Project. We want to first run a Cleanup macro in Excel--and then we want to run a Project macro to import the data. A perfect opportunity for Flow to add significant value!

 

So much power will be unleashed, if somebody gets at it and bakes this into the Flow Service. 

I also concur with the above! 

Being able to run macros will significantly increase the use of PowerApps.

 

Additionally I also want to see the ability to, with the help of macros, save (e.g. tables of data) as .csv files locally.

Anonymous
Not applicable

Also add my vote. That's an important functionality that we need

It has been two and a half years, any update???

Anonymous
Not applicable

Please, we really need it. 

Anonymous
Not applicable

Echo all above, this would really help with process improvement and automation

JeffMcCabe
New Member

Agree with above.  Need to start modifying data mid-flow.  This will address a lot of hassle.

 

 

For those with challenges performing routine formatting macros to large quantities of flowed data, recommend creating a flow that leads data to static locations, then creating a master controller macro workbook that grabs files from those directories into an array, opens the latest workbook in those directories, applies the subformatting macro routine, then saves/closes the arrayed workbooks one by one.

 

You know.  Or Microsoft could simply add a cool new feature to call Macro/VBA code from OneDrive-stored Excel files.  Fairly simple to implement.  Would make a lot of us happy 🙂

Anonymous
Not applicable

The above can be acheived and automayed by the following steps  , below is the workaround

 

Step 1

In the Macro Enabled Excel Sheet Add another Macro to Save the File as 

ActiveWorkbook.SaveAs Filename:= _
"filename" _
, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=True

 

This will save the file as a Non Macro Excel File on a Sharepoint or Onedrive Site

 

Step 2

 

Use a Power Shell Query to update the Macro enable Excel file and save on 

 

Step 3

 

Use task scheduler to repeate the above process as per your required interval (Hourly/daily/Monthly etc)

 

 

Once the 3 steps are completed the your workbook is completely automated and can be connected to flow as any other excel file.

 

Thanks.

Gareth-
Advocate II
Advocate II

Definately needs this.  so this also means also that all flow actions that involve spreadsheets (adding a row to an existing table, etc., etc.,) need to support writing to macro enabled spreadsheets (*.xlsm) at the moment you can only write data from Flow to *.xls sheets.

 

This is extremely inconvienient and means for example in a process I wanted to automate e2e using Forms Flow Excel VBA and PowerPoint and Power BI  [ Forms data --> automatically generated pptx slide & Power BI report that links to the slide ], I have to get a human to open a macro enabled spreadsheet and run macro 1 which sucks data out of a .xls spreadsheet and then macro 2 which makes the powerpoint slides. Urgghhh.

 

Please please consider prioritising this capability,

Maddy
Regular Visitor

This would be very helpful.

Anonymous
Not applicable

Together with the possibility to update an XLSM file (e.g. add row) the possibility to run an Excel Macro has been requested for over 2 years... That's either saying something about the speed improvements are made or saying it's not going to happen.

 

Instead of focusing on inventing new names such as "Power Automate" to feed the "Power Platform" marketing bubble - address some more resources to development of the product itself so important features can get developed.

 

My 2 cents...

Anonymous
Not applicable

Yes please!

Anonymous
Not applicable

This is a definite floor in the system and is very much still needed!

akbarmahfuzalam
Post Prodigy
Post Prodigy

Since 2016 we are early waiting for this feature to add in Microsoft Automate.

Microsoft Team please prioritize this.

ShaileshMehta
Advocate I
Advocate I

This is Very Very Important for Excel user Automation Process - Microsoft should build some program/Flow allows to Run Macro either without Opening a Macro(.xlsm) enabled file OR should open Macro Enabled File on Adjustable scheduled time at Corporate SharePorint which allows to run File Open Macros and then Close that File based on Macro activation.

Helpful resources

Announcements

Check out the Copilot Studio Cookbook today!

We are excited to announce our new Copilot Cookbook Gallery in the Copilot Studio Community. We can't wait for you to share your expertise and your experience!    Join us for an amazing opportunity where you'll be one of the first to contribute to the Copilot Cookbook—your ultimate guide to mastering Microsoft Copilot. Whether you're seeking inspiration or grappling with a challenge while crafting apps, you probably already know that Copilot Cookbook is your reliable assistant, offering a wealth of tips and tricks at your fingertips--and we want you to add your expertise. What can you "cook" up?   Click this link to get started: https://aka.ms/CS_Copilot_Cookbook_Gallery   Don't miss out on this exclusive opportunity to be one of the first in the Community to share your app creation journey with Copilot. We'll be announcing a Cookbook Challenge very soon and want to make sure you one of the first "cooks" in the kitchen.   Don't miss your moment--start submitting in the Copilot Cookbook Gallery today!     Thank you,  Engagement Team

Tuesday Tip | How to Report Spam in Our Community

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   As our community family expands each week, we revisit our essential tools, tips, and tricks to ensure you’re well-versed in the community’s pulse. Keep an eye on the News & Announcements for your weekly Tuesday Tips—you never know what you may learn!   Today's Tip: How to Report Spam in Our Community We strive to maintain a professional and helpful community, and part of that effort involves keeping our platform free of spam. If you encounter a post that you believe is spam, please follow these steps to report it: Locate the Post: Find the post in question within the community.Kebab Menu: Click on the "Kebab" menu | 3 Dots, on the top right of the post.Report Inappropriate Content: Select "Report Inappropriate Content" from the menu.Submit Report: Fill out any necessary details on the form and submit your report.   Our community team will review the report and take appropriate action to ensure our community remains a valuable resource for everyone.   Thank you for helping us keep the community clean and useful!

Hear what's next for the Power Up Program

Hear from Principal Program Manager, Dimpi Gandhi, to discover the latest enhancements to the Microsoft #PowerUpProgram, including a new accelerated video-based curriculum crafted with the expertise of Microsoft MVPs, Rory Neary and Charlie Phipps-Bennett. If you’d like to hear what’s coming next, click the link below to sign up today! https://aka.ms/PowerUp  

Celebrating One Year of the Microsoft Power Up Program

As we close the first year of the Microsoft Power Up Program, it’s time to pause, reflect, and celebrate the milestones achieved on this incredible journey. With more than 25,000 passionate individuals from more than 180 countries joining us in our 12-week low-code up-skilling initiative, the resonance of this program surpassed all expectations, amplifying the essence of global learning and collaboration.   Celebrating Successes The Power Up Program’s vision was simple yet powerful: to equip individuals worldwide with the tools and knowledge needed to thrive in the era of digital transformation. And the response was nothing short of phenomenal. Participants, hailing from diverse backgrounds, united under the common goal of mastering low-code skills, bridging the gap between ambition and proficiency. 25,000+ Participants: From every corner of the globe, individuals took the plunge into the world of low-code development, driven by a shared enthusiasm for learning and growth.180+ Countries Represented: The program transcended borders, cultures, and languages, fostering a truly global community of learners united by their eagerness to empower themselves.12-Week Up-skilling Journey: The self-serve curriculum guided participants through a transformative 12-week experience, honing their Power Platform skills and unleashing their potential. One of the most inspiring aspects of the Power Up Program’s inaugural year was witnessing the success stories that emerged from the community. From career transitions to groundbreaking projects, the impact of newfound skills reverberated globally, validating the program’s mission to empower individuals to create their paths in the digital landscape. Watch some Power Up Program graduates share their success stories.         Paving the Way Forward As the Power Up Program embarks on its second year, the excitement continues to build. We’re thrilled to introduce a groundbreaking feature that amplifies the learning experience – Group Learning! The program continues to evolve for learners and volunteers. In year two, we will offer more interactive and visual learning including the opportunity to attend Microsoft partner-led App in a Day workshops. In addition, participants can now join as teams, fostering a sense of camaraderie and collaboration.   Introducing Group Learning Colleagues, friends and family now can challenge each other on a learning journey to become low-code app makers. To get started, a group leader applies and creates a team name. Once accepted, the group leader will select their preferred start date and send invitations to group members. Throughout the learning journey, group members can monitor each other’s advancement on the Power Up Program leader board, fostering healthy competition and collective growth.     Recognizing our volunteers We are pleased to recognize 13 Power Up champs as our first recipients of the Star Champ badge who displayed exemplary commitment and dedication in our first year on the Power Up Program leader board. Let’s give a shout out to the first round of Star Champs: Ahmed Salih, Akah Mandela Munab, Asia Platt, Barend Buizer, Christina Wheeler, Davy De Roeck, Drew Poggemann, Neil Hambly, Pavel Vecer, Remi Dyon, Rishona Elijah, Sheryl Neyley, and Zeeshan Saeed. This badge will be awarded to champs who have contributed more than 15 hours over the last 6 months across various volunteering categories such as supporting Power Up learners during live Q&A sessions, responding to learner questions on discussions boards and grading final app challenge submissions. We are excited for champs to have the opportunity to earn this badge that recognizes their commitment and support for the Power Up learners and to inspire many others to volunteer.               As you make your New Year’s resolutions, add building an application with Microsoft Power Platform to the list and join the Power Up Program as an individual, a group or as a volunteer!   Author: Dimpi Gandhi Source: Power Apps Product Blog

December 2023 Community Newsletter

Welcome to our December Newsletter, where we highlight the latest news, product releases, upcoming events, and the amazing work of our outstanding Community members. If you're new to the Community, please make sure to follow the latest News & Announcements and check out the Community on LinkedIn as well! It's the best way to stay up-to-date in the New Year with all the news from across Microsoft Power Platform and beyond.    This month's highlights:- Our most active community members- Season of Giving User Group Vouchers- Microsoft Power Up Program Recap - Power Platform "Depth Enablement" Workshops 2024 and more!   COMMUNITY HIGHLIGHTS Check out the most active community members of the last month! These hardworking members are posting regularly, answering questions, kudos, and providing top solutions in their communities. We are so thankful for each of you--keep up the great work! If you hope to see your name here next month, make it your New Year's Resolution to be more active in the community in 2024.   Power AppsPower AutomateCopilot StudioPower PagesWarrenBelzAgniusMattJimisonragavanrajanLaurensMScottShearerfernandosilvaLucas001Rajkumar_404wskinnermctcManikandanSHaressh2728timlNived_NambiarcapuanodaniloMariamPaulachanPstorkUshaJyothi20inzil2kvip01dpoggemannVictorIvanidzejsrandhawarenatoromaoEddieEmichael0808deeksha15795prufachM_Ali_SZ365grantjenkinsExpiscornovusdeeksha15795SpongYeRhiassuringManishSolankiSara9AARON_CManishSolankicpaytonjamesmuller     Season of Giving with Microsoft Learn Click the image here to learn more about our User Group-focused Season of Giving, where 250 community members can get 50% off vouchers for #MicrosoftLearn! This great giveaway is perfect for our User Group members looking to build their skills and knowledge through certifications on Microsoft Learn.There are a limited number of vouchers left to give away, so please don't delay! Follow the directions in the News & Announcements post to get your opportunity to grow and expand your Power Platform skills.         Power Up Program Recap Click the image below to read Dimpi Gandhi's first year review of the Microsoft Power Up Program. With more than 25,000 individuals across 180 countries joining the 12-week low-code upskilling initiative, the resonance of this program has surpassed all expectations - amplifying the essence of global learning and collaboration in the new era of digital transformation.   Power Platform "Depth Enablement" Workshops 2024 Unlock your Power Platform potential with the 2024 Business Applications "Depth Enablement" Workshops! These multi-day sessions kick off on January 24th through to March 21st, 2024, and are led by Microsoft experts who cover topics such as Sales & Marketing, Customer & Field Service, Finance & Supply Chain, and Low Code Tools. Click the link image below to enroll today and take the first steps toward expanding your expertise while leveraging built-in AI!       Create a Chatbot with Microsoft Copilot Studio Discover how you can create an intelligent chatbot with Copilot Studio and Dataverse for Teams to help you quickly respond to employee needs without building high-code solutions. Follow this link to find out more: Create a chatbot with Microsoft Copilot Studio and Dataverse for Teams           CHECK OUT THE LATEST COMMUNITY BLOG ARTICLES Power Apps Community Blog Power Automate Community Blog Copilot Studio Community Blog Power Pages Community Blog  

December 2023 User Group Update: Welcoming New Groups and Upcoming Events

A new month means it's time to celebrate and welcome the new user groups that have joined our community. We are excited to announce that we have more than 8 New Groups, which is no surprise after the amazing Microsoft Power Platform Conference. This month, we are breaking them out by the different community categories. If your group is listed here, give this post a kudo so we can celebrate with you! Don't forget to take a look at the many events happening near you or virtually! It's a great time of year to connect and engage with User Groups both locally and online.   Please Welcome Our NEW User Groups   Power Platform: PowerIT User Group: Nottingham Power Platform User Group: Bergen Power Platform User Group: Danmark Nashville Power Platform User Group Microsoft Ambassador Program y Mujer Latina Technolochicas NCWIT Community Copilot Studio:  Copilot User Group Italia Dynamics365: Dynamics User Group AdriaticDynamic 365 Azerbaijan   December User Group Events   01 Dec 2023 Aprendiendo Desarrollo web, creando mi primer power app y power page. 01 Dec 2023 Q4 Hybrid Philadelphia Dynamics 365 & Power Platform User Group Meeting05 Dec 2023APAC Dynamics 365 FastTrack Bootcamp - BI and Analytics07 Dec 2023Bay Area Power Platform Meetup: Learn, Share, and Connect07 Dec 2023Indiana D365/AX December User Group Meeting07 Dec 2023Dynamics User Group Meeting: Houston09 Dec 2023 December '23 - NEW Power Apps User Group Meeting - Online 12 Dec 2023December Cleveland Power Platform User Group Meeting12 Dec 2023 RW2 Data Stewardship Open Forum Discussion 13 Dec 2023  Black Country Power Platform User Group - December 2023 - West Midlands  

Users online (4,431)