« first day (1554 days earlier)      last day (1626 days later) » 
00:00 - 17:0017:00 - 00:00

Duga
Duga
12:00 AM
RELOAD!
[rubberduck-vba/Rubberduck] 3 opened issues. 6 issue comments.
 
Comintern
Comintern
1:00 AM
0
A: A function that tells you if a particular set of data exists in a listbox

CominternErrors and Omissions The UBound2 function is simply incorrect. You are operating on the assumption that every array is base zero with positive indexing... Private Sub ExampleOne() Dim bar() As Long ReDim bar(-10 To -5) Dim idx As Long For idx = LBound(bar) To UBound(bar) ...

Well that ^ took longer than I planned...
 
IvenBach
IvenBach
^ @KySoto It's done with love.
 
Comintern
Comintern
1:19 AM
^
 
Duga
Duga
1:34 AM
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4127?src=pr&el=h1) Report
> Merging [#4127](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4127?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/4df720727b79b29cd87363152ce5f7beef3446d8?src=pr&el=desc) will **increase** coverage by `1.04%`.
> The diff coverage is `92.03%`.


```diff
@@ Coverage Diff @@
## next #4127 +/- ##
=======================
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4127?src=pr&el=h1) Report
> Merging [#4127](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4127?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/4df720727b79b29cd87363152ce5f7beef3446d8?src=pr&el=desc) will **increase** coverage by `1.04%`.
> The diff coverage is `92.03%`.


```diff
@@ Coverage Diff @@
## next #4127 +/- ##
=======================
[rubberduck-vba/Rubberduck] build for commit 8802fccd on unknown branch: AppVeyor build succeeded
 
 
2 hours later…
IvenBach
IvenBach
3:42 AM
@Hosch250 How'd your interview go?
 
 
2 hours later…
Quack Exchange
Quack Exchange
5:49 AM
0
Q: SpaceInvaders Second Iteration

learnAsWeGoI have revamped with some of Comintern's improvements implemented. I still need time re his presenter class. Maybe its because I am not familiar with bitmaps? Basically instead of controls we would represent these objects with sets of pixels on an X by Y grid of pixels? Which could then be "pres...

beginner object-oriented game vba excel
 
 
2 hours later…
QHarr
QHarr
8:08 AM
Cooeee!
Anyone know how in VBA to initialize the COM object queue using a list? I.e. construct it with multiple items not just one with adding individually please? Kinda like this:
15
Q: How to Enqueue a list of items in C#?

Joe CabezasUsing lists I use List<int> list = new List<int>(); list.AddRange(otherList); How to do this using a Queue?, this Collection does not have a AddRange Method. Queue<int> q = new Queue<int>(); q.AddRange(otherList); //does not exists

c# collections queue
 
 
3 hours later…
FreeMan
FreeMan
11:29 AM
@IvenBach thanks! I took a quick look, but will have to read through in depth.
Interesting. Ctrl-<backtick> wasn't working for the initial parse in Access and I had my coffee in my mouse hand, so I hit Alt-b to bring up the RD menu. The RD status bar said Pending and the first item on the RD menu is Refresh, but Refresh was disabled because, I guess, it refreshes, but won't do an initial parse?
I'd guess that's status-by-design, but seems a bit... odd... Maybe it could be enabled and read Parse if the initial parse hasn't been done, just like the status bar button...
 
FreeMan
FreeMan
11:56 AM
@this In the MSDOS 8.3 days? no, I'm not 100% certain, but I'm pretty sure that a file name of 0123456789.txt would have simply been truncated to 01234567.txt. There was no smart-renaming.
I think it was probably around Win95 time that copying myFile.xls and pasting it back into the same directory would automatically name it myFile (2).xls. Later versions change the pure numbering to * - Copy (n).* format. In case you couldn't tell that it was a copy...
 
Mathieu Guindon
Mathieu Guindon
12:48 PM
@FreeMan if it's by design, it shouldn't be...
 
FreeMan
FreeMan
there might have been a bit of snarkieness in that pseudo-tag...
 
QHarr
QHarr
\o
 
Hosch250
Hosch250
@IvenBach Not very good.
I kind of made it clear I wasn't actively looking for a new position, and he promptly said "sorry, we've only got positions for people with more than one year of experience."
 
Inarion
Inarion
1:25 PM
What kind of commands are RSet/LSet? They do have quite a particular syntax... 
Dim SomeText
SomeText = "0123456789"
RSet SomeText = "Right->"
will output " Right->"
I've not come across such commands until now (that I'm aware of).
The output is from ?SomeText, of course. So RSet behaves like a function in that it takes some arguments and does something with them, assigning a return value. But the syntax is nothing like that.
 
