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.
|
|---|
In Section
Seekers of Perl Wisdom