>>>Hi everybody,
>>>
>>>Sorry for starting a new thread with the problem.
>>>
>>>I have this code
>>>
>>>

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

>
>Can not believe I was that blind! But I can not test at the moment.


I did :-)
And it works for me.
One thing, when you save the file with 2007 format and you pass extention, just make sure that it is XLSX.