« first day (1756 days earlier)      last day (1424 days later) » 
00:00 - 19:0019:00 - 00:00

12:00 AM
Ah, good points!
and thanks!
 
RELOAD!
 
The OnSomething thing is really just a recommendation for naming things though
 
[rubberduck-vba/RubberduckWeb] 1 opened issue. 1 issue comment.
[skiwi2/pokemon-buylist] 4 commits. 72 additions. 13 deletions.
 
I don't think any VBA typelib uses that convention
 
[Zomis/minesweeper-server] 1 commit. 132 additions.
[Minesweeper] Games Played: 143, Bombs Used: 88, Moves Performed: 17928, New Users: 17
 
12:38 AM
Hmm i seem to recall it being used in msxml or mshtml.
 
 
3 hours later…
4:08 AM
0
Q: Visual Basic For Applications | Array Functions - Insert Element | Remove Element

learnAsWeGoAn extension to array functions I am building for my snake game. This one allows you to remove / insert particular elements. API CALLS Private Declare PtrSafe Function VarPtrArray Lib "VBE7" Alias "VarPtr" _ (ByRef Var() As Any) As LongPtr Private Declare PtrSafe Sub CopyMemoryI Lib "k...

 
5:18 AM
I learned a lot about #Excel at the recent MVP summit at Microsoft's campus in Redmond. Some brand new secret things and some things that are public but not well publicised. So read on... https://www.linkedin.com/pulse/secrets-from-mvp-summit-wyn-hopkins
 
@TweetingDuck I think he's referring to our benevolent Mug.
 
5:59 AM
@TweetingDuck time to start tinkering with custom events.
 
 
2 hours later…
8:07 AM
@BloggingDuck something something inadvertent arrow code
 
 
3 hours later…
11:14 AM
sigh
 
@Vogel612 ?
 
the old adage around working on the clock...
 
ah...
 
'specially with the gunking pile of steaming garbage that I'm working on RN
 
btdt, you have my sympathy sir
 
11:20 AM
thanks...
 
'specially since it sounds like its Java... doubleplus-ungood
 
nah. it's not Java... it's JAVA
totally different language
 
oh well, that's something :-)
 
not something good, mind you
 
"It could be worse. It could be Java"
best I stop there, lest I incur the Wrath Of Larry :shudder:
 
11:34 AM
who are you referring to?
 
lol
 
11:55 AM
owait is that a reference to the TENDOT movie?
 
My new favourite GIF to approve PR’s! #clippy #devops https://t.co/72egEr3z5K
 
@Vogel612 Larry Ellison, I think :)
 
hum... that'd make sense, yes.
 
1:03 PM
I like Larry. He has a striking face.
 
@this Is that a pun?
 
Surely, he has been struck many times and will be struck many more times.
 
1:29 PM
0
Q: VBA code on comparing two columns

Subhadip  GhoshNEED VBA CODE FOR THIS PROBLEM. I have two different columns in a spreadsheet, and I want to compare the values of the two and want to display in the third column, whether the values are present I both the columns or if present in one column and absent in another, and vice versa. Please respond ...

 
Pirates of Penzance hasn't lost anything with age.
 
@QuackExchange definitely need to inspect for implicit references to various objects. This code as is is unnecessarily brittle because of that.
 
> Please respond as early as possible, its urgent.
#SignsYoureOnTheWrongSite
2
 
Maybe CR should add "This is not an emergency services. Please call 911 in event of an emergency."
3
 
@this if you argument that correctly, you might get quite a few upvotes on MSO for something like that
 
1:43 PM
@QuackExchange Oh please oh please oh please.....
 
For anyone who wants to commit suicide by looking at back code, they can set up a programming emergency site.
 
Probably shouldn't have 911 in there. 1) I don't think that's international and 2) WTH the 911 operators going to do all those calls "Halp! I need code right now!"
 
> Please call your local emergency number.
 
~sigh... I'm not sure whether the crap thingy I have here works now ..
 
@this 999 here, or the euro-wide 112 (which almost no-one knows about)
 
1:45 PM
@mansellan I wonder if it works in the US.
You guys can't do anything if I try, right?
 
I always heard it was 911 to avoid accident button mashing. Wouldn't 999 or 112 be liable to that?
 
Even if you did, I bet the US wouldn't extradite me.
 
@this perhaps, idk
 
And if they did, I'd have already lost the case, so I'd just troll the court as hard as possible.
 
but 999 predates phone buttons, back to the days of clicky-dials
 
1:46 PM
nrghhhhh... damn you OSGi
 
but that's even worse!
 
