Re: Win32::OLE Excel Adding worksheet after last current sheet

I've had success with the following commands:

$worksheet = $workbook->Worksheets(1);
# add a sheet after current sheet
my $new_sheet = $workbook->Worksheets->Add(undef, $worksheet);
[download]

Comment on Re: Win32::OLE Excel Adding worksheet after last current sheet Download Code

Replies are listed 'Best First'.
Re: Re: Win32::OLE Excel Adding worksheet after last current sheet by Anonymous Monk on Nov 05, 2003 at 19:47 UTC
I could see wh the undef is important. But it's still not working. :( I'm using Excel 2000, on Win2K with Activestate perl version 5.8.0. Could one of these be a factor?	[reply]