Hi all,
Bit of a weird one here. I have a VBA macro that is designed to bill credit cards that appear on an Excel Sheet in a few steps:
1. Gather all the necessary data which appears on 2 different sheets in the active workbook
2. Call a Python script to do all the API calls with the credit card service we use
3. Read the output of the Python script and update the Excel sheet with the information in the output
The code is correct; it does exactly what I want it to do. However, it starts to get slower as I run it again-and-again. Around 50 times running the same macro without changing anything, it starts to get noticeably slow. Then after about 100 times, the code doesn't even run and gives me an error "Can't execute code in break mode" (See attached screenshot). Any ideas about what could be causing the issue? I can post the code if requested.
Bit of a weird one here. I have a VBA macro that is designed to bill credit cards that appear on an Excel Sheet in a few steps:
1. Gather all the necessary data which appears on 2 different sheets in the active workbook
2. Call a Python script to do all the API calls with the credit card service we use
3. Read the output of the Python script and update the Excel sheet with the information in the output
The code is correct; it does exactly what I want it to do. However, it starts to get slower as I run it again-and-again. Around 50 times running the same macro without changing anything, it starts to get noticeably slow. Then after about 100 times, the code doesn't even run and gives me an error "Can't execute code in break mode" (See attached screenshot). Any ideas about what could be causing the issue? I can post the code if requested.
