VBA script for SAP Client - code fix or optimization help

I have some Code I wrote in Microsoft Visual Basic for Applications (VBA) within an Excel Spreadsheet. The Code interfaces with SAP 740 in the same capacity that a .VBS file would if you Recorded it with SAP's in-built recorder. The difference is that I've expanded upon it, adding dynamic data inputs and I then post-process the results further within Excel and generate reports. Essentially, my code is simply performing automated motions that somebody could click on their own if they wanted to spend the time doing it. I'm saving time by automating those clicks and inputs and post-processing and report generation. The code is working well. My problem is that SAP Client will sometime "hang" or "freeze" after a while, usually on Code which is running multiple actions sequentially. Or multiple reports back to back. I have to then "End Task" of the SAP Logon and the SAP Active Windows in order for Excel to "unfreeze" and then it shows me the typical error message and the END or DEBUG buttons we are familiar with. I then hit END, and then re-launch my SAP Client, and start my VBA Code over again. I hope it doesn't crash the next time. Often it doesn't. Sometimes it does again. My request with this project is to have you provide guidance or Optimize my VBA Code so that it no longer crashes SAP. Alternatively, to Code a way to force close SAP if it detects that its frozen and re-launch it automatically. This will require some back-and-forth and perhaps will take multiple days or weeks to accomplish because I cannot provide you access to my company's server and so you will not be able to test anything in real time. All you will be able to do is Chat/Email with me and I can show you my Excel File and then I can apply your recommended fixes, test it later on my own, and get back to you with the results. I can record videos of what is happening and share them. But absolutely no proprietary or confidential information will be shared so your access and insight into the specifics will be limited. I am mostly looking for somebody who knows already after reading this far, exactly how to fix my issue and can simply pass along that knowledge. I am proficient with VBA scripting, at an Intermediate level I would say. 100% self taught however. Thank you!