Community
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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SM37 Program

Former Member

‎2009 Jan 17 4:44 AM

0 Likes
266

Dear Members,

I have got a part of requirement.Can some one help me with code ?

I normally monitor jobs in SM37 which are taken from a Excel Sheet.and report the status in the same .

If it si sucessful I will put green colour in excel and if it is cancelled I shall put red colour.

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 ?

Regards,

Varun

1 REPLY 1
Read only

Former Member

‎2009 Jan 20 3:13 PM

0 Likes
241

Hi,

It very well seems possible to me. You will have to write an abap program to handle 3 things.

1. Upload the excel contents to the system temporarily.

2. Call the background processes for each job.

3. Write a module to acces excel sheets using OLE object.

You may not be able to write back to the same excel sheet but the process can be automated.