Combining SAP scripts with Microsoft Excel Macros

Question

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.

Answer 1

I recommend you to read the following page: https://archive.sap.com/discussions/thread/3450067

Particularly interesting for it is from 08.11.2013.

Regards, ScriptMan