VBA Rubberducking

Duga

00:01

RELOAD!

[AndaraCodes/AdventofCode2019] 3 commits. 1922 additions. 24 deletions.

[MDoerner/AdventOfCode2019] 4 commits. 1890 additions. 9 deletions.

[Phrancis/AdventOfCode2019] 1 commit. 105 additions. 44 deletions.

[Zomis/AdventOfCode] 1 commit. 66 additions.

[Minesweeper] Games Played: 50, Bombs Used: 32, Moves Performed: 5491, New Users: 8

Quack Exchange

02:23

0

Q: VBA how to shorten runtime using functions other than .find

My code here loops through my folder and my files inside the folder and use.find and copy the strings into a new excel sheet and then with all the data in the new sheet, i will use .Find(What:=) to find the strings inside the new worksheet and then either split or use Right,Left,Mid functions, so...

Freeflow

04:54

@SimonForsberg I"m giving it a go in VBA. 7 stars at day 8. Day 7 part 2 is giving me a bit of a headache my computer passed all the testinputs but gives the wrong answer. Time to write some proper ducky tests methinks,

IvenBach

06:27

@QuackExchange @MathieuGuindon how do you avoid getting nerd sniped by those type of questions?

I see their best attempt and potential to learn. Past-Iven doing his best to get it right but not knowing how drives me to answer.

Going in I knew it wasn’t fully ready for a review but the nerd snipe is strong out of compassion to Past-Iven and his woeful ignorance.

Quack Exchange

09:58

0

Q: C# Dictionary Wrapper for VBA

I am a technical reviewer/writer and I use I use VBA for Word a lot to manage issues in Word documents I receive. I have frequently come across niggles when using Collections, Scripting.Dictionaries or Array lists. Then I saw some posts on creating a C# library for consumption by VBA. After mu...

c# beginner vba interface com

FreeMan

13:39

@BloggingDuck Very appreciated. Feels like an article of two unrelated parts: 1) the Doc Class at the beginning. 2) Work[book|sheet] referencing after the Accessing Worksheets heading. Am I missing the link between the two?

Freeflow

Feel free to have a giggle . Advent of code day 9

https://www.reddit.com/r/adventofcode/comments/e85b6d/2019_day_9_solutions/fa9xbtk?utm_source=share&utm_medium=web2x

FreeMan

If I'm reading the first part correctly, in Excel the evils of putting my code in the code behind are: 1) any (implicit or explicit) public method is available in every other code module, 2) ActiveWorkbook is the work of Satan and to be avoided at all cost.

Oh, and they require special handling when importing/exporting the code to ensure that they don't lose all the special things about them as doccls modules.

Am I missing anything?

Cyril

why clnglng when you can variant?

i kind of want to say /s but i'm partly serious

12 bytes of fun

Freeflow

14:04

@Cyril Because the computer has to calculate numbers bigger than Long. The the compuer uses self modifying code so that it can load numbers which have been stored as LongLong. This threw up a deficiency in the Kvp indexer in that it is based on C# int (equivalent to VBA Long). The Kvp (operative through com) is very fussy so if I sore a value using a Long value as a Key then you get an error if you use the same number but as a VBA Integer or LongLong.

@Cyril e.g. One of the test cases for day 9 was for the computer to calculate 34915192 *34915192

Cyril

got'cha

you got an upvote, at least (mine)! good luck on day 10

so many python entries on that thread

holy shit, the dude who solved it in lua

Cyril

14:29

@Freeflow do i need to have some specific reference to get CLngLng to work? i was trying to screw around with it and get "Sub or Function not defined"

and i'm following like 10% of your code. so much going on lol

Freeflow

@Cyril You may only get ClngCLng if you a 64 bit installation of Office.

Cyril

thought i had 64 bit; was just re-checking

x86, SOB

this

#FunFact: you can get LongLong in 32-bit VBA. You just can't declare it.

like decimal, you'll have to use Variant and rely on some external function to return a variant that has the subtype of I8 (maps to LongLong)

Mathieu Guindon

15:19

RD News update: 2018 was +24K views over 2017. 2019 is +24K views over 2018. Was hoping for 50K views this year, we're currently just under 60K and there should be another bump in a week or two when 2.5 is released!

3

Mathieu Guindon

15:36

> Will RD point out when we could be using early binding in preference to the late binding we've coded?

