Win32::OLE Excel Bareword problem

pankaj_it09 has asked for the wisdom of the Perl Monks concerning the following question:

#___ FIND LAST ROW/COLUMN WITH DATA
my $row = $Sheet1 -> UsedRange -> Find({What => "*", SearchDirection => xlPrevious, SearchOrder => xlByRows}) -> {Row};

Error:
Bareword "xlByRows" not allowed while "strict subs" in use.

Comment on Win32::OLE Excel Bareword problem Select or Download Code

Replies are listed 'Best First'.
Re: Win32::OLE Excel Bareword problem by glasswalk3r (Friar) on Mar 04, 2009 at 13:34 UTC
RTFM. If you want to use a module, at least read the documentation of it before asking here. To use Win32::OLE with constants of a program (like Excel) you must `use Win32::OLE::Const` . Alceu Rodrigues de Freitas Junior --------------------------------- "You have enemies? Good. That means you've stood up for something, sometime in your life." - Sir Winston Churchill	[reply] [d/l]
Re^2: Win32::OLE Excel Bareword problem by pankaj_it09 (Scribe) on Mar 04, 2009 at 13:49 UTC
ok this solves it.	[reply]
Re: Win32::OLE Excel Bareword problem by Anonymous Monk on Mar 04, 2009 at 13:19 UTC
Bareword "xlByRows" not allowed while "strict subs" in use. Read `perldoc strict`	[reply]