Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
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 taking refuge in the Monastery: (10)
As of 2015-07-29 08:26 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (261 votes), past polls