I have written Version 1 of an excel application with an expiry function built in that closes the workbook if opened on or after the expiry date. The application has been distributed to users and is password protected.

I have now written version 2 of this application and have introduced an import function where certain data can be imported from version 1 into version 2.

However, because the workbooks are password protected the only way I can import the data using vba is by opening Version 1 and applying the unprotect password and then copying and pasting the data. This works fine when Version 1 isnt expired.

The problem is, if Version 1 has already expired then I can't import the data as the workbook shuts down.

Is there any way I can reference a closed password protected workbook using ADO?