Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

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.

--
John.


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

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (9)
As of 2014-12-26 19:26 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (174 votes), past polls