Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

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 browsing the Monastery: (2)
As of 2020-09-27 09:02 GMT
Find Nodes?
    Voting Booth?
    If at first I donít succeed, I Ö

    Results (142 votes). Check out past polls.