2008 Jul 07 3:03 PM
Dear All,
I want to Upload multiple journals via Excel file into SAP.
Will you please let me know how to do this, it would be greatfull if you can send some code.
Thanks in Advacne,
Ramana
2008 Jul 07 3:12 PM
Hi,
use your "normal" upload and after OPEN set this:
Set First Workdsheeet
CALL METHOD OF H_EXCEL 'Worksheets' = H_WORK EXPORTING #1 = 1.
PERFORM ERR_HDL.
CALL METHOD OF H_WORK 'Activate'.
PERFORM ERR_HDL.
Hope it helps.
Regards, Dieter
Dear All,
I want to Upload multiple journals via Excel file into SAP.
Will you please let me know how to do this, it would be greatfull if you can send some code.
Thanks in Advacne,
Ramana
2008 Jul 07 3:12 PM
Hi,
use your "normal" upload and after OPEN set this:
Set First Workdsheeet
CALL METHOD OF H_EXCEL 'Worksheets' = H_WORK EXPORTING #1 = 1.
PERFORM ERR_HDL.
CALL METHOD OF H_WORK 'Activate'.
PERFORM ERR_HDL.
Hope it helps.
Regards, Dieter
2008 Jul 07 6:33 PM