on 02-02-2016 4:35 PM
Hi experts:
I have a excell EPM cell with this formula:
IF(A1="AA";EPMLINK("MY_MODEL","PATH/FILE.xlsm";"LINK_TEXT");"NO LINK")
So, when A1 cell contains AA, my cell show LINK_TEXT but when I double-click on it, I can navigate to PATH/FILE.xlsm
Do you can help me?
Thanks in advance,
Abel López
Hi Abel,
what you ask is not possible in this manner, epmlink do not work under excel conditions, you can achieve it using an activeX label that simulate the hyperlink and assigning a macro on click with EPMAddInAutomation.
Regards
Roberto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.