Opening Excel....

[Guru]

I'm using:

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