why you make it so easy to completely fuck up the basics of how DI works as a decoupling framework?
 
I mean, you wait the longest on the rotary on the 999 in a case of emergency
I mean, don't you want it to be 111 so you don't have to watch rotary unwind itself for so long?
 
yep, the irony has been noted by others
 
Maybe back in the day, emergencies were less emergency-y.
Like, everyone knew how to take care of themselves, and their neighbors would come to their aid too.
It was probably mostly used for fires at first, TBH.
And for a long time even then in many places, they just rang the fire bell, and everyone came to help.
And yes, the first two lines are sarcasm. I just forgot to use the sarcasm font
 
2:02 PM
I'm starting to longingly stare at intoxicants at this point...
oh wow... @spolsky is giving up his CEO job
 
Isn't that old news?
There's lot of changes lately at Fog Creek Glitch Software
 
@this What a weird name for a software company. It's... less than optimistic, for sure.
 
Yeah. They also renamed FogBugz to Manuscript which made zero sense
then they sold it to another company who had more sense to restore the original name.
they're now all about the "Glitch" software... whatever it is.
 
2:47 PM
@this not at Glitch (fka. Fog Creek). At Stackoverflow Inc.
in The 2nd Monitor, 45 mins ago, by Feeds
Joel Spolsky on March 28, 2019

Big news! We’re looking for a new CEO for Stack Overflow. I’m stepping out of the day to day and up to the role of Chairman of the Board. Stack Overflow has been around for more than a decade. As I look back, it’s really amazing how far it has come.  Only six months after we had launched Stack Overflow, my co-founder Jeff Atwood and I were invited to speak at a Microsoft conference for developers in Las Vegas. We were there, I think, to demonstrate that you could use their latest ASP.NET MVC technology on a real website without too much of a disaster. (In fact .NET has been a huge, unmitigated …

 
Huh. I thought he already left SO long ago
 
Jeff did
 
Oh okay. Probably conflated the one with other.
Joel's (and maybe Jeff's, too) MO seems to be starting something cool then bail out before it burns'n'crash.
half-kidding
 
Jeff went on to start discourse, which is used extensively across multiple platforms nowadays
 
yep
 
2:55 PM
also there's some drama around stuff he said publicly and on meta about SO the company ...
sooooo .... ~shrug?
 
Still, you got to give them props - IINM, before the SO was a thing, Jeff gave Joel a uh, chastening over the wasabi thing, but they ended up working together to make SO.
 
right. that happened
though most of the pre-SO history of the two is basically ancient internet history by now
 
@Vogel612 Jeff?
 
@Hosch250 Atwood
 
I meant, drama about Jeff?
 
3:00 PM
yea, here and there, this and that. Best lost to history
 
TBH, I think Jeff has a clearer view of what's going on with SO than Joel; probably partially because he's not in it anymore.
I don't know all of it, but I think he's right about the welcome thing. That it's decreasing the quality of the content.
@this That's actually a reasonably MO.
Not everyone can start new things and make them successful, and not everyone can run them in their maturity. It takes different business models.
 
@Hosch250 being a hipster is reasonable?
;-)
 
Some people think so :P
 
3:25 PM
I wonder if one can write a refactoring to convert all those stupid global expression into a local variable.
 
System I built just got a shout-out from the CEO in our monthly towhall :-)
3
 
:+1:
 
:blush:
It's adding way more to our bottom line than my salary costs, so that's nice...
 
3:41 PM
Shouldn't everyone's value?
Or did you just pay for your salary indefinitely with a one-off system?
 
@Vogel612 RE: Arrow code. I'd consider 2+ levels deep arrow code. Would it be better to invert the if statement in the style of a guard clause?
 
@IvenBach that's exactly what I was trying to get at.
 
@Hosch250 sure, but it's nice to get it confirmed
 
:D
 
@Hosch250 besides, I've worked with several people I consider to be net-negative - it would have been better value to pay them not to come in than to let them within 50 miles of a compiler...
 
3:46 PM
LOL.
 
@Vogel612 FWIW in VBA's case, there's less of an incentive due to two problems: 1) lack of a proper return statement and 2) too many ways to exit the procedure wrong.
 
@this Exit Sub ftw
 
or Exit Function, and that can be a bad thing to do.
 
because you're not required to set a return value before invoking Exit Function?
 
If there's a cleanup (analogous to finally), then you need GoTo ExitProcedure instead of Exit XXX
 
3:49 PM
that's got nothing to do with the extraction though...
and if you can't see that there is a "finally" in your procedure, you deserve to get screwed over by incorrectly exiting it
 
