Sales Order processessing macro

[Former Member]

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

[Former Member]

Hi,

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

- Chandan

[script_man]

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