Bypass or skip popup message in LO macro

[tiger]

Hello Folks, I am creating macro and It will work through (linux service) atomized service , and Input file is downloaded from Google drive, when I run macro Its getting one popup "This file contains links to other files.Should they be updated?" If I click yes or no then macro will run successfully
How Can I skip this message and run macro without any poppup box, Do we can any changes in libreoffice to avoid this kind of messages
Note : File has VLOOKUP already in one column within file, If I remove that lookup then message will not comes up but unfortunately I can't do that because that column data is very crucial and I really don't know from where it's taking that data
So It would be good that any expert can help here to resolve this issue
please check attached file and snapshop of popup message
Than You in advance

[Zizi64]

1.: Check the link in the Edit - Links menu item.
2.: Be sure, that you do not need the data linked from the another file.
3.: Check the cells what referenced to the another file, modify the formulas to local data.
3.: Delete the link/s/.
4.: Save your document into the native, International Standard ODF (.ods) fileformat.

[Villeroy]

Edit>Links is disabled for foreign file formats.
An option under Tools>Options>Calc>General controls this behaviour (update links always|never|ask).

[EU-Import]

The answers try to prevent the dialog box to appear, but that wasn't the question. The question is: how is it possible to skip or bypass this popup? Does anyone has the answer to that?

Thanks!

[RusselB]

Once the pop-up/message is on your screen, I don't believe there's any way around it, since the file you are trying to open for viewing and/or editing won't know if the links that are in the file need to be updated or not unless you respond to the question.

[RoryOF]

Check ExternalDocLinks in the API; also a Forum search for that term might be helpful.

[JeJe]

EU-Import - you might have to resort to an external application to simulate a press on one of the two buttons - as you're on Windows something like AutoIt perhaps.

You can use Windows Api calls to simulate a mouse click or key press from OOBasic - but the problem would be whether or not all macro code stops executing when the message box is shown. If so you wouldn't be able to do it - even if the code to make the mouse click or keypress was run on a timer.

[Villeroy]

May be this thread suffers from a misunderstanding. It is impossible to stop OpenOffice from asking questions about updating external links, regardless of what you set in Tools>Options>Calc>General>Update Links. Every time you open a spreadsheet document with certain types of links, you will be prompted.

The Calc component of https://libreoffice.org/ does not show this behaviour. LibreOffice does not show any prompt on loading when you set the option to "always" or "never".