I have to download a report twice day from SAP to Excel. Anybody knows a way to set up automatic download from SAP to excel 2007.
Thanks for your help?
Asked
Active
Viewed 7,995 times
1
-
I would say it depends on the rights you have. If you have just regular user's access then it is a problem, but I am also only a user. It would be probably possible only using AutoIt script or something like that. Also what report, a standard transaction? – Vojtěch Dohnal Oct 26 '14 at 17:11
-
Also there is SAP GUI Scripting http://www.synactive.de/docu_e/specials/guiscripting.html, but in my client it is not visible. – Vojtěch Dohnal Oct 26 '14 at 17:35
-
And a very similar question here http://stackoverflow.com/questions/19452461/vba-pulling-data-from-sap-for-dummies – Vojtěch Dohnal Oct 26 '14 at 17:40
-
Hi VDohnal, I need to download Open delivery report – brownEyes Oct 26 '14 at 23:50
-
It is important to find out, whether you can use SAP scripting or not. http://scn.sap.com/docs/DOC-57020 If the option is disabled in menu and it is not disabled in Options http://community.worksoft.com/Knowledge-Base/Worksoft-Products/Worksoft-Certify-Interface/Certify-SAP-Interface/configuring-the-sap-gui-to-support-script-recording-and-playback.html, then it is not installed and you cannot use it. – Vojtěch Dohnal Oct 27 '14 at 05:02
-
Does your requirement could be to send the excel file to email? – Nelson Miranda Oct 27 '14 at 14:34