Hi

Im running an automated looping presentation on a projector in our
production environment. The presentation runns 24/7.
The presentation links to a series of excel spreadsheets, so that no
one ever edits the presentation.
I have added an add-inn that automatically updates all the links once
pr presentation loop. But here I have a problem.
When the update is running while someone (on another computer) edits
one of the spreadsheets the presentation stops and warns, that someone
else is using the document linked to. Then it asks if I want to notify
the other user or if I want to open a copy (read only).
I always only want to open a copy(read only).
Is it possible somehow to make Excel automatically select this
chioce for me, so that the presentation can run all the time with no
interruptions?


Please help

Hi,

nNot sure if I understood it right but - have you ever tried to use the
OLE-Method "OpenLinks" in you Add-in?
This should exactly solve your issue, when using "True" for the param
"ReadOnly".

Did this help you?

Best wishes,
Eric


" wrote:

Hi

Im running an automated looping presentation on a projector in our
production environment. The presentation runns 24/7.
The presentation links to a series of excel spreadsheets, so that no
one ever edits the presentation.
I have added an add-inn that automatically updates all the links once
pr presentation loop. But here I have a problem.
When the update is running while someone (on another computer) edits
one of the spreadsheets the presentation stops and warns, that someone
else is using the document linked to. Then it asks if I want to notify
the other user or if I want to open a copy (read only).
I always only want to open a copy(read only).
Is it possible somehow to make Excel automatically select this
chioce for me, so that the presentation can run all the time with no
interruptions?


Please help

Hi

Can You be a bit more specific. What is the OLE-method?