Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

OLE Class

Former Member
0 Likes
714

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....

1 ACCEPTED SOLUTION
Read only

former_member302911
Active Participant
0 Likes
537

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.

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.

2 REPLIES 2
Read only

former_member302911
Active Participant
0 Likes
538

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.

Read only

0 Likes
537

Hey Thanks a lot...