When it comes to Office-automation, i normally just do small parts of the job per hand, while monitoring that via the macro-recorder. I then identify the critical parts (The makro-recorder is very talkative) of the macros and convert that to perl.