Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using ADODB to read data out of another excel file
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using ADODB to read data out of another excel file
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using ADODB to read data out of another excel file
I do close the connection when I am done using it.
The workbook opens "visibly"(and I have it isolated to that one individual line).. Which confuses me as it is a declared object (Dim oConn As New ADODB.Connection) and should in no way open the file.. -Chris -----Original Message----- 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 news:<017101c3c004$a0c7b2b0 ... 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
access database (adodb)from excel vba | Excel Worksheet Functions | |||
Read data from anohter XLS file | Excel Worksheet Functions | |||
Read data from ascii file | Excel Programming | |||
VBA to read data from XL and import into another XL file | Excel Programming | |||
Selective read data from ascii file | Excel Programming |