VBA OpenSpecificDocumentByModule - How to use it?

[Former Member]

dear BPC Gurus

Under FPMXLClient.EPMAddInAutomation class, there is a member called "OpenSpecificDocumentByModule".

Until today this member is still a mystery to me and I cannot find much help online on it.

I'm planning to use it to open some documents in Server Root folder. I tried EPMLink formula before but I didn't like it because it has to refresh each sheet after opening it.

OpenSpecificDocumentByModule(module As String, subModule As String, TeamId As String, subFolder As String, documentName As String, resourceId As String, [connectionString As String])

I'm not sure what are Module, subModule and resourceId....

Can anyone guide me on this?

From "EPM Add-in for Microsoft Office User Guide 10":

[former_member186338]

Hi Edmund,

If you open file from root folder you will see:

WEBEXCEL\TEMPLATELIBRARY\

WEBEXCEL - module

TEMPLATELIBRARY - looks like submodel

resourceId - no idea

Vadim

P.S. Try with empty strings

[former_member225135]

Hi Edmund,

As mentioned in HELP, this  API will open files saved in the "documents" folder in BPC web

https://www.column5.com/blog/epm-execute-api

Regards,

Rahul