in reply to Error in excel reader

$Excel->WorksheetFunction->Find("IB_MsgSig","E","Go Notifier Customization Availability Flag 2");

You are accessing WorksheetFunction.Find, which does the same as the Excel function FIND. I suspect you might want Range.Find instead.

Replies are listed 'Best First'.
Re^2: Error in excel reader
by Veltro (Hermit) on Jan 02, 2019 at 14:51 UTC
[reply]
      I'm not so sure, I am definitively finding a method with that prototype

      See e.g. What does Application.WorksheetFunction.Find do?, in other words, it's basically the same as index. Although it is just a guess, based on the arguments the OP is passing to the function, I really do suspect the OP mistook WorksheetFunction.Find for Range.Find, and wants the latter instead.

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom