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!!
Bookmarks