I have a process that runs an Excel macro in different files.
The process works well except that in some cases the excel file is considerably large and the macro takes longer than expected. This causes the process to break as the process continuous before the Excel macro is completed.
I’m thinking that maybe capturing the file size I can add a condition where if the file is a certain size then I will add a time delay and resolve the problem.
What activity I can use to capture the file size?