in reply to Creating desired number of worksheets in excel
Have you read Using Win32::OLE and Excel - Tips and Tricks? It contains many helpful tips, and also how to find the Excel methods within the Excel documentation.