in reply to I need to copy one sheet to another sheet automatically in one Excel file

Again, as mentioned here and here, the tutorials section is not the place to ask Perl questions. See SoPW. Your example shows no attempt to do what you are asking. See Use The Macro Recorder, Luke (Re: Using Win32::OLE and Excel - Tips and Tricks) for tips for working with Excel using Win32::OLE.