See Use The Macro Recorder, Luke (Re: Using Win32::OLE and Excel - Tips and Tricks),the Win32::OLE documentation has Hints for Microsoft office Automation or super search for more infomration.

Also there is no need to SHOUT, your post title is in capitals for some reason.