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
>copy file myfile.dbf to c:\myexcel.xls >>problem is that this generates Microsoft Office Excel 97-2003 Worksheet (.xls)