http://qs321.pair.com?node_id=304860


in reply to Win32::OLE Excel Adding worksheet after last current sheet

You are so close!

To use named parameters, you need to use a hash reference. This line uses a reference to an anonymous hash:

my $Sheet2 = $Book->Worksheets->Add( {after =>
           $Book->Worksheets($Book->Worksheets->{count})} );

[download]

In Section Seekers of Perl Wisdom