Avatar of AndrewBanfer
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\SCREEN 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
Visual Basic Classic

Avatar of undefined
Last Comment
GrahamSkan

8/22/2022 - Mon
GrahamSkan

Have you tried opening the file in your current version of Excel and saving so that it is in a compatible format?
ASKER
AndrewBanfer

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,

ASKER CERTIFIED SOLUTION
GrahamSkan

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Your help has saved me hundreds of hours of internet surfing.
fblack61