Opening Excel....

I'm using:

VB Code:

Dim oConn As ADODB.Connection
   Set oConn = New ADODB.Connection
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=filename.xls; Extended Properties=""Excel 8.0;HDR=NO;"""

to access an Excel spreadsheet using ADO.

But, if the spreadsheet is open it fails. What do I need to change to access a spreadsheet that it already open?

Thanks

I suspect that you will need to specify the sharing mode in the connection string, otherwise it assumes that you want exclusive access to the file.. after a quick test I have found the following values:

;Mode=Read

;Mode=Share Deny None

The first is most likely to solve it, but means that you will have read-only access. The second will attempt to allow you to write to it as well, but due to the nature of using files as databases I really would not trust it!

Thanks for the suggestion.

I only want to read the file and ";Mode=Read" didn't seem to make any difference

I've looked at the other properties that could be set, but none of them are relevant.. so I don't know what (if anything) can be done. :(