(reddit)

this

The only time where that would be unconditionally true is if the library referenced has events being subscribed.

But using a late-binding code even if the library can be referenced by itself is not a code smell, necessarily.

FreeMan

15:57

@MathieuGuindon thoughts? chat.stackexchange.com/transcript/message/52846264#52846264

Mathieu Guindon

@FreeMan not sure what the problem is... first the module type is introduced and described, and then I go on to explain how to use them?

FreeMan

@MathieuGuindon It's probably just me. I'm having one of those days. It'll probably make more sense tomorrow.

this

17:38

Got a spammy email from a "Joe Goldberg". Almost disappointed it wasn't "Rube" instead of "Joe".

Mathieu Guindon

lol

let me guess, "would you like to join my network on linkedin?"

this

no, marketing stuff for some online service

FreeMan

that's kinda funny

Cyril

18:01

@MathieuGuindon linkedin learning can go to hell... like 20 emails a week

all from different emails, so have to have rules for each

IvenBach

18:19

~.~ when the macro recorder actively records a blatantly incorrect instruction.

this

You sound surprised.

Feeds

Cyanobacteria wiped out nearly all life on Earth once before, and they can do it again!

IvenBach

More like dismayed. Toggling off formula autocompletion via the UI Application.DisplayFormulaAutoComplete = False instead records Application.EnableCheckFileExtensions = False is an 'Uh.... Wut?' type of fail.

Mathieu Guindon

18:43

@IvenBach I don't

actually in that particular case, I consider the OP too light on meaningful info

they want a more efficient approach, but they're not telling us everything that's going on with their current one

IvenBach

I knew that going in with the missing Public Sub Foo().

Mathieu Guindon

    .Range("Results").Calculate
    .Range("Results").Copy

this is what's bothering me

I asked the OP to supply the formula for this Results range, and I'm not reviewing it until it's in the post

IvenBach

If auto calculate is turned off for Excel IMO something is wrong.

Mathieu Guindon

#Depends

but yes, in general it's a fairly good indicator of inefficient code :)

IvenBach

There may be some times it's valid, but I have yet to find one.

Feels like Russian Roulette withe 5 loaded chambers.

Simon Forsberg

19:11

@Freeflow For Day 7 Part 2 you need to make sure that your programs can pause when they need more input and that they keeps their state (with the current memory) until they get another input. But yeah, test-cases are good to have.

@MathieuGuindon @Duga wants stats!

Mathieu Guindon

hm, does WP have a REST API I can use to query those?

Simon Forsberg

@MathieuGuindon Wordpress? If not, I'm sure there's a plugin for it.

Mathieu Guindon

I don't have any stinkin' plugins :)

(been on the free plan for 5 years!)

Simon Forsberg

Good for you :)

Mathieu Guindon

interesting

IvenBach

19:16

Those "Doctors warn 'Don't eat this one fruit...' " don't concern you Mug?

Hosch250

@IvenBach Huh? You mean the web has ads on it? Who'd have realized it!

In fact, I forget that regularly because I use adblock (uBlock Origin is my latest choice).

IvenBach

@Hosch250 Kind of like how governments are infested with leeches and other blood suckers. :wink:

Mathieu Guindon

speaking of fees... I need to update my CC info on GoDaddy so they can proceed with the renewal in Feb.

Hosch250

> They have set of punishment rules for employees, for example starting the working hours is 8 and if I go to work after 8:45 they record that as an absents and will double it if I don't go to work, meaning they will cut a day of my monthly payment and will cut another extra day for punishment if I don't go to work that day.

Wow. That's actually pretty lenient they have a whole 45 minutes...

Mathieu Guindon

I'd like to ditch them and go hosted on Azure, but Azure has this "we're all about .NET Core" buzz/feel to it, and I'm pretty sure our indenter won't run on Core.

Hosch250

19:20

In most construction work, you have 5 grace minutes before you are marked "absent" for the whole day.

@MathieuGuindon Nope.

They have better Framework support than Core.

Mathieu Guindon

cool then

so I'm not renewing with GD in 2020

and RD 2020 will get HTTPS at long F'n last

Simon Forsberg

@MathieuGuindon AWS FTW! <3

I am considering migrating our friend @Duga to AWS.

I had AWS training with work about a month ago, I learned a lot!

Hosch250

