将SAP脚本与Microsoft Excel宏结合 [英] Combining SAP scripts with Microsoft Excel Macros
问题描述
我暗中怀疑此主题已被涵盖，但我没有找到适合我理解的答案，或更确切地说，是我所理解的答案.我仍然在学习很多东西，作为n00b，我还有很长的路要走.我们有一个定制的报告，该报告需要很长时间才能在SAP中运行(两个小时或更长时间).经常出现的问题是，如果我在完成后不尽快对它采取行动，那么整个系统就会对我超时，并且我将失去一切.我的目标是创建一些将运行报告的内容，立即将其导出为Microsoft Excel(XXL格式以与历史记录保持一致)，然后将其保存到共享驱动器上的特定位置.我希望能够在晚上离开时将整个设备运行起来，以便第二天早上在那儿.我不在乎SAP是否在事后超时.我知道如何简单地在SAP和Excel中记录脚本，但是我不知道如何将它们组合在一起.将SAP中的代码简单复制并粘贴到excel中会产生我不理解的错误.
我目前正在与GuiXT一起玩，但是坦率地说，我不知道自己在做什么.任何帮助将不胜感激.
I have a sneaking suspicion that this topic has been covered but I have not found an answer that fits, or more to the point, that I understand. I'm still learning a lot, and as a n00b I have a long way to go.
We have a customized report that takes a very long time to run in SAP (2 or more hours). The recurring problem is that if I do not act on it just as soon as I can after it completes, the whole system times out on me and I lose everything.
My goal is to create something that will run the report, immediately export it into Microsoft Excel (XXL format to remain consistent with historical stuff), and then save it to a specific place on a shared drive. I would like to be able to set the whole thing running when I leave at night so It will be there the next morning. I don't care if SAP times out after the fact.
I know how to simply record a script in both SAP and in Excel, but I don't know how to combine them. A simple copy and paste of the code from SAP into excel generated errors that I don't understand.
I am currently playing with GuiXT, but to be frank, I don't know what I am doing.
Any help would be greatly appreciated.
推荐答案
I recommend you to read the following page: https://archive.sap.com/discussions/thread/3450067
尤其有趣的是2013年8月11日.
Particularly interesting for it is from 08.11.2013.
关于，脚本人
这篇关于将SAP脚本与Microsoft Excel宏结合的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
