Forum Discussion
Triggering an Open event macro via .xlam or tasks scheduler or etc
Hello All, i have put together a flow in Power Automate Desktop, which collects info from a special sheet installed/prepared on each .xls* format file of a company. The vba code of installing/mon...
If you have access to Power automate I suggest you change the VBA to Office script, which you can trigger in a Power Automate Flow. See my intro here: https://jkp-ads.com/articles/excel-office-script-call-from-power-automate.asp
JKPieterse
Hello Jan, thank you for your hints collection, i will go through your intro as it is pretty comprehensive info. Hopefully it is not restricted to OneDrive strored files only. Re the logical position of trigger it would be better by the way if it could be in the Excel instances of each user instead of one PAD instance (practically via a technical account). Eg if 10 concurrent user has 9 files open then PAD should be triggered 90x times sequentially while each Excel instance (or simply user) only 9x times but parallel. Again thanks for your tips i will be surely able to combine them with my future projects!
Hello Jan, thank you for your hints collection, i will go through your intro as it is pretty comprehensive info. Hopefully it is not restricted to OneDrive strored files only. Re the logical position of trigger it would be better by the way if it could be in the Excel instances of each user instead of one PAD instance (practically via a technical account). Eg if 10 concurrent user has 9 files open then PAD should be triggered 90x times sequentially while each Excel instance (or simply user) only 9x times but parallel. Again thanks for your tips i will be surely able to combine them with my future projects!