If the connection remains open the workbook will be locked and can't
be opened, so ensure you are closing your connection with oConn.Close.
Is this the behavior you are getting or is the workbook opening
'visibly'?

--

"Chris Edwards" wrote in message ...
I am using ADODB to read data out of another excel file.
Sometime the line "oConn.Open XLFile" actually causes
excel to "OPEN" the referenced document - when it is
soposed to just open it as a data source.
I am using the microsoft example source code (see below)
for doing this. This issue is not consistantly re-
produceable.

Any Ideas?

-Chris
(code follows)

Dim XLFile As String
XLFile = "\\fls02\apps\available Packages.xls"
Dim oConn As New ADODB.Connection
oConn.Provider = "Microsoft.Jet.OLEDB.4.0"
oConn.Properties("Extended Properties").Value = "Excel
8.0;ReadOnly=True;FirstRowHasNames=False;HDR=NO"
oConn.Open XLFile