@SimonForsberg I talked to an AWS advocate from Amazon a few months ago. They were trying to tell me the cheapest I could get a SQL DB for dev work was $70/month.

I don't know if that's accurate, or they were trying to sell me a business plan, but I pay $5/mo for an unused DB at Azure, and $15/mo if I actually use it regularly.

this

$70 sounds like a SQL DB on a VM

Hosch250

@this Oh, makes sense; that would be about the same as Azure then.

Mathieu Guindon

19:28

we're on AWS here at work, no idea about billing, but we're on MySQL & PHP so likely cheaper

Hosch250

And I still have my "student" account at Azure, so I can host websites for free there.

Simon Forsberg

@Hosch250 Depends on what kind of DB you want/need and how much you would use it. I'm currently running DynamoDB (a NoSQL alternative) for free in AWS.

I believe AWS supports Postgres as well, but I'm not sure how much it costs.

But anyway, never trust sales people.

8

Hosch250

@SimonForsberg I can get Mongo for free, with good C# drivers.

this

IDK if migrating to other RDBMS is practical, though.

Hosch250

@SimonForsberg I bet they do, but I don't know that one.

Also, work uses Azure, so I'm learning it for them anyway :)

Simon Forsberg

19:29

@Hosch250 On AWS?

Hosch250

@SimonForsberg From the Mongo people.

Mongo Atlas, I think it's called?

Simon Forsberg

@Hosch250 Postgres is fairly simple. Quite similar to many other SQL DBs.

@Hosch250 Ah, right. Sure, that's an option but I personally like that AWS has everything, instead of having the db here and the website there and so on.

Hosch250

Yeah, that is nice.

I could do that with Azure's Cosmos DB too, but that's a bit pricier.

Simon Forsberg

Anyway, as all of you are more Microsoft ~~nerds~~ fans, I understand why you go with Azure instead of AWS :)

this

FWIW, I looked at Amazon monthly calculator and nothing resembling Azure SQL leaped out to me.

I see there's RDS but it doesn't let me choose whether it's SQL Server or MySQL or PostgreSQL

Hosch250

19:31

Well, it's more that 1, I already know some of it, and 2, I need it for work anyway.

Simon Forsberg

I did pay Amazon 0.66 USD last month. 0.50 for using their DNS nameservers. 0.01 for Cloudfront, and the rest in taxes.

Mathieu Guindon

@SimonForsberg well, that and having an Azure credit as a perk of being a Microsoft MVP :)

Simon Forsberg

@this aws.amazon.com/rds/postgresql

@MathieuGuindon Oh that's nice.

Mathieu Guindon

'bout time I start considering using them :)

Simon Forsberg

Yes, definitely.

It's all about the cloud these days.

this

19:34

I had to dig to find those 2 pages:

aws.amazon.com/rds/sqlserver/pricing

aws.amazon.com/rds/postgresql/pricing

Yet, I can't select either from the calculator: calculator.s3.amazonaws.com/index.html

:derp: there it is. I somehow missed it because I was looking at the size.

Simon Forsberg

@this Quack :)

this

Anyway, it seems to be indeed ~$100 for smallest instance

Whereas PostegrSQL is ~$43

Simon Forsberg

@this No free tier?

this

Interestingly, on Azure, I can go as low as $5 for Azure SQL but only $50 for PostgreSQL

not that I can see

Duga

19:52

[rubberduck-vba/Rubberduck] testingoutgith1 opened issue #5313: Stack Exchange chat access request

> Per the instructions [here](https://rubberduckvba.wordpress.com/2019/07/15/modern-vba-best-practices-default-members/#comment-2623) for the case that one does not have 20 rep on SE, which I don't as I did not have an account until very recently. Please just let me know what you need from me.

I chose Thanks! as the "issue" because it seemed like the most appropriate for such a request. Rubberduck has been a very beneficial tool for getting unstuck on a project that felt like it had an unmana

[rubberduck-vba/Rubberduck] testingoutgith1 added label thanks to issue #5313: Stack Exchange chat access request

[rubberduck-vba/Rubberduck] retailcoder created comment on issue #5313: Stack Exchange chat access request

> Thanks for the feedback! You can join the chat here.

Mathieu Guindon

@all please ping me when testingoutgith1 shows up :)

(or Vogel)

Vogel612

yeap, if I'm likely to be awake at that time :)

