![]() ![]() ![]() Unless there is a way to unlock excel while waiting for SAP. I am thinking that inserting this Timeout function in 3 specific "problem spots" in the code will suffice. So it may have to be some type of external program or Library or something which is launched before the script call, that Windows OS can run and handle the timeout and end tasks if we dont sent a Kill command after SAP successfully executes the transaction. The challenge is that during an OLE activity, Excel doesn't continue processing code. They occur normally in 3 situations: (a) when pasting into SAP, (b) when exporting SAP to a spreadsheet, (c) when waiting for results of an Execute call. I need to automate this whole process with a Timeout so I can simply "start over fresh" when these freezes occur. Then Excel immediately unlocks and gives the standard End/Debug window. ![]() The only way to unlock it is to End Task of all open SAP Sessions and then after that, also End Task of the SAP Logon window. Sometimes the Client freezes during SAP scripting events, and Excel is typically "locked" in an OLE call. (1) Need to be able to set a configurable duration Timeout, when calling an SAP GUI scripting method with Excel VBA. Need 2 advanced things in Excel VBA for SAP Scripting. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |