Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recordset Opening Excel File
When I execute the following statement to query an Excel
workbook, it tells me that the file is read-only, as if the Open method of the ADODB.RecordSet object is trying to open the Excel worksheet. However, it is a SQL query and I thought it would work whether or not the actual workbook was open... RS.Open SQL, ConnString, adOpenForwardOnly, adLockReadOnly, adCmdText The problem is that at my station, the file can be open or closed and this statement works! (note: I am using an add-in file to access a workbook stored on a network drive). However, when a user has it open I get the "Read Only" message. Any thoughts? Thanks, Seth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening a file in Excel starts application but dose not open file | Excel Discussion (Misc queries) | |||
Opening file in Excel 2003 opens multipule instances of same file | Excel Discussion (Misc queries) | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
open range (within workbook) as ado recordset - excel vba | Excel Programming |