this
this
Inarion, it's used to right-align your text
and with LSet, it's useful for binary copying of your UDT.
example: 
Private Type x
  a As Integer
  b As Integer
End Type

Private Type y
  a As Long
End Type

Public Sub DoIt
  Dim x As x
  Dim y As y

  x.a = 1
  x.b = 1

  LSet y = x

  Debug.Print y.a

End Sub
With RSet, you normally use pre-formatted string of a fixed length. Used for building text-only tabular output....
 
Mathieu Guindon
Mathieu Guindon
1:49 PM
@this lightbulb moment
although, it's kind of cryptic nonetheless
 
this
this
IKR?
and it has to be a UDT
You can't LSet to a Long directly
 
Comintern
Comintern
It's a bit more clear than a call to CopyMemory.
 
this
this
but then again, VBA is kind of weird in that regards.
and safer, too.
You don't have to worry about GPF with a LSet
 
Comintern
Comintern
Well that's no fun.
 
this
this
says the guy who enjoys blowing up Excel
 
Comintern
Comintern
1:53 PM
I've really only ever succeed at getting it to implode. Explode would be better - I envision cleaning cells off the walls of my office.
2
 
this
this
lol
oh one caveat. No dynamic arrays. (and strings, either,unless it's fixed length)
since neither are pinned to the UDT structure.
 
ThunderFrame
ThunderFrame
wonders whether @MathieuGuindon uses LSet and RSet in his StringFormat class.
 
Mathieu Guindon
Mathieu Guindon
never used either in my lifetime
learned about their existence with Rubberduck's grammar
 
Comintern
Comintern
Not nearly as esoteric as Circle and Scale, but they are definitely beasts of a different era.
 
ThunderFrame
ThunderFrame
@Comintern I created Subs Foo and Bar, then called Bar from Foo and halted execution inside Bar, then went looking for the AddressOf Foo and Bar in Excel's memory. i.e. searching for the call stack.
 
Mathieu Guindon
Mathieu Guindon
2:07 PM
ironically I vividly remember using 2px dark gray + 1px light gray Line to make "3D-looking" section/divider lines on forms in VB6
 
Inarion
Inarion
@this Wizardry! o.O
 
ThunderFrame
ThunderFrame
I think I found it, although there were 2 other pointers between the pointers I expected. I need to create a deeper call stack and see if it's easier to reverse engineer.
@MathieuGuindon not vivid, but that does ring a bell
@Comintern PSet is even odder
 
Mathieu Guindon
Mathieu Guindon
wait no I'm confusing things. wasn't there an actual "Line" button in the form designer toolbox?
 
Comintern
Comintern
@ThunderFrame Doesn't a standard call push the parameters onto the call stack along with the return address?
 
Mathieu Guindon
Mathieu Guindon
pretty sure I was drag-n-dropping them
so, not-quite-vividly
 
ThunderFrame
ThunderFrame
2:10 PM
@Comintern there weren't any params (I was starting out simple)
 
Comintern
Comintern
Hmmm... I wonder if the modules carry an implicit this pointer to the static instance. That could explain one of them. They wouldn't be like library calls - you still need a "reference" to the server for "Module1" if that makes sense.
 
ThunderFrame
ThunderFrame
@Comintern yeah, and the other Long could be flags, because the View Call Stack dialog seems to know about non-VBA code
 
IvenBach
IvenBach
@FreeMan if something doesn’t make sense about it let me know. I have a couple more in mind for how to work in the VBA IDE and getting the most out of it with hotkeys.
 
ThunderFrame
ThunderFrame
As an aside, I need to use a splitter/panel in VBA, neither of which exist. I'm thinking of using a label along with mouse events, and wrapping it up in a class. Any better ideas, short of writing an actual control?
 
Comintern
Comintern
@ThunderFrame I wonder if having a debugger attached pushes anything else onto the stack. I.e. a hook.
 
ThunderFrame
ThunderFrame
2:16 PM
@Comintern or maybe a line number?
 
Comintern
Comintern
That would be a cringe-worthy implementation.
 
ThunderFrame
ThunderFrame
@Comintern I meant a cross-reference to the position in the p-code/execode, rather than the actual line number.
 
Comintern
Comintern
Gotcha - like a symbol pointer.
 
ThunderFrame
ThunderFrame
Yep, so if you want to read the callstack, you need to know: where to find it, what all of the procedure/parameter addresses resolve to in the TypeLib, and what each line of p-code resolves to in the VBE. i.e. Wayne's call stack black magic sits atop a lot of other black magic.
@MathieuGuindon I was thinking about RD's tagline: "Bringing the VBE into the 21st century". I guess technically, we've been bringing the VB IDE into the 21st century. The VB Editor is very much on the (Avalon) roadmap, but we haven't actually done anything to that yet, other than autocomplete (everything else is an IDE feature) And in any case, hauling the entire IDE is a much bigger undertaking, and the editor is just one small part of the IDE.
 
this
this
@Comintern Frankly it really gets my goat that VBA understand how to reference a module but it simply can't use it like a variable.
 
Comintern
Comintern
2:32 PM
@this You might be able to calculate the base address of the function table and pass that around as raw pointer. It would require the caller to have some knowledge of the module though.
Damit, now you got me considering whether I can wrap a class around that to get a "true" VBA singleton.
 
this
this
I suppose but TBH, I think it's more valuable to be able to create standalone VB project
that can be linked by any hosts
Because that way, we can leverage the project boundary
and also be able to ship code that 'll work in any VBA host
not just Excel add-in limited to Excel host, Access library limited to Access, etc.
That would also make nuggets very a real possibility
 
ThunderFrame
ThunderFrame
@this +1
 
Comintern
Comintern
That sounds like an excellent way to propagate macro viruses.
 
this
this
and that's news?
it always has been a vector for virus for quite a while...
 
ThunderFrame
ThunderFrame
Corel draw lets you reference a project that doesn't have any document modules... That's getting pretty close to what you need. I wonder if MS deliberately made it impossible, to prop up sales?
 
this
this
2:45 PM
@ThunderFrame according to @mansellan it was possible to create standalone projects with Office 200? developer editions.
 
KySoto
KySoto
@Comintern welp i asked for it on that CR post
 
this
this
but yeah, you had pay a bit extra for those old developer editions.
then all of sudden they pulled it. Maybe because of macro virus incidents, IDK.
 
FreeMan
FreeMan
@ticker - that sounds like a better question for Woodworking than Stack Overflow...
 
KySoto
KySoto
it was pretty painful realize just how crap a coder i am
 
this
this
But frankly, I don't see how you can not avoid it being an attack vector.... Literally any DLL is an attack vector.
 
FreeMan
FreeMan
2:47 PM
any code is an attack vector...
 
this
this
^^
 
ThunderFrame
ThunderFrame
The Unviewable+ company seems to have made it possible to have execode only Excel files (like ACCDEs)... I wonder if the project binary code be tweaked to allow opening in any host? IIRC, the only project properties that preclude a project opening are the version of the original VBA editor and the bitness. So you just need a way of removing the host-specific reference.
 
FreeMan
FreeMan
it's a matter of your risk tolerance.
 
this
this
@KySoto Best to know that you need to improve than never knowing that you were in need of improvement. It's the only way to get better.
2
 
ThunderFrame
ThunderFrame
@this I have Developer XP. IIRC, it was a DLL that got created.
 
Comintern
Comintern
2:48 PM
^^ That's what CR is for. I'd rather have my good code ripped to shreds than my bad code hand waved.
 
KySoto
KySoto
its a struggle to not take it personally when i KNOW it isnt, hes just doing an honest review
its like owwwww
 
this
this
@ThunderFrame I once naively thought that you could reference any VBA and was disappointed to find out that Excel cannot reference an Access project and vice versa. I think I tried changing file extension but that didn't work either.
 
Hosch250
Hosch250
Separate yourself from your code, padawan.
You might be the best person on earth, but you just aren't an expert in this field yet.
 
KySoto
KySoto
you mean ever right?
 
this
this
@Hosch250 Frankly my spider sense goes off when anyone says "don't worry, I'm an expert in this!"
 
Hosch250
Hosch250
2:50 PM
LOL.
Even Eric Lippert and Jon Skeet?
 
ThunderFrame
ThunderFrame
@this yeah, I tried it too. I think it successfully added the reference, but then promptly blew up the host... And I'd saved the change, so it blew up the host whenever I opened the file.
 
this
this
Almost inevitably after they've made the statement, they manage to screw up massively and say, "Well, that wasn't what I was expecting...."
 
Hosch250
Hosch250
Totally had a moment of that at work recently.
 
Mathieu Guindon
Mathieu Guindon
@this lol yeah sounds like "WAIT!! I know RegEx!"
 
Vogel612
Vogel612
dunning kruger anyone?
 
Hosch250
Hosch250
2:51 PM
Turns out I wasn't connected to the right local DB.
 
Vogel612
Vogel612
@MathieuGuindon you do know that the Regex Analyzer is currently a bit totally broken, right?
 
Mathieu Guindon
Mathieu Guindon
and code metrics
 
Vogel612
Vogel612
Totally not my fault for saying exactly that... cough
@MathieuGuindon huh? those are ded?
 
ThunderFrame
ThunderFrame
"we've been running this website securely for 15 years without your help, and we've never had a security incident.... Next day... Website offline, database purged.
 
Vogel612
Vogel612
damn I really need to get stuff I put into RD back on track
 
ThunderFrame
ThunderFrame
2:52 PM
"we've been running this website securely for 15 years without your help, and we've never had a security incident.... Next day... Website offline, database purged."
 
Mathieu Guindon
Mathieu Guindon
all I get is a blank toolwindow
@Vogel612 me too!
 
Vogel612
Vogel612
@MathieuGuindon you did parse?
 
this
this
@Vogel612 me 3x
 
Mathieu Guindon
Mathieu Guindon
@Vogel612 yup. @IvenBach repro'd too
 
Vogel612
Vogel612
then I need to hope I'm able to blame it on Hosch for making the UI pretty
 
Mathieu Guindon
Mathieu Guindon
2:54 PM
lol
 
ThunderFrame
ThunderFrame
See, even chat baulks at an over-confident security assertion
 
Vogel612
Vogel612
but first: coffee
 
Inarion
Inarion
@this This was me a couple of weeks ago. Now I launch a full blown Access instance to get there... it's pretty slow. But my users are used to much worse things. (Not from me...) So I guess they'll accept it just fine.
 
KySoto
KySoto
@Comintern i never knew about using or instead of + to get multiple flags on a messagebox
i didnt actually know it was an option
 
Inarion
Inarion
I have to say I was quite surprised when testing that process, that stepping (F8) into a call to another VBA host will end up opening that host's VBE and marking the active code line there...
@KySoto I learned it from the RD folks. ;)
 
