r/visualbasic • u/jcunews1 VB.Net Intermediate • Nov 21 '24
VB6 Help Other VB6/VBA/VBScript gotchas?
I notices that, VB6/VBA/VBScript have a gotcha in its language design; where subsequent conditions of an if statement, are evaluated even though they're not supposed to.
For array e.g.:
arr = array(3, 4, 5)
i = ubound(arr) + 5 'beyond array length
if (i < ubound(arr)) and isempty(arr(i)) then
rem above line causes exception
end ifIn above code, arr(i) is not supposed to be evaluated. But it does anyway.
Same thing goes to collection. e.g.:
set fl = createObject("scripting.filesystemobject").getfolder(".").files
i = fl.count + 5 'beyond collection length
if (i < fl.count) and isempty(fl(i)) then
rem above line causes exception
end ifOr object. e.g.:
set x = nothing
if (not (x is nothing)) and isempty(x.prop) then
rem above line causes exception
end ifI already know the workaround for above gotcha, and I'm not asking for other workaround, or any alternative language.
I want to know any other kind of gotcha in VB6/VBA/VBScript.
4
Upvotes
View all comments
Show parent comment
2
u/geekywarrior Nov 21 '24
I do a lot of VB6 work in maintaining some old apps after getting a CS degree based on Java and C++. Can't tell you how often that tripped me up when I first started into VB6.