>>>DO xls_import >>> >>>FUNCTION xls_import >>> >>> >>>PARAMETERS tcFile >>>** Replaces VFP Import Command for XLS. VFP Command does not accept xlsx file formats >>>** First try the standard import. >>>** If it failes with error code 1661 (Microsoft Excel file format is invalid.) then open Excel and resave with format 39( xlExcel5, xlExcel7 ) >>>** Try to import again. >>>** If it succeeds, return the name of the table >>>** If it still fails, return an empty string. Calling program will check for EMPTY() to determine success >>> >>>LOCAL lcReturn,lcNewFile >>>lcReturn = "" >>> >>>TRY >>> IMPORT FROM ("c:\colin.xlsx") XLS >>> lcReturn = DBF() >>>CATCH >>> =AERROR(abcde) >>> IF abcde[1] = 1661 >>> tmpoxl=CREATEOBJECT("excel.application") >>> tmpoxl.DisplayAlerts = .F. >>> tmpoxl.Application.WorkBooks.Open(tcFile) >>> lcNewFile = "c:\tempdl\" + JUSTFNAME(tcfile) >>> tmpoxl.activeworkbook.saveas(lcnewfile,39) >>> tmpoxl.quit >>> tmpoxl= .null. >>> TRY >>> IMPORT FROM (lcnewfile) xls >>> lcReturn = DBF() >>> CATCH >>> ENDTRY >>> DELETE FILE (lcnewfile) >>> ENDIF >>>ENDTRY >>>RETURN lcReturn >>>