We have added search box. Key in SAP issue keyword to search

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-log-mm] SAP GUI Scripting and Excel

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Reply from Hee_Lee on Aug 2 at 10:21 AM

Just change where the start and end date showing on the script, for example:

session.findbyid("objectid").text=" 12/2/2017"

change it to

session.findbyid("objectid").text=thiswo rkbook.range("A1")

---------------Original Message---------------
From: Mark-Doucette
Sent: Tuesday, March 07, 2017 6:58 PM
Subject: SAP GUI Scripting and Excel


I want to run a report in SAP that has a start and end date. I created the script with GUI Scripting. I have copied that script into a macro in Excel. It runs fine when I trigger the macro in Excel. However the start and end dates are fixed in the script. What I want to do is have the start and end dates in the Excel sheet and have the macro pass those from Excel to SAP to run the report. Can anyone help me?


Reply to this email to post your response.
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
© 2017 Ziff Davis, LLC. and message author.
Ziff Davis, LLC. 28 E 28th Street New York, NY 10016
Mark as helpful
View this online
Ask a new question
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements



Post a Comment

T r a n s l a t e to your language