When I open an Excel ODBC connection, I cannot edit the Excel sheet in
Excel. Excel reports that the "filename is locked for editing"
If I open the Excel sheet before the code executes then everything works
okay and the connection appears to be read only.
Does anyone have any ideas ?
In Excel try clicking on Tools...Share Workbook and make sure the "Allow changes by more than one
user at the same time" option is selected.
I seem to recall that Microsoft does not recommend concurrent access via Excel and the Data Access
methods (DAO, ADO, etc.).
Paul ~~~ XXXX@XXXXX.COM
Microsoft MVP (Visual Basic)