>>

>>IF '12' $ loExcel.VERSION && XL 2007
>>		* Kevin Delaney's suggestion
>>		loExcel.SAVEAS(tcXLSFileName, 39) && 39
>>	* Cetin Basoz suggestion
>>		loExcel.ActiveWorkbook.Saved = .T.
>>		loExcel.ActiveWorkbook.CLOSE(0)		
>>	ELSE
>>		loExcel.SAVE()
>>	ENDIF

>>
>>and it gives me an error "Unknown name"
>>
>>Commenting out SaveAs line doesn't save my formatting.
>>
>>What can we do in Office 2007?
>>
>>Thanks a lot in advance.
>
>You can't save Excel :-)
>You must save WorkBook:
>

>LOCAL loExcel AS Excel.Application
>loExcel = CREATEOBJECT([Excel.Application])
>loExcel.WorkBooks.Add()
>tcXLSFileName = [c:\test.xlsx]
>IF '12' $ loExcel.VERSION && XL 2007
>   * Kevin Delaney's suggestion
>   loExcel.ActiveWorkbook.SAVEAS(tcXLSFileName, 39) && 39
>    * Cetin Basoz suggestion
>   loExcel.ActiveWorkbook.Saved = .T.
>   loExcel.ActiveWorkbook.CLOSE(0)        
>ELSE
>    loExcel.SAVE()
>ENDIF
>

Seems to work now.