
Pre-opened 20 independent Excel VBA files (not opened by PA), and it takes ten to twelve minutes to start them manually for backtesting, but it takes a very long time to automatically start them with PA, and the tenth one has already spent Forty minutes (as shown in the picture), it cannot be operated at all.
I found that when the VBA operation is in progress, the PA process will slow down. If there are too many VBA files in operation, the PA process will almost freeze, as shown in the red dot. Is this a defect?
Hi @alee001
It's always recommended to use one VBA file and do your operations and closed the excel then the next VBA file
If you find this reply helpful, please consider giving it a LIKE
If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION
Thanks,
Srini