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 |
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 |