Simon Forsberg

@MathieuGuindon @Vogel612 showed up now ^^

Vogel612

@Duga @MathieuGuindon you'll want to tell them what we need to grant access, btw.

Mathieu Guindon

:facepalm:

Duga

19:57

[rubberduck-vba/Rubberduck] retailcoder edited comment on issue #5313: Stack Exchange chat access request

> Thanks for the feedback! You can join the chat here, and then a moderator can grant you explicit write access.

Vogel612

I see you've not gotten around to your second coffee of the day yet?

mug...

Hosch250

@Vogel612 At 3PM?

Mathieu Guindon

had the 2nd, need the 3rd now

YES AT 3PM!!

:)

Simon Forsberg

@Duga What if their username will be different?

Mathieu Guindon

it probably will be

Hosch250

19:58

First non-write access user to show up gets write access?

Vogel612

@Hosch250 depending on when I wake up, at 3 PM is my first coffee or my third if I allow myself a third for the day

usually my second is between 3 and 4, though

some days are worse than others

Hosch250

Well, I'm at work at 7AM, and get up at 5:30AM, so that would be super late in my day. I get off work at 3:30PM.

Vogel612

I usually fall asleep between 2AM and 4AM, so I don't wake up before 9 unless I have an alarm set

and since I'm a student, I usually don't set one :D

Hosch250

My brother does the same, except he won't get up before noon.

Drives much of my family nuts. I used to do 12-9:30AM when I was in college, usually.

Vogel612

so coffee is the first thing in the morning (whenever that is) and the second coffee is "not before three and not after six, unless it's friday, saturday or sunday"

Hosch250

20:01

FWIW, though, I still don't drink coffee.

Vogel612

good sleeping habits make it unnecessary

this

unless you're insomniac. Then it's a world of suck.

Hosch250

And a dislike of the smell does wonders.

Vogel612

insomniacs can't build good sleeping habits

this

In my case, I won't drink the coffee because it tastes horrid. The funny thing is that I don't mind coffee's smell but not taste. Tea is my substitute.

@Vogel612 Indeed.

One observes that coffee and beer both are basically acquired taste. Hand either to a kid and they go yeech. Yet adults can't get enough of either.

Hosch250

20:06

Not my ex-bosses son.

She gave him a sip of beer when he was a kid, and he loved it.

this

Oh, he's abnormal.

Hosch250

She's a bit worried about him ending up drunk-driving now.

He still loves it.

He's in HS, I think.

this

hopefully he's legal now

Hosch250

Nope.

this

oh well.

Is his name Abby?

Hosch250

20:07

No.

this

Should be. :)

Cyril

@this mr sister chugged ehr first beer at 2... my father opened one, set it atop a speaker, and went to show a buddy something in the garage. came back and it was gone

@this haha

Mathieu Guindon

@Hosch250 yes, because I need the chat user's ID

this

@Cyril I will assume her name is in fact Abby.

Cyril

the androgynous child shall hereby be named "Abby", be it Abigail (f), Abernathy (m), or other.

Now i'm thinking about "Pat" from SNL having fetal alcohol syndrome... jfc

this

20:14

lol

Cyril

20:26

@MathieuGuindon i had 5 relevant answers on SO alone... i want a "learn to google" close reason ='/

Vogel612

@Cyril there used to be something like that...

Cyril

it's one thing to not know key terms/phrases for what you're trying to do, but he straight up said everything that would be searched in his post

Vogel612

was removed, because it was used as catch-all exclusionary bullshit defense

Cyril

@Vogel612 there're two options for catch-all, now... needs focus or needs details/clarity

there's one for "questions pertains to finding a resource", which i guess is appropriate

Vogel612

these already existed back then, actually

Mathieu Guindon

20:29

nah that's more for things like "is there a tutorial for XYZ somewhere"

or "what book should I read to learn X"

Vogel612

and for "where is docs for Y"

notably not for "What exactly does the documentation for Y mean here?"

Mathieu Guindon

which you sadly type as-is in Google and generally just get it

Vogel612

not true for VBA...

Mathieu Guindon

right.. you get VB.NET stuff

need all the Hungarian-notation-riddled VBA tutorials!

Cyril

it got worse when microsoft changed their site

Mathieu Guindon

20:30

the day F1 stopped working?

(wait does F1 still work?)

Cyril