KySoto
KySoto
3:00 PM
i dont even know why it matters
 
this
this
@KySoto compare the result of ?vbInformation Or vbInformation to ?vbInformation + vbInformation
 
KySoto
KySoto
i could see that causing an issue since you are adding the same value twice
but if they are different values why would it matter?
 
this
this
with a bitmask, you are not really supposed to "add"
it's kind of the same reason why you shouldn't 1 + "1"
it's legal but it might not do what you think it should do
 
KySoto
KySoto
right that makes sense
its the same flag
but if you add 1 + 2
 
this
this
vbInformation Or vbInformation communicates that you are using a bitmask
not just some integers
 
KySoto
KySoto
3:03 PM
hm
 
Comintern
Comintern
@KySoto Basically what @this said. Adding can work with bit-flags, but it can also create a bunch of problems in some situations.
 
this
this
IMPOV, it has more to do with telling the reader what your code is doing.
Oring a bitmask is more accurate portrayal of what you are doing with those flags.
 
Comintern
Comintern
^ what you intend to do with them...
 
this
this
for same reason DateAdd("d", 1.5, Now() is better than Now() + 1.5
Yes, thanks for better phrasing
Just because they produce same results doesn't mean they're equivalent.
Sounds weird but it is logical when you think about it
 
Comintern
Comintern
@FreeMan Wow, I'm slow today. I just got that... Create Table from Tree
2
 
KySoto
KySoto
3:09 PM
oh by the wya, @Comintern i had an issue once when i was doing the whole if debugmode thing
where i left off the else, and it wouldnt properly go the else path
and one other thing, if you don't do a resume at the end of the error handling portion of the procedure and just left the function end, doesnt that error state carry over into a calling procedure?
because i could swear that when i used to do that when i had error catching code that should have caught an error, didnt i changed the function called to have the resume and the error didnt go up
ugh my words are getting derpy, sorry
 
Comintern
Comintern
@KySoto No: 
Public Sub Caller()
    Test
    Debug.Print Err.Number
End Sub

Public Sub Test()
    On Error Resume Next
    Err.Raise 6
    Debug.Print "returning"
End Sub
 
this
this
It's actually the GoTo out of the error handling that's harmful
 
Inarion
Inarion
@Comintern Lol, that was actually a good one. :D
 
Comintern
Comintern
Note that the Debug.Print Err.Number still prints "6", but it is considered handled in the Caller.
 
KySoto
KySoto
right, but you are using on error resume next
if you AREN'T using that
 
Comintern
Comintern
3:14 PM
Then it propagates up the stack until it is handled.
 
KySoto
KySoto
and caller ends up throwing an error
 
Comintern
Comintern
Just like if you'd explicitly called On Error Goto 0
 
this
this
Hmm. OERN changes things.
 
KySoto
KySoto
even if it had an error handling block
 
this
this
this won't carry over: 
Public Sub callit()
    callme
    Debug.Print Err.Number
End Sub

Public Sub callme()
On Error GoTo oops
    Debug.Print 1 / 0

oops:
End Sub
 
Comintern
Comintern
3:15 PM
@this Correct. In that case the error is handled in callme. OERN is not a handler.
 
this
this
I think that explains why some templates put in On Error GoTo 0 in the cleanup section.
 
KySoto
KySoto
hm
its looking like i had a wierd one of error, and it colored my whole error handling experience
though i do tend to do things like close recordsets and the like
 
Comintern
Comintern
It's still pretty pointless though: 
Public Sub Caller()
On Error GoTo foo
    Test
foo:
    Debug.Print Err.Number
End Sub

Public Sub Test()
    On Error GoTo 0
    Err.Raise 6
End Sub
 
KySoto
KySoto
just not always (if it doesnt have one
so when it ends it closes out a recordset, error or no
 
this
this
@Comintern not in this case, though: 
Public Sub Caller()
On Error GoTo foo
    Test
foo:
    Debug.Print Err.Number
End Sub

Public Sub Test()
    On Error Resume Next
    Err.Raise 6

ExitSub:
    On Error GoTo 0
    Exit Sub
End Sub
 
KySoto
KySoto
3:19 PM
something like 
Error_Exit:
    If Not rs = Nothing Then
        rs.Close
        Set rs = Nothing
    End If
    Exit Sub
error_handler:
    StandardErrorBox "Save", Err, Errors
    Resume Error_Exit
End Sub
 
Inarion
Inarion
Uh, how bad exactly is doing something like that: For iCol = 1 To rst.Fields.Count * (1 + CInt(someFlagToSkipLoop))? (It made me feel smart for a moment, but I think in actual code, I likely shouldn't do it... Clarity and all...)
 
KySoto
KySoto
if you wanna jump out of your for loop
 
this
this
@KySoto see, when not using watchdog, that's why I think it's best to OERN inside the exit
 
KySoto
KySoto
you can use exit for
 
this
this
I would have written something like....
 
Comintern
Comintern
3:21 PM
@this That's even more pointless. That's a 3 line version of Err.Clear using GoTo's
 
KySoto
KySoto
@this OERN ?
 
Inarion
Inarion
@KySoto yeah, but then it's an extra line :D (I agree that it would be much clearer and less error prone -> better)
 
this
this
Error_Exit:
    On Error Resume Next
    rs.Close
    Set rs = Nothing
    Err.Clear
    Exit Sub
error_handler:
    StandardErrorBox "Save", Err, Errors
    Resume Error_Exit
End Sub
which is why I hate the old way of doing things and use watchdog. :)
 
Comintern
Comintern
On Error GoTo 0 still doesn't do anything there.
 
KySoto
KySoto
so its better to use on error resume next than to just check if the object is not nothing?
 
this
this
3:23 PM
@Comintern yet if you comment out the On Error GoTo 0, the error state carries over?
 
Comintern
Comintern
Unless you expect Exit Sub to throw?
@this Err.Clear.
That's what it's for.
 
this
this
Yes, you're right. That's more idiomatic
As I said earlier:
8 mins ago, by this
I think that explains why some templates put in On Error GoTo 0 in the cleanup section.
(not very good ones but that's what MZ Tools 3.0 was doing, IIRC)
it really bothered me but didn't connect the dots why.
 
Comintern
Comintern
I obviously haven't tested it, but it's probably more performant too, because it isn't rearranging the state of the debugger.
 
KySoto
KySoto
for some reason i thought it was better to negate the possibility for the error instead of just on error resume next'ing it
 
this
this
@KySoto it's more that you shouldn't have any errors when you're cleaning up. If you do, it's a lost cause anyway.
 
KySoto
KySoto
3:26 PM
right
well if i lose connectivity to the database server
 
this
this
and there are more reasons why there could be an error, though.
 
KySoto
KySoto
the recordset never could be set to an instance of an object
so i cant perform a .close
and that DOES happen.
 
this
this
right, but you can have a situation where you ahve a valid recordset and you still can't .close it
 
KySoto
KySoto
what?
 
this
this
so the test for nothing can fail, but you still can't close it.
 
KySoto
KySoto
3:27 PM
ADO?
 
Comintern
Comintern
@KySoto Depends on the situation. I'll use it to "inline" error handling: 
On Error Resume Next
DoTheThingThatCanThrowA6
If Err.Number = 6 Then
    'Whatever
End If
On Error GoTo 0
 
KySoto
KySoto
i frequently work with DAO recordsets
how the heck could rs.close fail
 
this
this
example: 
Public Sub derp()
    Dim rs As DAO.Recordset

    On Error GoTo derp

    Set rs = CurrentDb.OpenRecordset("MSysObjects")
    rs.Close

exity:
    On Error GoTo 0
    If Not rs Is Nothing Then
        rs.Close
    End If
    Set rs = Nothing
    Exit Sub
derp:
    Resume exity
End Sub
This isn't very subtle but there are ways where it can fail (e.g. because you did a db.Close which can cause its children recordsets to become disconnected)
but you must handle the possibility. #BeltsNSuspenders
 
KySoto
KySoto
i dont believe i have ever actually used a db.close in code
but valid
 
IvenBach
IvenBach
@KySoto It's a review of the code itself, not the individual that produced said code.
 
KySoto
KySoto
3:33 PM
yeah, separating that is difficult
logically i know that anyway
but then i also want to understand the why's of his critique
so why is xyz thing the right way to do things?
 
IvenBach
IvenBach
More experience with failure will help you learn that.
@MathieuGuindon What's repro'd? Can't tell from chat so far.
 
Mathieu Guindon
Mathieu Guindon
no content in the code metrics tw
 
IvenBach
IvenBach
I get content.
 
KySoto
KySoto
so in my standardErrorBox function, i technically dont need to pass in the errObject because the function just gains access to it by default?
 
Comintern
Comintern
Yep. You can call Err anywhere to get the current state of the error object.
 
Mathieu Guindon
Mathieu Guindon
3:40 PM
VBA.Information.Err -> global function
 
KySoto
KySoto
also on the IsArray function --------_____________________________------------
 
this
this
@KySoto have you read Joel On Software?
 
KySoto
KySoto
how the heck did i not see it
Joel who?
2
 
this
this
Ok, you're missing out.
start with this.
 
KySoto
KySoto
i started muddling my way through VBA like 2-3 years ago
 
Mathieu Guindon
Mathieu Guindon
3:41 PM
@KySoto Spolsky
 
KySoto
KySoto
with only crappy VB.net habits
 
Mathieu Guindon
Mathieu Guindon
he wrote the spec for VBA, and is Stack Exchange / Stack Overflow's CEO & co-founder
 
Inarion
Inarion
that blog is totally worth checking out
 
IvenBach
IvenBach
@this Hrm... So OEGT0 effectively invokes Err.Clear?
 
Inarion
Inarion
@IvenBach Assuming you're talking the Code Metrics RD feature in the VBE - it works for me as well. (3751-pre)
 
this
this
3:44 PM
@IvenBach any OE** statement will reset the err.
I also understood that Exit ** would do the same thing but from tests above, it's not the case if we're exiting with an OERN
 
Mathieu Guindon
Mathieu Guindon
wth, code metrics work now
 
IvenBach
IvenBach
It was all in your imagination.
 
Mathieu Guindon
Mathieu Guindon
FWIW I don't like that there's no way of seeing at a glance where the problematic areas are. kinda defeats the purpose
 
IvenBach
IvenBach
Excluding when I was trying to add the vertical split bar, I've always gotten results with CodeMetrics.
 
Inarion
Inarion
Needs moar beer! (I'm off to start the weekend. Cya around!)
 
Mathieu Guindon
Mathieu Guindon
3:47 PM
@Inarion later!
 
Duga
Duga
4:03 PM
 
KySoto
KySoto
@Comintern getting back to the start of your post stating that the purpose of the function is unclear, the whole point of the function is to see if a "row" of data already exists in the listbox
 
Duga
Duga
> I like the *look* of the revamped Code Metrics toolwindow, however UX-wise, the grid was much better. Not being able to see at a glance (or with a quick scroll-through) where the problematic areas are, is a problem - IMO it defeats the very purpose of the tool.

In no particular order:

- Double-clicking a module or member should navigate there
- Selecting a module should display a grid in the RHS pane with all the members and their respective metrics.
- Selecting a member should disp
 
KySoto
KySoto
because i frequently end up using listboxes to visiblely store data (so the operators can see it) and i needed a way to check if the data already existed
 
Duga
Duga
 
KySoto
KySoto
so that led me to never envisioning that i would ever have a non zero based array. (usually when i call the function i use array(value1,value2,value3) for the datapoints checked
 
this
this
4:07 PM
@KySoto why not query?
 
KySoto
KySoto
because they are adding data to the listbox that will be saved
also i dont use bound forms
 
Duga
Duga
 
KySoto
KySoto
so an example situation that i am using it for, we have an application where people need to report a non conformance for parts, they have a 2d barcode with a lot number. they scan the lot number in, then enter the quantity non-conforming
then they click the add button, and it adds it to the listbox so that when they click save, they can save everything at once. well the checklist2 function is there so they cant enter duplicate data
there are a couple of other areas ive used it in where more datapoints are possible to overlap
i just cant remember them off hte top of my head
 
Hosch250
Hosch250
> I once drove our Microsoft support team in Israel to distraction by accidentally changing both Arabic and Hebrew locales to display dates right-to-left apparently Arabs really do read dates right-to-left but Israelis use left-to-right dates even when they are embedded in right-to-left Hebrew text.
 
Mathieu Guindon
Mathieu Guindon
> IMO this is a useless nano-optimization, and it's not refactoring-friendly; TypeName(Me) will always return the actual class' name, whereas renaming the class and then forgetting to update the constant can lead to confusing error logs/messages. If your program's performance is fine-tuned so hard that TypeName(Me) makes any kind of a noticeable difference, you're done - stop tweaking it, it's as efficient as it will ever get.
^ my latest Excel-L reply
"use a constant, TypeName(Me) is much slower - here, ran a million times, took that many ticks, compared to 0 for the const"
 
this
this
4:19 PM
why even use TypeName, anyway? They never give meaningful information.
e.g. no distinction between ProjectA.Class1 vs ProjectB.Class1
 
Mathieu Guindon
Mathieu Guindon
I do it rather often 
Err.Raise 5, TypeName(Me), message
my point was that if their performance is down to TypeName(Me) making a difference, then they might as well inline all procedure and function calls, and embed precompiled assembler instead of writing readable VBA code.
 
this
this
Makes sense - I was thinking type comparison
I remember someone posting a sample on VBExpress or whatever where you could inline assembly in VBA.
 
Hosch250
Hosch250
> The present slogan is the brain-achingly oxymoronic “Diet Dr. Pepper: There’s Nothing Diet About It” – really? Seems like one ought to change the name then, if the name of one’s product is so misleading as to require its complete and utter disavowal in the slogan.
 
this
this
@Hosch250 Like "I can't believe it's not butter!" "butter"?
 
Hosch250
Hosch250
LOL.
 
IvenBach
IvenBach
4:27 PM
Society is showing the level of derpitude it's achieved.
 
Hosch250
Hosch250
> Advertisers love pseudopredicates. Once you realize that they exist you see them all the time. Advertisers love them because they make no testable claim which could be shown to be false in a court of law. Rather, they rely on either the irrational belief that “more” anything means “better”, or upon your brain’s ability to fill in the rest of the objects which they intend you to infer.
 
IvenBach
IvenBach
^ The Mr Snaffleburger corporation is very fond of those.
 
Comintern
Comintern
@KySoto I was referring to the purpose of the UBound2 function specifically.
 
Mathieu Guindon
Mathieu Guindon
@this "I can't believe it's a plastic emulsion of transformed polysaturated fats!" was a distant 2nd
3
 
Comintern
Comintern
lol
 
this
this
4:32 PM
Betcha that nobody at the plant eat the same product they make out
 
KySoto
KySoto
@Comintern oh... now i feel extra dumb there
though really, having now found the isarray function, having invalid arrays hitting ubound is less likely now
i really really dont know how i never found that particular function
 
Comintern
Comintern
IsArray doesn't test to see if it's initialized though. For that, check the linked answer. 
Dim foo() As Long
Debug.Print IsArray(foo) '<-- true
Debug.Print UBound(foo) '<-- runtime error
 
Mathieu Guindon
Mathieu Guindon
@this there was an actual heated debate in the 1980's in Canada, at the end of which it became law that it was illegal to colour margarine in order to make it look like butter
 
this
this
oh really?
so they're colored red or what?
 
Mathieu Guindon
Mathieu Guindon
...it's white
 
Comintern
Comintern
4:38 PM
Margarine. The other white spread.
 
this
this
lol.
 
Comintern
Comintern
I can work with that...
 
this
this
Me, just avoid the nasty stuff that is margarine. They're good for giving migraines, nothing more.
 
Mathieu Guindon
Mathieu Guindon
margarine is outright disgusting if you think for half a second of how it's made and what it actually is
 
Comintern
Comintern
IDK, they're pretty good for giving coronary artery disease too.
 
Mathieu Guindon
Mathieu Guindon
4:40 PM
another stupid thing that's everywhere is palm oil. it's solid at body temp
 
Comintern
Comintern
It's like mayonnaise if you substitute hydrogen for the eggs?
 
Hosch250
Hosch250
> Unlike my crazy friends, I never prank called people, but I prank answered them all the time. You phone me, you take that risk. The moral: send email.
 
this
this
Haven't seen that. The current popular thing is coconut oil
 
Hosch250
Hosch250
> Having two voice lines in the house (one for my 300 baud modem on the Commodore 64, of course) led to ample opportunities for consecutive calls from clueless telemarketers. On the second call I'd just answer with "Don't say anything! I have a mysterious fifth sense! My psychic powers tell me that your name is Helen, and you want to sell me... magazine subscriptions! Yes?"
 
Mathieu Guindon
Mathieu Guindon
@this look at the ingredients list of any industrially-made pastry, or try to find a brand of cookies that doesn't have modified palm oil in it. it's everywhere - because it's cheap.
 
this
this
4:45 PM
hmm. I'll have a look. Thankfully I don't buy them anyway.
 
IvenBach
IvenBach
@Hosch250 Slow day at work?
 
Hosch250
Hosch250
Yeah.
Waiting for a mock up and some verbiage.
So reading Eric Lippert.
 
Mathieu Guindon
Mathieu Guindon
mind you, in the US you already have high-fructose corn syrup in everything. that shit is illegal in Canada.
 
Hosch250
Hosch250
At least it's halfway relevant to my position :P
@MathieuGuindon Meh. It's just organic molecules...
 
Mathieu Guindon
Mathieu Guindon
so is palm oil
 
this
this
4:47 PM
Yeah, HFCS is just awful. It's practically impossible to avoid if you go to your standard grocery store and buy packaged foods. We opt to cook at home so that helps avoid HFCS.
 
Mathieu Guindon
Mathieu Guindon
HFCS is the US producing WAY too much corn for its own good, and figuring out a way to sell it
 
Comintern
Comintern
^
 
Hosch250
Hosch250
But the Ethanol!
It's green!
 
this
this
I do wish they'd get over the tariff already.
 
Comintern
Comintern
We grow so much we have to find creative ways to burn it.
 
this
this
4:50 PM
We are actually subsidizing farmers to grow corns
 
Mathieu Guindon
Mathieu Guindon
^ there
 
Hosch250
Hosch250
(Not to mention that in the south it burns dirtier than gasoline unlike in the north for some peculiar reason.)
 
this
this
as opposed to say... buying sugars from Communist Cubans!!! OH NOES!
 
Comintern
Comintern
Mmm.... commie sugar.
Makes good commie rum.
 
Mathieu Guindon
Mathieu Guindon
^
 
this
this
4:51 PM
Meh. I don't care where it came from. Sugar is much preferable than HFCS
and frankly, we'd be doing cubans a favor if we bought from them.
 
Comintern
Comintern
You'd care if you made it into rum.
 
Mathieu Guindon
Mathieu Guindon
so you make corn into whiskey instead
 
this
this
Pretty sure sugar's still sugar whether it's grown in a communist soil or in dicatorial soil.
 
Comintern
Comintern
If you've ever tried a micro-distilled rum, you'll know what I mean. The reason they spice captain morgan's is to make it taste like, well, rum.
@this Nope. Capitalists will plant sugar beets.
 
this
this
Communist Beets = Capitalist Beets. Communist Sugar = Capitalist Sugar. Capitalist Beets ≠ Communists Sugar. What's your point?
 
Hosch250
Hosch250
4:54 PM
They grow sugar cane in the south.
 
Mathieu Guindon
Mathieu Guindon
sweet fun fact: in Canada sugar must be refined. so all the hippies who think they're putting "raw sugar" in their eco-friendly coffee are actually putting refined white sugar that was reprocessed and coloured
 
IvenBach
IvenBach
#Irony
 
this
this
LOL. What was the reasoning for requiring refining?
 
Mathieu Guindon
Mathieu Guindon
no clue
probably something to do with some industrial lobby, like everything else
 
this
this
probably to protect hippies from getting sick
 
Mathieu Guindon
Mathieu Guindon
4:55 PM
lol
 
this
this
99% of laws can be traced to some kind of self-serving lobby.
Corn farmers here aren't stupid.
they'd rather watch reruns of Hee-Haws while gov't pays them big bucks for growing corns that nobody needs.
 
Comintern
Comintern
I never understood the whole "un-refined sugars" thing. If you miss what they took out, well... molasses?
 
Mathieu Guindon
Mathieu Guindon
^ brown sugar = white sugar + molasses
 
this
this
there's lot of people who think that "processing" is the debbil
but hey, i put some veggies in oil in my frying pan.... OH NOES I M PROCESSING!
 
Mathieu Guindon
Mathieu Guindon
@this if it involves margarine, I can agree with that
 
this
this
4:57 PM
Sure, but you have to explain what "processing" actually entails.
everyone thinks, IDK, you're adding some shitty chemical and that's "processing"
but the definition doesn't work well all time.
 
Mathieu Guindon
Mathieu Guindon
if you want unprocessed food, kill your own chickens and grow your own carrots
 
this
this
^
imagine asking eco hippies to do that.
 
Comintern
Comintern
Are the chickens processing the food or something?
 
Mathieu Guindon
Mathieu Guindon
yeah. it's called "digestion", I think.
 
Comintern
Comintern
lol
 
Mathieu Guindon
Mathieu Guindon
4:59 PM
on that note, it's fry day. off to McD's
 
Comintern
Comintern
"Oddest thing, the chickens are making margarine in the chicken coop. It's behind their still."
 
00:00 - 17:0017:00 - 00:00

« first day (1554 days earlier)      last day (1626 days later) »