Re: Win32::OLE and Excel and the Web


"be consistent"
	PerlMonks

Re: Win32::OLE and Excel and the Web

by jmcnamara (Monsignor)

on Apr 29, 2002 at 22:22 UTC ( [id://162942]=note: print w/replies, xml )

Need Help??

in reply to Win32::OLE and Excel and the Web

It also ran fine on Win98 with Perl 5.005 and Excel 97. Which probably isn't good news. :-|

That type of error usually occurs when the wrong variable type is being assigned to an object property. Something like this might placate the Win2000 COM.

    use Win32::OLE::Variant;
    ...
    'FitToPagesTall'  => Variant(VT_I2, 1),
[download]

As an aside, even if you clear this error FitToPagesWide probably won't have an effect unless you also set Zoom = False since these two properties are mutually exclusive.

--
John.