Besides the examples linked by davies, also try the standard approach when automating excel-stuff: Use The Macro Recorder, Luke (Re: Using Win32::OLE and Excel - Tips and Tricks). It helped me a lot (thanks, Corion!)

HTH, Rata