'%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)
How to Run Excel VBA Macros Automatically in the Cloud
Question details
A company wants to know if they can schedule an Excel VBA macro to run automatically at a specific time (e.g., 4:00 a.m.) after moving the workbook to cloud storage with co-authoring enabled.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Automating daily data updates within a macro-enabled Excel workbook hosted in a cloud environment so external systems can retrieve the processed data each morning.
- Observed behavior
- Excel for the web and server-side cloud storage do not natively support or execute VBA macros. Running automated tasks requires either a local desktop environment or modern cloud alternatives like Office Scripts.
Before configuring your automated tasks, verify that your Microsoft 365 subscription includes access to Power Automate and Office Scripts, or ensure you have a dedicated, always-on local computer if you plan to continue using legacy VBA.
Migrate to Office Scripts and Power Automate (Cloud-Native)
Since VBA does not run natively in Excel for the web, replacing your VBA code with Office Scripts and scheduling it via Power Automate provides a true server-side cloud solution.
Office Scripts use TypeScript and are designed specifically for Excel on the web. Once your script is created, Power Automate can trigger it on a precise schedule without requiring a computer to remain powered on.
Open your workbook in Excel for the web. Navigate to the Automate tab on the ribbon, select 'New Script', and rewrite your VBA logic into the TypeScript editor. Save the script.
Log into Microsoft Power Automate and click 'Create' from the left menu. Choose 'Scheduled cloud flow', name your flow, and set the starting time and daily recurrence (e.g., 4:00 a.m.).
Click 'New step' and search for 'Excel Online (Business)'. Select the 'Run script' action. Choose the cloud location (e.g., OneDrive or SharePoint), select your workbook, and pick the Office Script you just created.
Save and test the flow. Finally, update any external systems to retrieve data using Microsoft Graph APIs or the correct SharePoint/OneDrive file identifiers instead of legacy local network paths.
Schedule Execution via Dedicated Desktop Automation
If rewriting complex VBA code into Office Scripts is not feasible, you can keep the workbook in the cloud but use a local Windows machine to trigger the macro automatically.
Use WPS Office for Reliable Desktop Macro Execution
While cloud-native VBA execution is unsupported in Microsoft 365 without complicated workarounds, WPS Office provides a lightweight, cost-effective desktop alternative with powerful built-in VBA support. Easily run your legacy automated macros locally without the overhead.
- 1. Download and Install WPS Office: Visit the official WPS Office website and install the free software suite on your desktop computer.
- 2. Open Your Macro-Enabled File: Launch WPS Spreadsheets and open your .xlsm file. The familiar interface will allow you to access your existing data immediately.
- 3. Enable and Run Macros: Navigate to the Developer tab, enable macros, and utilize your traditional VBA scripts natively without requiring complex cloud conversions.
Frequently Asked Questions
Why doesn't Excel for the web support VBA macros?
Excel for the web operates on standard web technologies (HTML/JS) and does not have the underlying architecture to run Visual Basic for Applications natively. Microsoft instead provides Office Scripts for web-based automation.
Can external systems access a co-authored Excel file in the cloud?
Yes, external systems can access cloud-hosted Excel files by using Microsoft Graph API connections or proper SharePoint/OneDrive file identifiers, which is much more reliable than relying on legacy local drive paths.
Will my existing VBA code work automatically in Office Scripts?
No. VBA uses Visual Basic, whereas Office Scripts are based on TypeScript. You will need to rewrite or translate your macro logic into an Office Script before it can be scheduled in the cloud via Power Automate.
Can I use Windows Task Scheduler to run cloud macros?
Windows Task Scheduler cannot directly trigger macros on a cloud server. However, you can use it on a local PC to open a cloud-synced workbook via the desktop Excel application and execute the local macro from there.
