>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.