When opening an Excel 5.0/95 Workbook in Visual Basic 6.0 I get an error "External table is not in expected format". This happens when I attempt to open the file through a Data connection on a Form.
I set the Connect = "Excel 5.0;" or "Excel 8.0;" or "Excel 4.0" or "Excel 3.0"
Database = "C:\MWWSSB\New Instruments\Dionex_IC\SCRE
EN MAY 5, 2008.SEQ\10.XLS"
Recordsource = "Sheet1$"
None of the Connects work. Is there a way I can do this in the code or a different connect string to open the file without an error?