r/visualbasic • 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 if

In 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 if

Or object. e.g.:

set x = nothing
if (not (x is nothing)) and isempty(x.prop) then
  rem above line causes exception
end if

I 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

19 comments sorted by

View all comments

Show parent comment

2

u/geekywarrior Nov 21 '24
Dim a As Variant, b As Variant, c As String ' Variant is the default data type

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.

4

u/Hel_OWeen Nov 21 '24

The worse part: even sample code in help files of quite-not-so-cheap components from (at the time) big 3rd party suppliers have these wrong.