Re^2: Can't Find my way in Excel

http://qs321.pair.com?node_id=11106306

in reply to Re: Can't Find my way in Excel
in thread Can't Find my way in Excel

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.

Comment on Re^2: Can't Find my way in Excel

Replies are listed 'Best First'.
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
`Can't use string ("") as a subroutine while "strict refs" in use at se +arch.pl line 100` [download] The example code you show doesn't have 100 lines. Please reduce the code you run until it has below 20 lines. Then post that reduced code together with the error message that corresponds to the reduced code. It's hard for us to interpret an error message for code we're not seeing.	[reply] [d/l]
Re^6: Can't Find my way in Excel by ExReg (Priest) on Sep 17, 2019 at 19:00 UTC
Re^7: Can't Find my way in Excel by poj (Abbot) on Sep 17, 2019 at 20:14 UTC
Some notes below your chosen depth have not been shown here
Re^7: Can't Find my way in Excel by rjt (Curate) on Sep 17, 2019 at 19:28 UTC

In Section Seekers of Perl Wisdom