AndrewBanfer
asked on
Opening Excel 5.0/95 Workbook files in Visual Basic 6.0 I get an error "External Table is not in the expected format"
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?
10.XLS
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
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?
10.XLS
Have you tried opening the file in your current version of Excel and saving so that it is in a compatible format?
ASKER
Graham,
The Excel file comes from an analytical instrument and we want to open the file as it comes off the instrument in it's native format.
Thanks,
The Excel file comes from an analytical instrument and we want to open the file as it comes off the instrument in it's native format.
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.