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

[Anonymous Monk]

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] fndsxmit.pl: Win32::OLE(0.1501) error 0x80
+020005: "Ty
#pe mismatch"
#[Thu May  9 16:39:02 2002] fndsxmit.pl:     in METHOD/PROPERTYGET "Fi
+nd" argumen
#t "SearchDirection" at fndsxmit.pl line 1350

What am I doing wrong?

[cacharbe]

hmmm. It makes me think that you didn't include the line:

 
use Win32::OLE::Const 'Microsoft Excel'; 


C-.

[Anonymous Monk]

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