Re: Win32::OLE, Excel & Subtotals

TotalList => Array(3),

What is Array()? that's your problem - you're attempting to call a function in Perl that you haven't defined yet.

------
We are the carpenters and bricklayers of the Information Age.

Then there are Damian modules.... *sigh* ... that's not about being less-lazy -- that's about being on some really good drugs -- you know, there is no spoon. - flyingmoose

I shouldn't have to say this, but any code, unless otherwise stated, is untested

Comment on Re: Win32::OLE, Excel & Subtotals

Replies are listed 'Best First'.
Re: Re: Win32::OLE, Excel & Subtotals by vida0 (Initiate) on May 26, 2004 at 18:24 UTC
part of the VBA code. Not indispensable thou. The following would accomplish the same thing: `$selection->Subtotal->(GroupBy => 1, Function => xlCount, TotalList => + 3, Replace => "True", PageBreaks => "True", SummaryBelowDate => "Tru +e");` [download] And now the error message is: Win32::OLE(0.1701) error 0x8002000f: "Parameter not optional" in METHOD/PROPERTYGET "Subtotal"	[reply] [d/l]