"Jack" <replyto@it wrote


What should be done to bind the second Excel task to the already opened
spreadsheet?
What am I doing wrong?

GetObject returns an already running object, while CreateObject starts off a
new process. If you want them both to bind to the same object, then you'd
just set the second variable to equal the first.


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,

I don't do that sort of programming, but it was somewhat obvious that
to get at the data in the sheet you'd need to access the desired sheet,
or a copy of it. Instead of creating a new application object, might
you try creating a copy of the original sheet, within the running application?

LFS