lol
you are right of course, I just copy & paste the code, and remove second CHR(...) :o)
but that doesn't explain why when Excel is visible it bombs and have no problems when it is not visible.

>>>Hi
>>>
>>>I'm creating an excel spreadsheet and want to adjust the columnwidth to the size of some text.
>>>
>>>the line
>>>
>>>.sheets(lnsheet).Columns(CHR(ncol+64 )+":"+CHR(ncol+64)).ColumnWidth=lncolwidth
>>>
>>>works perfectly if I set excel to be visible.
>>>
>>>But if I set excel to be not visible the same line gives me a type mismatch.
>>>
>>>Any ideas why that is .
>>>
>>>This is excel97 (be 10 years old soon)
>>>
>>>Nick
>>
>>Thsi works for me, BUT I have only Office 2003 installed:
>>

>>LOCAL oExcel AS Excel.Application
>>nCol = 5
>>lncolwidth = 120
>>oExcel = NEWOBJECT([Excel.Application])
>>oExcel.Visible = .f.
>>oExcel.Workbooks.Add()
>>oExcel.ActiveWorkbook.sheets(1).Columns(CHR(nCol+64)).ColumnWidth=120
>>oExcel.Visible = .t.
>>

>
>Boris,
>Might it be ncol > 26? (not asking to you really:)
>I would write as:
>oExcel.ActiveWorkbook.sheets(1).Columns(m.nCol).ColumnWidth = ...
>Cetin