'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Can Power Automate Run Excel VBA Macros in SharePoint Online?
Question details
The user wants to configure Power Automate to automatically trigger a VBA macro every hour within an Excel workbook hosted in a SharePoint folder.
- Product
- Power Automate, SharePoint Online, Excel
- Device & OS
- not provided
- Scenario
- Automating recurring business processes by running an existing VBA macro directly from a cloud storage environment (SharePoint) on an hourly schedule.
- Observed behavior
- The user is seeking a method or confirmation on whether a cloud-based flow can execute local VBA code without manually opening the desktop application.
Keep in mind that traditional VBA macros require the desktop version of Excel to execute, which introduces compatibility challenges for cloud-only automation services.
Seek Guidance from the Microsoft Power Platform Community
Since cloud execution of desktop macros involves complex workarounds, consulting dedicated Power Automate engineers is the official recommendation.
VBA is inherently a desktop technology, while Power Automate operates in the cloud. Directly triggering a VBA macro inside SharePoint Online using a standard cloud flow is generally not supported natively.
Microsoft engineers and experienced automation professionals in the Power Platform Community can evaluate your specific use case and suggest exact architecture solutions.
Navigate to the official Microsoft Power Platform Community website in your browser.
Select the 'Power Automate' section to ensure your query reaches the right experts.
Create a new thread explaining that you need an hourly trigger for an Excel workbook stored in a SharePoint folder, and ask if a Desktop Flow or alternative is required.
Alternative: Use Office Scripts for Cloud Automation
Convert your existing VBA code into Office Scripts, which are natively supported by Power Automate and Excel on the web.
Need a Reliable Desktop Suite for Local Macros?
If cloud automation proves too restrictive and you prefer running and managing your VBA macros locally, WPS Office is an excellent, lightweight alternative. It provides high compatibility with Microsoft Office files and powerful tools without the hefty subscription fees.
- 1. Download the Installer: Visit the official WPS website and download the free version of the suite.
- 2. Install WPS Office: Run the setup file and follow the quick installation prompts on your desktop.
- 3. Open Macro Files: Launch WPS Spreadsheets and open your .xlsm files to continue working on your data locally.
Frequently Asked Questions
Can Power Automate trigger an Excel macro on a closed file?
No, traditional VBA macros require the Excel desktop application to be open to execute. Power Automate cloud flows cannot natively open a desktop application to run these macros.
What is the best cloud alternative to Excel VBA?
Office Scripts are the modern, cloud-first alternative to VBA. They are written in TypeScript, run in Excel on the web, and integrate perfectly with Power Automate.
Does SharePoint Online natively run VBA scripts?
SharePoint Online acts as a cloud storage repository and does not have a native execution engine for VBA scripts, which are strictly desktop-based.
Can I use Power Automate Desktop to run my macros?
Yes. Power Automate Desktop (RPA) can be scheduled via a cloud flow to open Excel on a physical or virtual machine, run the macro, and save the file back to SharePoint, though this requires premium licensing and dedicated machine setup.
