Re: Error in excel reader

Another sugestion here that you may be able to try. The third argument of the Find method does not seem to be a string to me but an object. Looking at the Win32::OLE::Variant Perl documentation, I don't have experience with this but I think you can try to:

my $tmpstr = Variant( VT_BSTR, "Go Notifier Customization Availability
+ Flag 2" ) ;
my $value = $worksheetfunction->Find("IB_MsgSig","E",$tmpstr) ;
[download]

edit: Another thing that you could try is to specify the range as E:E

Comment on Re: Error in excel reader Select or Download Code

Replies are listed 'Best First'.
Re^2: Error in excel reader by davies (Monsignor) on Jan 02, 2019 at 14:51 UTC
I don't see how this would help. VBA tries to be strongly typed but then finds it needs to have weak typing available. The variant is its weakly typed scalar, so, unless I have something wrong, your suggestion would involve coercing a string into a variant in a situation where it is known to be a string & can be strongly typed. While putting it in a variable shortens the code, which can be desirable, the advantage of a variant isn't immediately obvious to me. Regards, John Davies	[reply]

Replies are listed 'Best First'.

Re^2: Error in excel reader
by davies (Monsignor) on Jan 02, 2019 at 14:51 UTC

I don't see how this would help. VBA tries to be strongly typed but then finds it needs to have weak typing available. The variant is its weakly typed scalar, so, unless I have something wrong, your suggestion would involve coercing a string into a variant in a situation where it is known to be a string & can be strongly typed. While putting it in a variable shortens the code, which can be desirable, the advantage of a variant isn't immediately obvious to me.

Regards,

John Davies

[reply]