Do you know where your variables are? | |
PerlMonks |
Re^2: Error in excel readerby davies (Prior) |
on Jan 02, 2019 at 14:51 UTC ( [id://1227927]=note: print w/replies, xml ) | Need Help?? |
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
In Section
Seekers of Perl Wisdom
|
|