SAP scripting rowcount of spool list

[nguyen_huynh]

Hello,

I am looking for the right code for adressing the rowcount of a spool list. e.g. I have sent an SE16 search in background job and would like to read the spool result into VBA.

n = session.findById("wnd[0]/usr/tbl/TABLE).rowcount    '---> does not work

Thanks for help. Nguyen

[holger_khn · Accepted solution]

Hello. My suggestion is:

1. download the spoolfile with FM 'RSPO_DOWNLOAD_SPOOLJOB'
2. Read the file with FileSystemObject

I guess you have this spool not in foreground afterwards. Or is it in foregound when background job is done?

[nguyen_huynh · Accepted solution]

Hi Holger, thanks for nice tip. But I need to use RFC technology to perform your suggestion, I would like to stay in scripting. Thanks Nguyen

[holger_khn · Accepted solution]

Hello. Include RFC-call in your scripting and proceed from there to read it. You have no other option as spool is stored as file.

I prefer to perform this from EXCEL or MS ACCESS VBA as I can store result value direct into an worksheet or database.