OLE Class

[Former Member]

Hi Gurus,

Was going through the OLE Excel creation and data population wherein,the below code was present

• Create first Excel Sheet

CALL METHOD OF application 'Worksheets' = sheet

EXPORTING #1 = 1.

Wanted to know what is the OLE Excel creation original base Class and its corresponding methods.....

What does this #1 signify?

Waiting for your replies....

[Former Member]

Hi Gurus,

Was going through the OLE Excel creation and data population wherein,the below code was present

• Create first Excel Sheet

CALL METHOD OF application 'Worksheets' = sheet

EXPORTING #1 = 1.

Wanted to know what is the OLE Excel creation original base Class and its corresponding methods.....

What does this #1 signify?

Waiting for your replies....

[former_member302911]

For methods go into Excel -> Tools...Macro...Visual Basic Editor

Now Press F2 for Object Viewer -> Find "Worksheets"

#1 - Correspond to First Exporting Parameter (#2...#n if there are more than 1 parameter)

For your aknowledgement ... check examples over inrternet or Forum Sap, about ABAP OLE EXCEL.

Regards,

Angelo.

[Former Member]

Hey Thanks a lot...