Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re: Using Win32::OLE and Excel - Tips and Tricks

by Anonymous Monk
on May 09, 2002 at 20:35 UTC ( #165497=note: print w/replies, xml ) Need Help??

in reply to Using Win32::OLE and Excel - Tips and Tricks

I couldn't get your snippet above to get the outer edges of the rows and columns to work. I get the error
#[Thu May 9 16:39:02 2002] Win32::OLE(0.1501) error 0x80 +020005: "Ty #pe mismatch" #[Thu May 9 16:39:02 2002] in METHOD/PROPERTYGET "Fi +nd" argumen #t "SearchDirection" at line 1350
What am I doing wrong?

Replies are listed 'Best First'.
Re: Re: Using Win32::OLE and Excel - Tips and Tricks
by cacharbe (Curate) on May 10, 2002 at 01:10 UTC
    hmmm. It makes me think that you didn't include the line:
    use Win32::OLE::Const 'Microsoft Excel';

      ah, exactly right. many thanks. I'm continuously amazed and impressed by the Perl community. Dooj

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (9)
As of 2016-10-28 09:58 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (379 votes). Check out past polls.