>Hi,
>Can I set the different cell width in SAME column ?
>
>
>oExcel.activesheet.Range("D"+TRIM(PADR(nrow,11))).ColumnWidth = 15
>oExcel.activesheet.Range("D"+TRIM(PADR(nrow,11))).value = rpt012->itmcode
>
>oExcel.activesheet.Range("D"+TRIM(PADR(nrow,11))).ColumnWidth = 40
>oExcel.activesheet.Range("D"+TRIM(PADR(nrow,11))).value = rpt012->desc
>
>
>I found it the result have same column width 40.
>
>Please advise.
>Thanks.
>Derek Yim
AFAIK you can't.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.