>>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