SAP Script: Copy entire column to a variable and paste it in excel

[joystick_sap]

Hi,

I'm tiring to copy a column and paste it into excel. I managed to do it with following code:

'session.FindById("wnd[0]/usr/cntlGRID1/shellcont/shell/shellcont[1]/shell").SelectColumn "DOBJT"
'session.FindById("wnd[0]/usr/cntlGRID1/shellcont/shell/shellcont[1]/shell").SelectedRows = ""
'session.FindById("wnd[0]/usr/cntlGRID1/shellcont/shell/shellcont[1]/shell").ContextMenu
'session.FindById("wnd[0]/usr/cntlGRID1/shellcont/shell/shellcont[1]/shell").SelectContextMenuItemByPosition "0"

the problem is that it won't work if I have more values (not sure but I think the limit is 110. Anyway, I need more than 300 items.How can I solve it?Thank you in advance.

[arroyoweisson]

Hello,

Not sure if this will work as easy as you described. But I would suggest as a work around is to download (save as) the result or row/columns that you are reading then you manipulate the data in excel.

Hope it helps.