LOL, months before that, but that was a fun day

it does... if you're logged into an account

@MathieuGuindon not all of them are bad

as in, HN nomenclature

Vogel612

systems vs apps hungarian, again

Cyril

for simple source and destination shit, i start all variables with s or d. quick checks that way

Mathieu Guindon

@Cyril no later than this morning I got served the "p for private is fine it's like an underscore in C#" argument

where "p for private" is, of course, only when you can read the mind of the author

because "p for public" and "p for parameter" are just as applicable

Cyril

"you can p on your own privates"

Hosch250

20:34

@MathieuGuindon The underscore is hotly debated now too.

Cyril

really though, that's about as bad as my standard... "oh, i need one more quick check... dim z as string, done!"

Mathieu Guindon

and creating a private type to properly encapsulate the state is "a hassle"

Hosch250

Current leaning is against it.

Mathieu Guindon

explicit this everywhere has its appeal

problem is enforcing consistency

this

there was also a post arguing against using I for interfaces

Hosch250

20:35

The argument is you shouldn't need this outside the ctor.

Mathieu Guindon

that's idiotic

this

which boiled to being too HN-esque

Vogel612

@this yea, I personally dislike the I prefix, because you should always be programming against interfaces anyways

Mathieu Guindon

it's fully assumed HN

Cyril

don't take away my underscore =/ it's how i survive in the web-world of avoiding "%20"s out the wazoo

Hosch250

20:35

@this This isn't just a post. The linters have all almost universally gone away from recommending the _.

Vogel612

marking interfaces as such pushes an implementation detail into your public API, which is a bad idea IMO

mansellan

@Hosch250 I worked somewhere that dispensed with the underscores. worked fine, the only place you really needed to disambiguate was in ctors.

Hosch250

Yep.

Vogel612

note that "public" in this case also refers to codebase internally public

Mathieu Guindon

TBH the debate is just evaporating all by itself with proper get-only properties

Hosch250

20:36

That was part of the argument I heard.

Vogel612

@MathieuGuindon get-only is not always feasible, though

Mathieu Guindon

true

this

so we basically say to C++ coders "sucks to be you!", then.

mansellan

@Vogel612 I like the I, because Java doesn't do it that way. Is my hatred of Java pathological?

Mathieu Guindon

^ same

Vogel612

20:37

@mansellan there's tons of java code bases out there that use the I prefix

quite a few of them also use the A prefix for abstract classes

Mathieu Guindon

ugh

mansellan

@Vogel612 oh ok, #TIL IIRC their framework classes don't though?

this

Did they ever use underscores for interfaces?

Vogel612

but there's nobody seriously advocating for A

Mathieu Guindon

and they all happily go an name concrete things FooImpl

Vogel612

20:38

@mansellan yea, the framework classes don't

this

Microsoft apparently at one time couldn't make up its mind whether to use _ or I for interfaces.

Access interfaces usually are _'d, Excel's, I.

(IIRC)

Mathieu Guindon

Excel has both

(!)

mansellan

we have to prefix private methods with _

Vogel612

Microsoft can never make up its mind, so that's not really surprising

mansellan

and private class vars with m_

Mathieu Guindon

20:39

with number suffixes, too

this

Yes, but my question was whether Java had that same crisis re: _ / I.

mansellan

and a bunch of other random nonsense I can barely remember...

Vogel612

@this no, because everything's always lowerCamelCase

except for constants

at least that's the usual convention

mansellan

T for typevars doesn't seem to get any hate

Mathieu Guindon

@this no, Java just says "use a name that describes an obviously abstract concept", so you have to remember that List is the abstraction

Vogel612

20:40

depends, actually...

Hosch250

@mansellan The MS teams I've worked with prefer descriptive names.

mansellan

@MathieuGuindon lol wut?

Hosch250

Even when there's just one.

Vogel612

for generic types without any better semantics T is okay, but for stuff like Function<I, R> I'd hate T in either place

mansellan

Oh sure, I do TSource, but always with the T prefix

just T on its own would just be for verygenerics :-)

Mathieu Guindon

20:42

@mansellan think about it: without the I prefix, you have to remember the interface types for the entire framework to know (without looking at any docs or source) what's what. With the I prefix, you can look at a type you've never seen before and instantly know that it's an abstraction.

but then, "but the IDE colors it differently!"

#endless

