Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

Re: Win32::OLE and Excel and the Web

by jmcnamara (Monsignor)
on Apr 29, 2002 at 22:22 UTC ( #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),

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.


Comment on Re: Win32::OLE and Excel and the Web
Download Code

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://162942]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (7)
As of 2016-05-31 06:34 GMT
Find Nodes?
    Voting Booth?