Hello Guys,
I created a macro which runs a SAP transaction. The outcome of the transaction is a SAP screen which shows a table. I would like to copy that table and paste it into my active excel sheet. In total I will need the following steps:
1. Run report
2. Select the table/ needed cells in SAP
3. Copy Selection
4. Paste selection
I already did step 1 and 2 and they work. Unfortunately, I don't know the command to copy my SAP selection (3).
My Code:
'call transaction
session.findById("wnd[0]").maximize
session.findById("wnd[0]/tbar[0]/okcd").Text = "/n/SIE/E_P_ORDER1"
session.findById("wnd[0]").sendVKey 0
'entries for dates etc..
.
.
'select data
session.findById("wnd[0]/usr/cntlGRID1/shellcont/shell/shellcont[1]/shell").SelectAll
'copy data (I need help here!)
'paste data
Cells(2,2) = ....
I appreciate any Help!
Thank you,
David
Bookmarks