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
...just on a sidenote have a working solution now, however with some compromises:
--PERSONAL.XLSB is running a continuous macro, however with DoEvents, so not blocking the user processes
--every minutes the run of special sheet checker fewliner code is triggered if the overall open worksheet number =INFO("NUMFILE") is not less
--the counter value is taken (like harvesting) by the fewliner frequently but it is also not a problem if the last chunk is staying in a closed file (as the next time opening will take it anyway)
--deleted files (not Shift+Del) can be also sought for counter values later
--it is enough to check all the users' PERSONAL.XLSB by the PAD flow
...just on a sidenote have a working solution now, however with some compromises:
--PERSONAL.XLSB is running a continuous macro, however with DoEvents, so not blocking the user processes
--every minutes the run of special sheet checker fewliner code is triggered if the overall open worksheet number =INFO("NUMFILE") is not less
--the counter value is taken (like harvesting) by the fewliner frequently but it is also not a problem if the last chunk is staying in a closed file (as the next time opening will take it anyway)
--deleted files (not Shift+Del) can be also sought for counter values later
--it is enough to check all the users' PERSONAL.XLSB by the PAD flow