hi,
baan code as below

Session : xxibd0102s100
Sub-session: xxibd002
Field ext.: .prcl
BPN ext.: .item.segment.2

i am able to update if it is a textbox value.
but this is a checkbox in baan.
how should i write the code?

or any example related to tick a checkbox which update by excel into Baan ?

Exactly how are you doing the updates? AFS code? - if I was using afs code I would just use stpapi.put.field("session","field",str$(tgyenox.yes)). I don't recall do this, but that is where I would start. I do not know if this relevant or not.