>>*!* loExcel.ActiveWorkbook.CLOSE(0)
>>*!* loExcel.ActiveWorkbook.Saved = .T.
>>
>>gave me an error ActiveWorkBook doesn't evaluate to an object.
>
>Then you don't have an active workbook:) BTW saved line would come first.
>Cetin

Hi Cetin,

In the DBFToExcel your solution worked perfectly and Kevin's with 39 format didn't. I don't know what other formats to try.

However, I have also a different program called CombineXlsFiles (posted here by Craig Boyd).

I can not use your suggestion as is in this program. The piece I'm trying to make to work is

		IF '12' $ .VERSION && XL 2007
* Kevin Delaney's suggestion
            	* Cetin Basoz suggestion
			loExcel.ActiveWorkbook.Saved = .T.
			.WorkBooks(1).SAVEAS(m.tcDestination) && 39
			loExcel.ActiveWorkbook.CLOSE(0)		
		ELSE
			.WorkBooks(1).SAVEAS(m.tcDestination)
		ENDIF

I can not make this to work so far and this is kind of urgent. Can somebody with Office 2007 please suggest a workaround?

Thanks a lot in advance.