Skip to Content

Need to Open Excel workbook either by VBA code or EPMLINK function

Hello Expert,

I tried to open the excel workbook from EPMlink function but there is problem that my workbook is saved in Team folder (other then WEBEXCEL folder) and "EPMlink" and "EPMPathlink" function only opened the \WEBEXCEL\TEMPLATELIBRARY files.

Kindly help me on this.

Either provide me any VBA code (openexcelworkbook) or any EPM formulla to open Excel workbook from server.

Thanks

Tarun Agarwal

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 19, 2017 at 01:57 PM

    How do you want to open the server workbook - passing some context or simply open?

    To simply open the file for ADMIN team (just a sample) located in REPORTS folder

    use:

    =EPMExecuteAPI("OpenSpecificDocument";"Test";"XXXX.xlsx";"ADMIN";"REPORTS\")

    P.S. Anyway, please search forum for OpenSpecificDocument

    Add comment
    10|10000 characters needed characters exceeded

  • May 19, 2017 at 12:38 PM

    Hi Tarun,

    To open a workbook from server (from any report / template), you can use quick link functionality.

    Thanks,

    Karan

    Add comment
    10|10000 characters needed characters exceeded