cancel
Showing results for 
Search instead for 
Did you mean: 

EPMLINK in conditional formula

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member186498
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Roberto:

   I supposed, I mean " I can NOT navigate to PATH/FILE.xlsm", but I think you understand correctly what I want to say.

  Thanks a lot Roberto, I´ll try to code macro to open file with OpenSpecificDocumentByModule(....)

Abel

Answers (0)