topic Re: SM37 Program in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/sm37-program/m-p/5028264#M1169715 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> It very well seems possible to me. You will have to write an abap program to handle 3 things.</P><P>1. Upload the excel contents to the system temporarily.</P><P>2. Call the background processes for each job.</P><P>3. Write a module to acces excel sheets using OLE object.</P><P></P><P>You may not be able to write back to the same excel sheet but the process can be automated.</P></BODY></HTML> Tue, 20 Jan 2009 15:13:21 GMT Former Member 2009-01-20T15:13:21Z SM37 Program https://community.sap.com/t5/application-development-and-automation-discussions/sm37-program/m-p/5028263#M1169714 <HTML><HEAD></HEAD><BODY><P>Dear Members,</P><P></P><P>I have got a part of requirement.Can some one help me with code ?</P><P></P><P>I normally monitor jobs in SM37 which are taken from a Excel Sheet.and report the status in the same .</P><P></P><P>If it si sucessful I will put green colour in excel and if it is cancelled I shall put red colour.</P><P></P><P>can anyone have code to automate this ? so that if we run the program It should take the job from excel and cehck the status and update the same in excel ?</P><P></P><P>Regards,</P><P>Varun</P></BODY></HTML> Sat, 17 Jan 2009 04:44:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sm37-program/m-p/5028263#M1169714 Former Member 2009-01-17T04:44:01Z Re: SM37 Program https://community.sap.com/t5/application-development-and-automation-discussions/sm37-program/m-p/5028264#M1169715 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> It very well seems possible to me. You will have to write an abap program to handle 3 things.</P><P>1. Upload the excel contents to the system temporarily.</P><P>2. Call the background processes for each job.</P><P>3. Write a module to acces excel sheets using OLE object.</P><P></P><P>You may not be able to write back to the same excel sheet but the process can be automated.</P></BODY></HTML> Tue, 20 Jan 2009 15:13:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sm37-program/m-p/5028264#M1169715 Former Member 2009-01-20T15:13:21Z