hi ALL ,
THe com object viewer is giving this syntax :
[ Com-Handle-Var = ] <com-handle>: Add (
Com-Handle-Before ).
the excel macro is giving this :
ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell .
can someone help me in writing this in 4gl code .
Do what the COM object viewer tells you. Of course you first need a COM-HANDLE to the HPageBreaks collection (whatever that is) and one to whatever it is you're trying to add.
thank you laura for your answer ,
hExcel:Worksheets("Sheet1"):cells(rowi,coli):SELECT .
hExcel:Worksheets("Sheet1"):HpageBreaks:ADD( ).
the above syntax is giving error ."wrong number of parameters ....." .
what argument should i put .
how to specify the second com handle .
so can u give me some code ........