Saving a value as a variable in one app to use in another app

[paul_ripley]

Hello

I have a table in my cost centre report app as below.

There is a long expression to do this calculation so I created this these values as 2 variables, vPEBoardReport and vInfraBoardReport.

I need to use these values in another app but the other app is not related to this app.

Is there any way you can take the values in the this report and link them or import them into another unrelated app?

Thanks

Paul

[juraj_misina]

Hi Paul,

you can set up a button with macro which would store this table into an excel file, which would be consumed by the other app. See Export table to Excel with Macro for an example.

[paul_ripley]

Thanks I will see if I can get this to work