Re: Can't Find my way in Excel

Have you tried

$loc = $Sheet->UsedRange->Cells->Find( { What =>"cabbage" })
[download]

The Win32::OLE documentation suggests passing a hashref when you want to use named parameters.

Also, did you run your code with warnings or the -w command line switch? Perl will tell you about problems in your code if you let it.

Update: Also try:

$loc = $Sheet->UsedRange->Cells->Find( What =>"cabbage" )
[download]

Comment on Re: Can't Find my way in Excel Select or Download Code

Replies are listed 'Best First'.
Re^2: Can't Find my way in Excel by ExReg (Priest) on Sep 17, 2019 at 17:20 UTC
I have tried that. It errors with "Undefined subroutine &main...". $Sheets, $Sheets->UsedRange, and $Sheets->UsedRange->Cells all return Win32 hashes, but I can't get that last step with Find.	[reply]
Re^3: Can't Find my way in Excel by Corion (Patriarch) on Sep 17, 2019 at 17:23 UTC
Please tell us the exact and complete error message. Otherwise, we can't know what exactly goes wrong with your script.	[reply]
Re^4: Can't Find my way in Excel by ExReg (Priest) on Sep 17, 2019 at 17:44 UTC
Sorry, "Undefined subroutine &main:: called at (eval 14)D:/software/Perl/lib/perl5db.pl:646 line 2, <$lh> line 7." This is the error I see in perl's debugger as I try each variation. If I try just running it without debug, I get "Can't use string ("") as a subroutine while "strict refs" in use at search.pl line 100, <$lh> line 7." That is true if the curlies are around the whole expression inside the parens or not. Without "use strict" I get the Undefined subroutine error.	[reply]
Re^5: Can't Find my way in Excel by Corion (Patriarch) on Sep 17, 2019 at 17:46 UTC
Re^6: Can't Find my way in Excel by ExReg (Priest) on Sep 17, 2019 at 19:00 UTC
Some notes below your chosen depth have not been shown here