so that's already 3 or 4 ways to exit a procedure. Personally I prefer doing ErrEx.DoFinally if you have vbWatchDog
The point is that it's not refactoring-friendly.
 
so?
 
that means more work to be done to extract and create a proper guard clause
 
@mansellan I feel the heat coming through the monitor.
 
(or adding a cleanup if that comes later)
 
3:51 PM
that's not really prohibitive of using guard clauses though...
 
No, it's not. What I'm saying that it does create more opportunities to do the wrong thing
 
it just means you got to pay attention instead of being able to rely on your IDE to do that work for you
which is not surprising given the state of the VBE :/
 
Oh, no sweat. Let me add that one more detail to 1000 other things I'm juggling in my mind.
Yeah, I wonder does RD inspect for improper use of Exit XXX in a presence of an On Error GoTo XXX -- that would be almost certainly wrong.
 
no we don't but that's an excellent idea
Hey Iven, I think we found your new feature to work on :)
 
it's complicated, though - there are many way to write the error handling and it might not even have a cleanup section.
in which case, the Exit XXX is apropos.
 
3:53 PM
Rubberduck inspections are allowed to be opinionated
 
so it'd have to somehow detect that there is a cleanup section (probably by inferring from the presence of Resume XXX
 
cleanup section always has a jump label, does it not?
 
usually yes.
 
so if there's a jump label in your procedure and you call Exit, we can flag that up as an information
that's the minimum viable prototype
 
ah, but an error handler has a jump label, too.
That needs to be excluded.
and we probably don't want to flag an ordinary label used for GoTo in some moronic loop or something like that.
 
3:56 PM
oddly appropriate VBA question incoming
 
I think Resume XXX is a sufficiently good enough indicator there's a cleanup section and thus requires extra attention
 
@Vogel612 I didn't fully understand the implications my "qualified to work on RD" comment would have. :p
Is it better practice GoTo a cleanup and then Resume, rather than another GoTo, to semantically indicate continuation?
 
0
Q: Worksheetfunction.Vlookup value on error

a1a1a1a1a1I have this function (wb is a public workbook variable): Function GetTiersAccount(TiersName As String, Clients As Boolean) As Long If Clients = True Then On Error GoTo ERRRRR GetTiersAccount = WorksheetFunction.VLookup(TiersName, wb.Sheets(1).Range("A1:B13"), 2, False) Exit Function...

 
@IvenBach Resume allows you to handle stuff properly and allows you to define semantically appropriate continuations
Resume vs. Resume Next vs. Resume <labelOrLineNumber>
 
4:12 PM
:click: That's why test subs that are expecting an error use Resume instead of GoTo. They both jump but difference in intent.
 
note that you should not GoTo out of your error handler. That's bad juju
BUT - if you are not in an error state (e.g. you just want to bail out early because of a guard clause, then you must use GoTo, not Resume.
that's what I hate the most about VBA - too many ways of doing things, depending on the context, which makes it very easy to do it wrong.
 
Understanding has been slow in coming. I see the light now, or is that just a yellow duck?
 
which is why again I prefer using vbWatchDog whenever I can and use ErrEx.DoFinally
unlike vanilla VBA, this works all the times, whether there's a clean up section or not
and regardless of whether it's a sub or a function
 
pop quiz: When would you folks expect Files.copy(source, target) to throw a NoSuchFileException?
 
When locating the source?
 
4:18 PM
^
 
Whoa hive-mind affect.
 
please don't say target threw that....
that would be utterly ass-backward
 
kinda expecting it at this point though lol
 
yeah, else Vogel wouldn't have pop-quizzed us
 
4:19 PM
yea, target threw that..
 
of course.
 
of course if source is missing, it will also blow up.
 
so really Copy is more like Overwrite
 
but if the parent directory of target does not exist, it will not be created, instead it's just going to throw NoSuchFileException
which is somewhat misleading, because it actually is missing a directory
@this only if you pass CopyOption.OVERWRITE
 
ah, ok
 
4:22 PM
in other news..
 
I guess they got lazy with the implementation; "meh, NoSuchFileException is good nuff"
 
bring on the renewal committee
 
:+1:
 
Notoriety++
 
@this considering that I'm on Linux it's semantically correct
since directories are just special files
(which is also true for NTFS directories, but that's a different story)
 
4:24 PM
Sure, but it is useful to know that it's not erroring because the target file was malformed but rather that the directory to put target doesn't exist.
wrong level of abstraction, IOW
 
is there a good way to see if a variable exists?
 
Rubberduck has find symbol (ctrl + t)
 
for example, i have a variable that i have to define that has the application's id number
but if i for whatever reason (or someone else forgets to define it) i wanted to find a way to have it work if that variable wasnt created
 
@KySoto you force people to use Option Explicit and whack them with a 2x4 if they don't compile their code?
2
 
i already do force everyone to use option explicit
 
4:28 PM
@KySoto "Variable 'foo' is not declared" would be all over your inspection results
 
and @Vogel612 its the Clue by 4
thats true, but one of the people who may forget to define it is the engineer who doesn't have RD installed.
 
then they still should be compiling and using option explicit
 
and they should get RD, for their own good :)
 
@KySoto Force-install it.
 
he still likes to use dlookup to pull multiple fields out of a record.
 
4:29 PM
if Ky's code compiles against a variable that needs to be added downstream they need to define that
 
@Vogel612 @MathieuGuindon That's an idea for the next logo of RD.
Option Explicit underlined with a 2x4.
 
@Hosch250 lol, while i am in IT, i dont know if i could get awya with that
 
On boot -> check if RD is installed. If not, install it :)
 
