Re: Win32 PPT finding max value in range of embedded worksheet

2004-01-07 Thread Mike Jackson
you'd be better off searching the mskb or msdn for this - perl merely autoloads all the OLE functions it finds available - it doesn't have them remembered anywhere. you may find its something like ...->exec('Max(B3:O3)') or call or something odd like that.. remember that perl is case sensitive!

Win32 PPT finding max value in range of embedded worksheet

2004-01-07 Thread Lance Hoffmeyer
Anyone have any idea how I can find the maximum value in a range (B3:O3)? The only way I can think of would be to write a formula in another cell and compare this value to each of the values in B3:O3. There has to be a better way but darn if I can think of it. Something like: my $r1 = $wsheet->Max