P
PO
Excel 2003, sp2
Hi,
I'm using an add-in to create a report. The report is put together with data
from a few named ranges in a hidden excel worksheet. Below is the relevant
code that's in a standard module in the add-in.
Dim wkbData As Excel.Workbook
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sFileConnectionString As String
Dim sFilePath As String
Set wkbData = ActiveWorkbook
sFilePath = wkbData.FullName
sFileConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & sFilePath & ";Extended Properties=""Excel
8.0;HDR=Yes"";"
Set cn = New ADODB.Connection
cn.Open (sFileConnectionString)
Set rs = New ADODB.Recordset
... more code to generate report
Everything works fine as long as I use 1 instance of Excel. As soon as I
have two instances (each with a copy of the data workbook) "cn.Open
(sFileConnectionString)" opens a copy of sFilePath in the 2nd instance in
read-only mode. After that the code starts to mix the data from the two
workbooks.
Isn't each Excel instance isolated from all other instances?
Any ideas?
Pete
Hi,
I'm using an add-in to create a report. The report is put together with data
from a few named ranges in a hidden excel worksheet. Below is the relevant
code that's in a standard module in the add-in.
Dim wkbData As Excel.Workbook
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sFileConnectionString As String
Dim sFilePath As String
Set wkbData = ActiveWorkbook
sFilePath = wkbData.FullName
sFileConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & sFilePath & ";Extended Properties=""Excel
8.0;HDR=Yes"";"
Set cn = New ADODB.Connection
cn.Open (sFileConnectionString)
Set rs = New ADODB.Recordset
... more code to generate report
Everything works fine as long as I use 1 instance of Excel. As soon as I
have two instances (each with a copy of the data workbook) "cn.Open
(sFileConnectionString)" opens a copy of sFilePath in the 2nd instance in
read-only mode. After that the code starts to mix the data from the two
workbooks.
Isn't each Excel instance isolated from all other instances?
Any ideas?
Pete