Re: Using Win32::OLE and Excel

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
[download]

What am I doing wrong?

Comment on Re: Using Win32::OLE and Excel - Tips and Tricks Download Code

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';` [download] C-.	[reply] [d/l]
Re: Re: Re: Using Win32::OLE and Excel - Tips and Tricks by Anonymous Monk on May 10, 2002 at 13:27 UTC
ah, exactly right. many thanks. I'm continuously amazed and impressed by the Perl community. Dooj	[reply]

In Section Tutorials