I’m running a macro through powershell and I get this error when the file is too large. Is there a timeout somewhere I can adjust to have the task complete successfully?
To run a VBA macro, try using the new “Excel command” action available in version 5.1 or above. If the problem persists, please post a screenshot of the error.
It will run from Excel without any issue. I have 32-bit Office installed. The file is about 14mb with around 66k rows. If I delete rows and keep around 14k rows it will run successfully.
Hi Andrew, I had the same thought and did try this even adding a delay up to 1 minute, however it still failed. I also tried adding a delay in the macro itself with no luck. Thanks for the suggestion though.
Is it possible for you to share one of those big files that gave you that error and the macros file with us? If so, you can send them to our support email.
Also, please:
Use the “Excel command” action to run the macro and make that the error appear again
Go to menu “About” and press “Diagnostic information.” It will open a dialog with diagnostic information.
Copy contents of both tabs in that dialog and send it to our support email.
Furthermore, is it possible for you to test that script or/and the “Excel command” action that runs the macro in question on a computer that has 64-bit Excel installed?