ODBC Connection to OPEN Workbooks

Sorry if this is a dumb question.

I have a workbook that uses an ODBC connection to multiple workbooks and pulls in the data from all separate tables into a single table creating a master log.

The problem I have is if any of the Workbooks are open when fetching the data it creates an error.

I've built in an error check which outputs at the end to a messagebox showing what file was open but I would really like to just fetch the data from the Open files from a Read only point of view and stop the need for the error check.

Is this possible?

The code below

Please Login or Register  to view this content.

Thanks in advance for any help