ahh yeah, i dont have access to group policy
well, technically i do, but
 
why? Per-user install is fine
 
4:31 PM
maybe you can mess a bit with the default image?
 
its not really my area of responsibility
 
We enabled per-user install specifically to enable the scenarios where workers wouldn't have the rights to install programs.
 
oh, i meant that i cant force him to install it
 
you probably have images to set up a new machine from scratch, do you not?
 
4:33 PM
My co-worker manages all of the images
 
Add Rubberduck in the latest stable version to that image :)
 
@MathieuGuindon Research & Development?
 
@Vogel612 while that sounds like fun, i doubt my boss would find that an appropriate use of my time
 
@KySoto why does your image process make that take longer than half an hour?
 
This is weird.
 
4:35 PM
I dont know, my co-worker is the one who handles it lol.
 
IE's HTML renderer is faster than my other browsers.
But the dev tools and JS are slower.
 
my IT skills are rusting though
i can feel it
 
@Hosch250 no. Regional Directors
 
Oh.
 
No clue what they do, though.
 
4:40 PM
@Hosch250 whatever it was, I had to snap a picture of it and put it here :)
(summit lunch signs aren't under NDA, right?)
 
nah
 
@MathieuGuindon I'll miss you when you're shoved into a van
 
For whatever reasons, RDs come to MVP summits; not sure if they actually participate in any of sessions or if they have their own track and are simply piggybacking the MVP summit
 
@this Or watch via hidden cameras
 
O_o if they can do that... why even bother coming in person?
 
4:44 PM
lol
 
I take that you haven't met a RD, @MathieuGuindon ?
I haven't.
must be like wumpus
 
Good question. ...I think I'm mixing up the position with CPM (?)
 
yeah, I think they are 2 different things
no, wait. the CPMs were there, weren't they?
RD could easily be an umbrella term for CPMs (and other staff in that area)
 
4:59 PM
I snapped that pic on Thursday IIRC
 
5:36 PM
> We currently identify classes with a predeclared ID in the code explorer, and that's awesome.

Let's do a similar thing for default members, i.e. append " (default)" to the node text of a class' default member.
> This is feeback for information purposes only. I'm not complaining or reporting a bug.

**Rubberduck version information**
Version 2.4.1.4627
OS: Microsoft Windows NT 10.0.17763.0, x64
Host Product: Microsoft Office x64
Host Version: 16.0.11425.20184
Host Executable: WINWORD.EXE

**Description**
I'm not a professional programmer but am developing a suite of macros for managing document structure in Word. I'm currently upto 124 modules containing just short of 11,000 lines of VBA co
 
@Duga Honestly I think he's lucky to only have 30-35 seconds to refresh on his codebase.
The windowing issue seems to be problematic in more than one way.
 
just found something thats kinda neat, im sure yall have seen it before though, pgacon.com/…
 
I am a Rubberduck user myself ^^ And the magic comments are something I didn't know about, at least not the ones you mention here. But they seem super useful as having to export, edit, and import again is a real hassle. Would be great if you could document all of your magic comments somewhere, but that should probably be an issue in your github project ^^ — Jonas Glesaaen 7 mins ago
 
5:53 PM
> FWIW, this feature would be also easy to implement for other stuff like enumerator. In VB6, there are additional special members that would be easy to trivial. I would probably want a generic approach so that any member can be then surfaced simply by implementing an interface? adding an entry in resource file? something.
 
@Duga yes!
 
uhh... "easy to trivial".... WTH am I writing?
 
> FWIW, this feature would be also easy to implement for other stuff like enumerator. In VB6, there are additional special members that would be easy to implement as well. I would probably want a generic approach so that any member can be then surfaced simply by implementing an interface? adding an entry in resource file? something.
 
I really need to proofread more... :(
 
@Duga "not a professional programmer, 124 modules 11kLoC and not scared of moving stuff to C#". One of these is not like the others
 
6:01 PM
lol
 
Imposter syndrome at its finest?
OTOH, it might just mean lot of code done wrong.
beginner code has a tendency to contain a fair number of copypasta
 
that last part just makes me think that's not the case here
 
Oh, yeah
However (and unfortunately), you still can write crappy code in any language.
 
~meaningful sigh
you're preaching to the choir here :)
 
am I? Lemme try thumping the bible...
 
6:14 PM
:sings:
 
just wondering if it's a just-me problem or not - anyone noticing a significant delay (and freezing) when trying to navigate to a module as soon as you open VBE?
 
Had that the other day, but in VS...
 
btw @this will you open an issue about the error handler stuff we discussed earlier?
 
@neiltyson The only thing flat-earthers fear is sphere itself.
 
on it
seems there's already #3194
 
6:26 PM
@MathieuGuindon :+1:
 
i think i'll just add to 3194 instead of creating new one
 
@MathieuGuindon Welp, I guess CodeReview would've graduated a few weeks sooner with that one :D
 
Didn't know about Demon Haunted World till that tweet. Definitely purchasing to read.
 
I should start a Earth-is-a-cube society. See how it goes.
 
6:34 PM
@this If you want to practice troll/debate skills, sure.
I wonder if I could prove that any politicians used to be part of that club. That would be #fun.
 
I am not so interested in arguing with people but more whether I'd actually get a following just because I said so.
 
@Hosch250 start with the climate change deniers, I'd assume there's quite some overlap
 
Probably hard to do since lot of people follow ironically
See: flying spaghetti monster
 
@Vogel612 As far as I'm concerned, I try to stay out of that.
Personally, I don't think we understand climate well enough to even try to mess with it one way or another.
After even the director of NOAA even resigned over having falsified climate data, I'm not planning on getting into it.
 
Reminds me of this:
 
6:41 PM
@Vogel612 I am also not a professional programmer.
 
@this LOL, nice.
TFW a murderer gets 2 days in jail.
 
wait, what?
he walks after that?
 
@Hosch250 your "justice" system is a frigging mess
 
Yeah, someone pushed someone else off a bridge.
Somehow they got off with reckless actions and unintentional manslaughter, or something.
@this And it's a woman.
 
but normally manslaugther sentences are longer, no?
 
6:44 PM
No idea.
It's heavily up to the judge.
 
(and why is it a manslaughter? Does that imply that women cannot be slaughtered?)
 
Like, that rapist in California who got off with a few days too, after openly bragging about it. Fortunately, that judge was recalled.
@this I think it dates back to the term 'man' meaning 'human'.
 
that's deserved (Judge's recalling)
I know. I was being funny.
 
@Vogel612 that
 
@MathieuGuindon LOL, you guys have basically the same one.
TBH, I think terms for recklessness resulting in manslaughter should get even longer terms than a plain old homicide.
At least with a "real" murderer, you know they are out to get you.
 
6:47 PM
well we have this thing about minimal sentences, across the entire country, for one
 
Actually, in Germany it would depend on a few factors whether it would be murder. But manslaughter would cause a longer sentence anyway.
 
criminal law is federal, not per-province
heck, or per-judge
 
@Hosch250 so much true
 
Technically, they judge couldn't do that much about it. If they only found her guilty of acting recklessly resulting in the unintentional death of someone else, they don't get very much.
She'll probably have community service on top of it.
 
$20 she's white
 
6:52 PM
@Hosch250 the correct term now is 'huperson'
 
Hi guys. Sorry to bother you. Any second opinion?
https://stackoverflow.com/questions/55404457/how-object-passed-as-an-argument-byval-should-behave
 
@MathieuGuindon Considering some 77% of the population is, you have a pretty good chance of winning...
 
yet that's not the proportion of "criminals" touted by the right
anyway, </politics>
 
Not by the left either...
 
@DJVillareal there's almost never any reason to pass anything ByRef
 
6:57 PM
@Vogel612 correction "Americas". Pretty sure I know Hosch's system would be less messed up.
For all the #MuricaPride pineapples have I'm more depressed by the facts of how messed up things are.
 
00:00 - 19:0019:00 - 00:00

« first day (1756 days earlier)      last day (1424 days later) »