topic Re: activate specific sheet in excel? in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/activate-specific-sheet-in-excel/m-p/794010#M40289 <HTML><HEAD></HEAD><BODY><P>Hi Evan</P><P></P><P>If you are using SAP DOI (Desktop Office Integration) you can use the method John mentioned at the thread pointed by Subramanian.</P><P>If you are using pure OLE, you can use this:</P><PRE><CODE> FORM activate_sheet USING ip_sheet . CALL METHOD OF gs_excel 'Worksheets' = gs_actsheet EXPORTING #1 = ip_sheet . CALL METHOD OF gs_actsheet 'Activate' . ENDFORM . </CODE></PRE><P></P><P>Hope this helps...</P><P></P><P>*--Serdar</P></BODY></HTML> Mon, 06 Dec 2004 22:58:17 GMT ssimsekler 2004-12-06T22:58:17Z activate specific sheet in excel? https://community.sap.com/t5/application-development-and-automation-discussions/activate-specific-sheet-in-excel/m-p/794008#M40287 <P>Good Day to ALL!</P> <P>I patterned my program in RSDEMO1(Download to Excel)and it goes well except the active Excel sheet is "Sheet1" by default)</P> <P>The requirement is when my data reaches 11 records, i want it to write in "Sheet2"?</P> <P>How can i activate the next sheet? </P> <P>How can i go back to previous sheet?</P> <P>Any sample codes can help...</P> <P>THANKS...</P> Mon, 06 Dec 2004 06:09:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/activate-specific-sheet-in-excel/m-p/794008#M40287 Former Member 2004-12-06T06:09:52Z Re: activate specific sheet in excel? https://community.sap.com/t5/application-development-and-automation-discussions/activate-specific-sheet-in-excel/m-p/794009#M40288 <HTML><HEAD></HEAD><BODY><P>Refer this:</P><P></P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="133227"></A></P><P></P><P>Regards,</P><P>Subramanian V.</P></BODY></HTML> Mon, 06 Dec 2004 06:23:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/activate-specific-sheet-in-excel/m-p/794009#M40288 Former Member 2004-12-06T06:23:57Z Re: activate specific sheet in excel? https://community.sap.com/t5/application-development-and-automation-discussions/activate-specific-sheet-in-excel/m-p/794010#M40289 <HTML><HEAD></HEAD><BODY><P>Hi Evan</P><P></P><P>If you are using SAP DOI (Desktop Office Integration) you can use the method John mentioned at the thread pointed by Subramanian.</P><P>If you are using pure OLE, you can use this:</P><PRE><CODE> FORM activate_sheet USING ip_sheet . CALL METHOD OF gs_excel 'Worksheets' = gs_actsheet EXPORTING #1 = ip_sheet . CALL METHOD OF gs_actsheet 'Activate' . ENDFORM . </CODE></PRE><P></P><P>Hope this helps...</P><P></P><P>*--Serdar</P></BODY></HTML> Mon, 06 Dec 2004 22:58:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/activate-specific-sheet-in-excel/m-p/794010#M40289 ssimsekler 2004-12-06T22:58:17Z