Skip to Content
Former Member
Mar 27, 2009 at 06:13 AM

SAP OLE to Excel Page Set Up option


I am using sap OLE concept to convert it into excel.. I have use page set up option, But i need to chage the orientation to landscape and change the margin sizes but i am not able to do that with the coding ? to change in this follwing code can any one help to proceed further

CALL METHOD OF h_excel 'ACTIVESHEET' = activesheet.

GET PROPERTY OF activesheet 'PageSetup' = pagesetup.

SET PROPERTY OF pagesetup 'Zoom' = 65.