This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Get a cell value from an excel in M-Files

Hi there

Did anyone find a solution to get a value from an Excel cell that is saved in M-Files without the name in it? Its a request from one of our clients.

If I open both Excels and link one cell with '=' to one cell of the other file, this happens and it works:

='M:\Faigle Solutions\ID2\C6B72A29-815A-4FAD-ACCD-2E1B8C7FAF75\0\32000-32999\32373\L\L\[Source (ID 32373).xlsx]Tabelle1'!$A$1

But I want that link to be with the object id / GUID and not with the name/title. If someone change the title, the link is invalid.

I tried with this:

='m-files://show/C6B72A29-815A-4FAD-ACCD-2E1B8C7FAF75/0-32373?object=453579B3-406A-43F7-9434-F741B0A6ED69'Tabelle1'!$A$1

but that doesnt work. Also tried with [] and other syntax ideas, but nothing works, because Excel says its not a formel or it has no "relation".

='m-files://show/C6B72A29-815A-4FAD-ACCD-2E1B8C7FAF75/[0-32373?object=453579B3-406A-43F7-9434-F741B0A6ED69]Tabelle1'!$A$1

Does anyone got an idea how to solve that?

Thanks!