Re: Win32::OLE and Excel and the Web

[jmcnamara]

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),

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.