Me again answering some of the issues in my first problem.
if i open the file the re-save with format number 51 it will save as an xlsx.
is there a way of doing this using the copy method without going through the opening xl method.

k

copy file myfile.dbf to c:\myxls.xls 
oXL = CREATEOBJECT("Excel.Application")
oXL.DisplayAlerts = .F.
oWorkbook = oXL.Workbooks.Open('c:\myxls.xls')
oWorkbook.ActiveSheet.UsedRange.EntireColumn.Autofit
oWorkbook.SaveAs('c:\myXLSX.xlsx', 51) && xlExcel8
oxl.quit

>i am trying to get vfp9 to generate xls (version office 2007) or better yet xlsx
>
>right now i have been getting away with the following
>

>copy file myfile.dbf to c:\myexcel.xls
>

>problem is that this generates Microsoft Office Excel 97-2003 Worksheet (.xls)
>
>We are now experiences problems from some Mac computers which cannot open these files.
>
>Any suggestions??