Excel VBA独立打开SAP事务,不受Excel控制 [英] Excel VBA open SAP Transaction independently without controlled by Excel
问题描述
我有一个要求,我需要独立打开sap登录和打开交易作为一个单独的应用程序,以便用户可以切换 之间和两个应用程序之间的工作
I have a requirement where I need to open sap logon and open transaction independently as a saperate application so that user can toggle between and work on both applications
到目前为止,我已成功通过sap脚本打开sap事务但是在执行sap脚本时我无法在excel中执行任何操作它已被锁定并且在执行sap应用程序之后关闭和焦点转移到excel再次,但我的要求是在两个应用程序之间同时切换
。
I have succeeded so far opening sap transaction via sap scripting but while sap script executing I am not able to do anything in excel it's locked and after execution sap application is closing and focus shift to excel again, but I my requirement is to toggle between both applications same time.
--- ----------------代码-------------------------
-------------------Code-------------------------
推荐答案
您好Aayushi_Singh,
Hi Aayushi_Singh,
因为单个Excel中的Excel线程进程应用程序,代码会阻塞 Excel线程并使Excel在运行时无法使用。它仅限于Excel设计,我认为没有办法解决这个问题。感谢您的理解。
Since Excel in a single thread process application, the code would block the Excel thread and make the Excel unable to use when it is running. It is limited to Excel design and I think there is no way to workaround for this. Thanks for understanding.
最诚挚的问候,
Terry
这篇关于Excel VBA独立打开SAP事务,不受Excel控制的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!