I'm trying to capture SAP EPM schedule statistics (which user is opening which EPM report and when?). The way I'm doing this is via application events in Excel VBA (I have followed Chip Pearson's tutorial on this subject).
The VBA code I have implemented does the following:
VBA code is attached to this question.
I've noticed that, when I open an EPM schedule using EPMPathlink function, the VBA code IS NOT invoked. When I open an EPM schedule using OpenSpecificDocument the VBA code IS invoked (and works as intended).
My question is:
Is there a way to capture the EPMPathlink event?
Many thanks in advance for your input.