It is a great shame that PowerApps can run excel macros yet....
Here is a work around
utilize the Windows Task Scheduler application (don’t worry, this comes installed with most Windows PCs) to automatically open an Excel file, run it’s VBA code, save the file, and finally close the Excel file. With this solution, you will be able to customize the frequency and exact time(s) this automation will need to be executed. The ONLY CATCH to this solution, is that the PC will need to be on during the scheduled time.
https://www.thespreadsheetguru.com/blog/how-to-automatically-run-excel-vba-macros-daily
No comments:
Post a Comment