I converted an add-in from excel 2003.

The add-in uses DAO to retrieve recordsets from several workbooks - now .xlsx files

The workbooks are opened as "read-only" if the user is not authorised to update. They are also opened as "read-only" if another user is using the system.

When the files are opened as read-only = FALSE I have no problem However...

When they are opened as read-only = TRUE the opendatabase command fails with "external table is not in the expected format"

The line that fails reads... set sb = opendatabase(source,False,False,"Excel 8.0")

I tried changing to "Excel 12.0" but then I got "could not find installable ISAM"

Is there a solution for this without switching from DAO? ( I have a lot of code to change if DAO is not suitable)


Any help very much appreciated as I am tearing my hair out!!