Is there any way to find out the macro processing status through Powershell?

Question

PowerShell

It is necessary to open an excel file, execute the macro in it, upon completion, open another excel file and execute its macro. There are examples of running a macro, but I can’t find an example, how to understand if the macro has been executed or is still in progress?

Answer 1

As far as I understood from the question, you need:
1) "excel macros return result" -> stackoverflow.com/questions/2781689/how-to-return-...
2) "PowerShell: How to get exit code of a process" -> techibee.com/powershell/powershell-how-to-get-exit...