"Jack" <replyto@it wrote in message
...
One workbook is opened by the user (independently of my app), second one
is opened by my app.
Jack


That's clear from your post. However, both instances are still trying to
access the same workbook. If you try the same process manually can you do
it without the second instance having only a fixed read-only copy of the
workbook? Automating the second instance doesn't change the fundamental
issue here.

Tim



"Tim Williams" <timjwilliams at gmail dot com wrote in message
...
You can't have the same workbook open in two different instances of
Excel.

Tim

"Jack" <replyto@it wrote in message
...
Hello,
I have a technical problem how to read from XL sheet in the
second task.
Let assume there is Excel spreadsheet already opened on desktop.
My code:
Public WithEvents moExcelApp As Excel.Application
Public WithEvents moExcel2ndTask As Excel.Application

Set moExcelApp = GetObject(, "Excel.Application")
If moExcelApp Is Nothing Then
Set moExcelApp = CreateObject("Excel.Application")
End If
If moExcelApp Is Nothing Then
Debug.Print "Excel app NOT found!"
ExcelApp = 1: Exit Sub
Else
moExcelApp.EnableEvents = True
Set moExcel2ndTask = CreateObject("Excel.Application")
moExcel2ndTask.EnableEvents = True
End If
==================
In Task Manager I can see the second Excel task running.
But it is not bound to the spreadsheet already opened, like moExcelApp
is.
For example:
moExcel2ndTask.Workbooks.Count returns 0
but
moExcelApp.Workbooks.Count returns 1.

What should be done to bind the second Excel task to the already opened
spreadsheet?
What am I doing wrong?
What I need is to be able to read the cell values in the Excel second
task, while not to disturb user using the sheet in primary task (just to
avoid errors while sheet is in edit mode).
Your thoughts appreciated,
Jack