Calling Office apps from Pipeline Pilot

Hi all -

I tried to run PowerPoint by calling it from a VBScript on Server component and run a macro:
 
set oApp = CreateObject("Powerpoint.Application")
Set oPres = oApp.Presentations.Open("c:\Users\mvn1\Downloads\Role Card Creator v3.pptm")
oApp.Run "CreateAppSlidedeckFromTemplate"
oPres.Close

I'd be interested in seeing examples that show how to catch any errors if the subroutine fails (right now I have to kill the Ppt process).

I'd also be interested in hearing any experiences of calling MS Office apps from a Run Program on Server component.

Thanks - Ton