Skip to Content
avatar image
Former Member

Sales Order processessing macro

Hi,

I am working on creating macro in excel where the system will get into a list of sales orders to check the load date and under certain condition it will save the sales order. If the condition is not satisfied it will come out from the sales order without saving.

I am facing a weird situation in which certain orders have 2 pop-ups and certain orders have only one pop-up, in which we need to hit enter.

My macro works only when the sales order gives only one pop-up and it does not work when there are two pop-up for which we need to hit two enter buttons.

Can any one please help me how to fix this issue?

I am working in SAP CPO (SNC), version 7.2

Please help me

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 17, 2011 at 01:50 PM

    Hi Jegatheesh,

    welcome to the forum. I would start with a case containing both pop-ups. In the second pop-up I would try the following:

    For example:

    . . .
    on error resume next
    err.clear
    session.findById("wnd[0]/tbar[0]/btn[0]").press
    'if not err.number = 0 then 
    '. . .
    'else
    '. . .
    'end if
    on error goto 0 
    . . .
    

    Regards,

    ScriptMan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 02, 2012 at 05:33 AM

    Hi,

    Can anyone help me to record a macro for creating a sales order for entry into SAP from Excel to SAP.

    - Chandan

    Add comment
    10|10000 characters needed characters exceeded