In a shared workbook that on startup contains only empty workbooks. At runtime [Sheet1$] is populated on the fly. However after this I try and establish an ADO connection using the Jet engine and peform a SELECT * FROM [Sheet1$]. My select statement cannot find any records on [Sheet1$] even though I can see them on the sheet.
This code will work fine on non-shared copy of the workbook.
Help would be very welcome. Thanks.