mansellan

was laughing at Java recommending otherwise

@MathieuGuindon yeah, like I say, I'm a fan

Vogel612

@MathieuGuindon framework is always an abstraction.

always code against abstractions if you can

That's why LinkedList<T> queue = new LinkedList<>(); is crap and Queue<T> queue = new LinkedList<>(); is actually good

IvenBach

As an inexperienced C# coder, without IFoo and IBar I'd be lost not knowing they're an abstraction. Naked Foo and Bar would be quite difficult.

Cyril

just get the world to agree that if a person makes a variable, they must put their initials at the start. then we know who to blame for their preferred notation.
"mgTSource" "who used to work here with initial's MG?!?!?! WE MUST SHAME THEM!"

Vogel612

@Cyril initials are not unique. Also there's git blame for exactly that

Mathieu Guindon

20:46

@Vogel612 see to my C#-trained eyes, Queue<T> queue = new LinkedList<>() makes no sense whatsoever

Vogel612

@MathieuGuindon you'd want IQueue instead?

blegh

Cyril

@Vogel612 rationalizing my joke... that's rough, man.

Vogel612

@Cyril pleasure :)

IvenBach

@Cyril Welcome to my realm of #HumorFail.

Mathieu Guindon

public class LinkedList<T> : System.Collections.Generic.ICollection<T>, System.Collections.Generic.IEnumerable<T>, System.Collections.Generic.IReadOnlyCollection<T>, System.Collections.ICollection, System.Runtime.Serialization.IDeserializationCallback, System.Runtime.Serialization.ISerializable

^ that's why Queue<T> doesn't make sense to me

mansellan

20:48

I read that joel blog on app hungarian. I can see some appeal, but only in very narrow cases. I'd still want to avoid it unless the payoff was high.

Mathieu Guindon

public class Queue<T> : System.Collections.Generic.IEnumerable<T>, System.Collections.Generic.IReadOnlyCollection<T>, System.Collections.ICollection

Vogel612

wow, you folks have it rough with queues, apparently

Mathieu Guindon

huh

mansellan

was less convinced on the exception hating... seems to be the same argument as for "one return per function"...

Vogel612

"All known implementing classes:"

this

20:49

@mansellan The thing is that argument only work when you don't have an IDE.

Mathieu Guindon

@mansellan Apps Hungarian is useful when you're too lazy to make a new type :)

Vogel612

AbstractQueue,
 ArrayBlockingQueue, ArrayDeque,
 ConcurrentLinkedDeque, ConcurrentLinkedQueue,
 DelayQueue,
 LinkedBlockingDeque, LinkedBlockingQueue, LinkedList, LinkedTransferQueue,
 PriorityBlockingQueue, PriorityQueue,
 SynchronousQueue

mansellan

In realtime, safety-critical systems, fine. But you wouldn't use a GC language there anyway

this

well not only, but mostly.

I mean, if you're using an text editor, then AHN would certainly help a lot.

Mathieu Guindon

public class ConcurrentQueue<T> : System.Collections.Concurrent.IProducerConsumerCollection<T>, System.Collections.Generic.IEnumerable<T>, System.Collections.Generic.IReadOnlyCollection<T>

this

20:50

also true for scripting language where everything's loosey-goosey

To be honest, I still do encode my variant data types for that reason.

e.g. SomeString As Variant <- essentially HN-esque

Vogel612

@MathieuGuindon so you can't cast a ConcurrentQueue to Queue?

Hosch250

@Vogel612 Nope. Completely different implementations.

Queue is not threadsafe.

ConcurrentQueue is.

Vogel612

threadsafety is an implementation detail

Hosch250

It's not safe to cast them.

mansellan

same thing with dictionary/concurrentdictionary

Hosch250

20:52

That's what the IQueue is for.

The Queue is a full implementation, like the List.

Vogel612

neither of them implements IQueue, from what Mat posted

Hosch250

/shrug. Basically, everything implements IEnumerable and that's it.

Mathieu Guindon

@Hosch250 there is no IQueue :)

mansellan

@Hosch250 lol

Mathieu Guindon

there's no need, because ICollection abstracts everything that needs to be abstracted already... apparently

hm, annoying indeed that the action of adding an item doesn't seem to be in any abstraction there

mansellan

20:56

Weird timing on this thread, I've finally gotten around to putting together all our IEnumerable extensions into a lib at work, just before I left today...

