Powerbuilder Excel chart problem accessing ole control to excel using datawindow

[tek2014]

I have a problem with the following code.I have to show Excel graph inside powerbuilder (pfc) for that I have placed an ole control inside datawindow then designed MS excel chart and the from a function I am setting value of the excel cells and accordingly graph changing and I have placed this datawindow inside a tabpage.but when I am clicking button (calls graph calculation function) on top of tabpage have this datawindow graph function exactly working fine...but same function when I am calling from the window where I am putting tabpage it giving error (Type mismatch accessing external object property worksheets at line 1005 in function wf_calculate_cementblend() of object uo_projecttab.....)


tabpage_psl_cement.dw_graph.object.ole_1.object.worksheets("Sheet1").range("A3").value=2000.

 

[thekl0wn]

As a quick test, try changing to .value='2000'.