PLEASE DISREGARD THIS POST. I WAS POSTING AN INCORRECT RESPONSE
No, all the app does (or at least Ps3RemoteSleep) is to put your remote back to sleep mode. You still need EventGhost to receive and interpret the events. I'll give you a short tutorial on how to use EventGhost. It might not be entirely accurate since I myself only recently started using EventGhost.
So... first, in EventGhost, add a plugin. There is a plugin for the PS3 BD Remote Control. When you add it, you get a dialog where you select the bluetooth device (Usually "BD Remote Control). Oh, make sure you have paired your remote before doing this.
OK, so after doing this, you should see items appearing in your log in EventGhost every time you press a button, e.g. PS3.Buttons.Left. These are events. Events can be used to trigger macros
So yes, the next step is to define macros. A macro is simply a container for events and actions. So, you could define a macro names "Left". Press the left button on your remote. Drag the PS3.Buttons.Left to your "Left" macro. Now you have an event that will trigger the macro. Next, you can add actions to your macro. For instance, you can add a action Window > Emulate Keystrokes to emulate the left key being pressed on the keyboard. Typically you would define a macro for every single button on your remote and map the remote button to a keyboard key. But yes... it takes some time.
As an alternative, I'll upload my tree. You can
download it and save it as an .xml file and open it up using EventGhost. I'm not at home right now but two things you will need to do to make it work:
1. You will see that the HIDPS3 plugin doesn't work. I use a slightly modified version of the Playstation remote plugin, but you can just delete that plugin and add the standard one that comes with EventGhost.
2. Navigate in the tree to RemoteSleep > Start Program... > Start Program: Ps3RemoteSleep.exe.
Modify this action to point to where-ever you downloaded Ps3RemoteSleep to.
As my tree is currently, pressing the Playstation button will launch XBMC if it isn't already running and show you the current battery level. The timer is set to hibernate the remote control 2 minutes after the last button press. Let me know if you are still struggling.