Mathieu Guindon

at least ConcurrentDictionary implements IDictionary AFAIK

this

considers creating iQueue, iDictionary, iCollection just to annoy everyone.

Mathieu Guindon

@this gets sued by Apple

mansellan

@MathieuGuindon yeah it does, but the API differs by enough that it's unwise to treat a concurrentdictionary as an IDictionary

this

trademarks iApple

Mathieu Guindon

20:58

true that. in any case, a queue, stack, or dictionary is hardly ever exposed anyway...

it is an implementation detail of another object

oh great, Winter Bash has started

IvenBach

I just realized I don't think I qualified this year for Hacktoberfest... Life got in the way and I was 1 commit short.

Hosch250

:(

Mathieu Guindon

:(

my 3rd Hacktoberfest t-shirt is in the mail, apparently

IvenBach

IIRC I had 3 commits then got sideswiped by #TheReaper.

Mathieu Guindon

@IvenBach I see 4 pull requests

did you not get the email from Digital Ocean?

Hosch250

21:10

You did register, didn't you?

Also, you potentially might not have gotten in the top X--not everyone was getting a shirt.

Mathieu Guindon

that sucks

Vogel612

oh wow

Hosch250

You guys didn't see that notice?

They had so many last year, they decided to only give a fixed number away.

IIRC, it was 150,000, or something?

Vogel612

huh, no I didn't see it

I got a t-shirt though, soo ...

guess I was lucky to having needed to open a few PRs for work

Mathieu Guindon

61,956 challenge completions in 2019

> This year, the first 50,000 participants who successfully complete the challenge will earn a T-shirt. (Last year 46,088 earned a shirt!)

(from details)

so, looks like just under 12K no-tee completed challenges

presumably they still get the stickers?

Hosch250

21:14

I was off by only 100,000, and was 3 times higher than the real number. Not too bad?

Mathieu Guindon

mind you, my struggles with the xmldoc PR (4th attempt worked) might have been seen as suspicious

hm, apparently not

IvenBach

@MathieuGuindon None that I've seen. Approximate date I should check between?

I've had several things slip through the cracks in the last 2 months.

#TIL created:BeginDate..EndDate

Mathieu Guindon

@IvenBach likely that your 4th PR was too late to be in the first 50K though

IvenBach

That alone was worth it.

Mathieu Guindon

they started sending the emails around mid-October

this

21:25

Still waiting on my shirt. It might be in Bangkok at the moment.

Mathieu Guindon

IIRC last year I got it at some point in January

IvenBach

I definitely registered. Nothing after the registration confirmation though.

Hosch250

They do the shipments phased too.

Mathieu Guindon

Dec 19 '17 at 0:30, by Mat's Mug

Oh I just received my Hacktoberfest tee (at last!)

@IvenBach go sign in on the Hacktoberfest website, see your profile... what does it say?

this

Hmm. My memory's hazy, though. I can't remember if I got my last one in Nov or in Dec. I want to say Nov but.... ???

IvenBach

21:29

Oooh. This is proof that I'm an idiot.

Mathieu Guindon

@IvenBach you never claimed your prize?!

IvenBach

Nope. Bodies started hitting the floor and less important things got pushed aside while I took care of it.

this

Hmm. last year I did get a shipment confirmation

this year, I haven't gotten any

oh well, no biggie.

IvenBach

@MathieuGuindon Now I did.

this

it'd be hilarious if you still got your shirt even after not having claimed it for months.

Mathieu Guindon

21:44

hey @user12506685 - if you're our friend from GitHub, now is a good time to reply to the GitHub thread saying "yep, it's me!" =)

Duga

[rubberduck-vba/Rubberduck] testingoutgith1 created comment on issue #5313: Stack Exchange chat access request

> "yep its me" :)

IvenBach

@user12506685 Welcome to the pond.

Vogel612

I have explicitly granted you write access

Mathieu Guindon

and done

user12506685

thank you :)

Mathieu Guindon

21:46

hit F5, you can.. oh

@Vogel612 lol jinx

awesome! welcome to our little "war room"

(aka "the pond")

@user12506685 don't hesitate to ask anything, whether it's about using Rubberduck, contributing to Rubberduck, VBA in general, C# or .NET, how SE Chat works, how SE works, or anything else :)

Transcript for