VBA Rubberducking

12:01 AM

RELOAD!

[bruglesco/fleet-command] 1 commit. 25 additions. 8 deletions.

[rubberduck-vba/Rubberduck] 29 commits. 13 opened issues. 7 closed issues. 14 issue comments. 239900 additions. 190956 deletions.

[Zomis/AdventOfCode] 2 commits. 1200 additions.

Mathieu Guindon

@this select the lines in the code file (have them in the url), then click the little ... button on the left, select "copy permalink"

this

Do we have any opinions on doing stuff like IStuff_DoIt() within a private procedure from a class that implements IStuff

Mathieu Guindon

smells, but that's more of a design/style thing

kind of similar to invoking a handler. at least it's private =)

this

12:20 AM

yeah. I guess with so much boilerplate required, it makes it tempting to cut corners to avoid creating yet another private procedure just to handle the interface & internal use.

Mathieu Guindon

Thanks Mathieu. Wow, I had no idea SSIS used .NET for the Script Task. I thought it used VBA which I was somewhat used to. This is way over my head. I think I'll just use the Execute Process Task instead to automate my jobs since the Access files are already built. — Anonymous 10 mins ago

sad ducky

@this well, why not just have the interface implementation invoke the private stuff instead?

VBA & VB6 consistently show up near the top of any "most dreaded languages" lists. Why is that?

Tweeted by rubberduckvba on December 11, 2018 at 11:15 PM

58% for "IDE is under-featured"

IOW if every VBA dev used RD, VBA could significantly reduce its dread..li...ness

this

@MathieuGuindon no it has its own implementation which calls the private procedure also.

Duga

[rubberduck-vba/Rubberduck] Vogel612 created comment on issue #4656: NRE in UnreachableCaseInspection

> closing this as duplicate of github.com/rubberduck-vba/Rubberduck/issues/4659

[rubberduck-vba/Rubberduck] Vogel612 closed issue #4656: NRE in UnreachableCaseInspection

[rubberduck-vba/Rubberduck] Vogel612 is checking what fun stuff @Duga can say about project cards

[rubberduck-vba/Rubberduck] Vogel612 added label duplicate to issue #4656: NRE in UnreachableCaseInspection

[rubberduck-vba/Rubberduck] Vogel612 added label regression to issue #4659: NRE in UnreachableCaseInspection

[rubberduck-vba/Rubberduck] Vogel612 created comment on issue #4659: NRE in UnreachableCaseInspection

> was previously reported under github.com/rubberduck-vba/Rubberduck/issues/4258

Vogel612

12:52 AM

time for me to hit the hay. somewhat more on my usual schedule :D

Mathieu Guindon

@Vogel612 'night!

Duga

1:41 AM

[rubberduck-vba/Rubberduck] comintern synchronized pull request #4650: Locked references removal fix

Comintern

1:58 AM

Gah... Why didn't that pull the rest of that commit?

Duga

[rubberduck-vba/Rubberduck] comintern assigned comintern to issue #4651: Add/Remove References delay

[rubberduck-vba/Rubberduck] build for commit 35949d66 on unknown branch: AppVeyor build failed

BUILD FAILURE!

[rubberduck-vba/Rubberduck] comintern synchronized pull request #4650: Locked references removal fix

this

@Duga I think you need the reset of cursor in a finally block

Comintern

Wrap the whole thing in a try? Not a bad idea.

this

Yeah. Don't want them stuck with forever waiting cursor if something goes wrong there. ;)

Comintern

I'll catch that in a sec. Might as well wait for AV to finish.

IvenBach

2:15 AM

Pond report: :+1: for no pain. Don't feel like doing anything requiring thinking though...

Comintern

:thumbs-up:

Mathieu Guindon

@IvenBach squirrelized much?

IvenBach

As in swelling/chubby cheeks? None at all.

Mathieu Guindon

wow

IvenBach

I'm still as ~~dead sexy~~ fugly as ever.

2

Mathieu Guindon

2:19 AM

lol

IvenBach

Just bored.

Comintern

I would love to be bored. I need to take about a month off work...

IvenBach

I would like work to be assigned. We're on opposite ends of the work spectrum.

Mathieu Guindon

@IvenBach I can go through a number of issues and assign them to you if you want =)

IvenBach

Downloading PoE update.

Mathieu Guindon

2:25 AM

PoE?

IvenBach

Path of Exile.

Mathieu Guindon

ah

IvenBach

You figure out my build issues on work box and I'll be able to work on RD at work.

Mathieu Guindon

Nuke it again?

IvenBach

Done that 3 times so far.

Mathieu Guindon

2:30 AM

got teamviewer at work?

Duga

[rubberduck-vba/Rubberduck] build for commit d30fc88b on unknown branch: AppVeyor build succeeded

IvenBach

Yeah. But I'm not willing to ask nor have IT ask who's connecting.

Duga

[rubberduck-vba/Rubberduck] comintern created comment on issue #4647: Add/Remove References Dialog isn't wide enough. AKA "Werez mah buttunz!"

> It wouldn't seem like it, but a ListView is absurd difficult to keep the column sizes in sync with a sizeable container without switching the item display container to a GridView (which only makes it merely difficult). The problem with using a GridView for this IMHO is that it is thermonuclear overkill for what it would be doing, and even then the process of keeping everything aligned at the correct column sizes is expensive as hell in terms of processing. Granted, there aren't a ton of re

Comintern

@Duga That's the stuff.

Duga

[rubberduck-vba/Rubberduck] comintern synchronized pull request #4650: Locked references removal fix

Mathieu Guindon

2:47 AM

@Duga @Comintern that works perfectly

Comintern

Cool. On the way.

Duga

[rubberduck-vba/Rubberduck] comintern assigned comintern to issue #4647: Add/Remove References Dialog isn't wide enough. AKA "Werez mah buttunz!"

Mathieu Guindon

Hey do the arrow buttons and other icons in the listviews have tooltips?

Comintern

No, but they easily could.

this

@IvenBach you could daisy chain; work to home, then to one of us.

Thus if they ask you were remoting from home

Mathieu Guindon

2:52 AM

Doesn't it just connect to the TeamViewer server?

IvenBach

@this Hadn't thought of that...

this

@MathieuGuindon prolly but they might be tracking who is on the meeting or remote control, IDK.

Duga

3:08 AM

[rubberduck-vba/Rubberduck] build for commit c4524c7e on unknown branch: AppVeyor build succeeded

Comintern

5:38 AM

Woah, this is cool AF. If you "peek definition" on something R# can decompile, it shows you the decompiled source.

// Decompiled with JetBrains decompiler
// Type: System.Windows.UIElement
// Assembly: PresentationCore, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
// MVID: 2C71DFD2-6DA6-4692-B62C-BFBBF566AF53
// Assembly location: C:\Windows\Microsoft.NET\assembly\GAC_32\PresentationCore\v4.0_4.0.0.0__31bf3856ad364e35\PresentationCore.dll

Peter M Taylor

@this I like your upper hand in handling of the green hat. :)

Duga

6:50 AM

[rubberduck-vba/Rubberduck] comintern synchronized pull request #4650: Locked references removal fix

Duga

7:12 AM

[rubberduck-vba/Rubberduck] build for commit 8d1cbada on unknown branch: AppVeyor build succeeded

Inarion

7:54 AM

@IvenBach Careful. It tends to eat your time. ;)

(Though I think it's one of the better things to do after having one's wisdom quartered.)

Duga

9:09 AM

[rubberduck-vba/Rubberduck] MDoerner synchronized pull request #4648: Better member annotation scoping

Duga

9:36 AM

[rubberduck-vba/Rubberduck] build for commit 53568951 on unknown branch: AppVeyor build succeeded

M.Doerner

9:47 AM

Is there a way to make VS use that actual case of the path when adding new icons to resources?

On another note, I just ran dotMemory on RD and we definitely have some common WPF memory leaks. However, I am not sure how much unmanaged memory is attached to them.

Still, we should probably fix them.

The most prominent one is that we bind to DeclarationInspectionResult.Inspection not in one time mode.

That property does not implement INotifyPropertyChanged.

So, we should either wrap it in a view model or bind in one time mode.

I cannot imagine the inspection on a result to ever change.

this

10:41 AM

@M.Doerner did it identify the two convertors leaking memory streams as candidates?

Duga

10:53 AM

[rubberduck-vba/Rubberduck] Inarion created comment on issue #4654: "Find all references" gives an error for References

> Just yesterday when I explored the new and shiny references dialog, I saw how many references I had set and thought: Would it be possible to detect if there are any early-bound members of that library? (The workaround is to remove the reference and see if the project still compiles...) :D

Awesome idea!

Duga

12:05 PM

[rubberduck-vba/Rubberduck] retailcoder closed issue #4649: "Add/Remove Reference" dialogue allows removal of locked references. Sorta...

[rubberduck-vba/Rubberduck] retailcoder merged pull request #4650: Locked references removal fix from comintern/Rubberduck/refs into rubberduck-vba/Rubberduck/next

[rubberduck-vba/Rubberduck] retailcoder closed issue #4334: RD startup error when multiple new Excel projects are open before launch

[rubberduck-vba/Rubberduck] retailcoder closed issue #4651: Add/Remove References delay

[rubberduck-vba/Rubberduck] retailcoder did something with some project card

[rubberduck-vba/Rubberduck] retailcoder closed issue #4647: Add/Remove References Dialog isn't wide enough. AKA "Werez mah buttunz!"

[rubberduck-vba/Rubberduck] mansellan created comment on issue #4477: Code Explorer - Option to have module show up in multiple places (Feature request)

> #4478 and #4506 cover the items discussed above - closing this.

[rubberduck-vba/Rubberduck] mansellan closed issue #4477: Code Explorer - Option to have module show up in multiple places (Feature request)

[rubberduck-vba/Rubberduck] mansellan added label status-declined to issue #4477: Code Explorer - Option to have module show up in multiple places (Feature request)

M.Doerner

12:25 PM

@this No, that is not what it was looking for.

We have a ton of bitmaps that do not get disposed, though. (dotMemory told me that their finalize ran.)

Duga

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot published prerelease Prerelease-v2.3.1.4340

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot created tag Prerelease-v2.3.1.4340

[rubberduck-vba/Rubberduck] build for commit 4213a8ae on next: AppVeyor build succeeded

Duga

12:47 PM

[rubberduck-vba/Rubberduck] retailcoder commented on Rubberduck.Parsing/Annotations/IdentifierAnnotationService.cs of pull request #4648: Better member annotation scoping

[rubberduck-vba/Rubberduck] retailcoder commented on Rubberduck.CodeAnalysis/Inspections/Abstract/InspectionBase.cs of pull request #4648: Better member annotation scoping

this

@M.Doerner Ok so the issue I opened may still be relevant, then.

Duga

[rubberduck-vba/Rubberduck] daFreeMan created comment on issue #4647: Add/Remove References Dialog isn't wide enough. AKA "Werez mah buttunz!"

> Late to the party, as usual...

I would have put the "Up/Down" buttons in the gutter between the two boxen, above or below the "Left/Right" arrows. Enable them only when a "Selected" library is selected and movable (not at the top/bottom and, I presume not a locked library).

While it's not likely, if I add a library to the end of a longish list, but need it to be a higher priority, I just <s>fully qualify all calls in code</s> would simply select it in the left box, add it to the right bo

this

1:03 PM

@Duga @FreeMan but think how much more calories you could burn with extra wrist exercises!

Duga

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.CodeAnalysis/Inspections/Abstract/InspectionBase.cs of pull request #4648: Better member annotation scoping

Comintern

@Duga @Duga @FreeMan Wouldn't you prefer to just be able to drag and drop it?

Duga

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Parsing/Annotations/IdentifierAnnotationService.cs of pull request #4648: Better member annotation scoping

FreeMan

1:26 PM

@this no comment

@Comintern That could work. Is that implemented but not obvious?

Duga

[rubberduck-vba/Rubberduck] retailcoder commented on Rubberduck.CodeAnalysis/Inspections/Abstract/InspectionBase.cs of pull request #4648: Better member annotation scoping

FreeMan

Comintern

@FreeMan Not implemented yet, but on the agenda.

FreeMan

Cool!! ^

@Comintern eeeexcellent...

Now, how many reporting OOM/memory usage issues will notice that?

Comintern

Hopefully all of them.

Mathieu Guindon

1:28 PM

All those including RAM or Batman in the title of their issue

no wait, similar issues is smarter than that, is it?

FreeMan

As a frequenter of the issues log, I went to my already open tab and clicked on the code tab to go DL the newest build. As the page was reloading, the brain said "Hey, something looked... different..." and I had to go back to see it.

this

@MathieuGuindon that's a different feature. The pinned issue is before you get to create an issue.

Mathieu Guindon

Yeah just saw that - awesome!

this

(not sure if you can get to create an issue without going via the issues page).

not sure who pinned it, though.

Mathieu Guindon

You can if you type the url or follow a link to /issues/new

FreeMan

1:32 PM

You can if you're looking at an existing issue and click the new issue page. You can get to an existing issue from any shared link.

Mathieu Guindon

Like, that big green 'report an issue' button in the about box, IIRC

this

yeah obviously for the type-in. Not sure if we have a link to /issues/new somewhere else, though.

Comintern

I just wish you could personally pin an issue without self assigning it. Seems to only be a global option.

this

@FreeMan Ah, yes, that would be a likely candidate.

FreeMan

@MathieuGuindon potential source...

this

1:33 PM

But hopefully the similar issue feature will help dissuade that.

Hmm. I wonder.

Tweeting Duck

Which of you did this

Tweeted by darksim905 on December 18, 2018 at 7:24 PM

this

I think this feature needs more work. Note that none of 3 variants lists any open issues.

Especially considering that the issue does have this in the OP:

> After observing random "System resources exceeded" or "Out of memory" with my usercode which didn't quite make sense, I later ran quick fixes. After applying changes, I went to start the application and immediately got the System resources exceeded *despite have NOT run any VBA code`.

Mathieu Guindon

Pretty sure "batman" finds it :-)

this

Yeah, it does. It looks like it's limited to the subject, not the contents.

which kind of hamper its usefulness; you can count on users to come up with a zillion synonyms for same thing. :\

2

Mathieu Guindon

@this it needs to sort by open/closed status I think. Not sure what the sort is, but open matches should show up before closed ones imo

Duga

1:41 PM

[rubberduck-vba/Rubberduck] bclothier edited issue #3347: Holy RAM, batman! (Out of memory errors and excessively high memory usage)

this

It does, when you search on the RAM

Mathieu Guindon

::+1:

this

derp

that's weird. I swear for a instance, the open issue was listed 2nd. but by then I took the screenshot, it's now on 1st.

Comintern

I wonder if it sorts pinned issues to the top if they match.

FreeMan

@TweetingDuck Never thought of that! :( At one point, I had 2 HUGE rack mount Cisco switches that a friend of mine's company was disposing. He couldn't technically give them to me, but he did tell me when they were carefully placed next to the dumpster and we conveniently had to meet at his office after hours. I was going to use them at home (because everyone needs about 150 ports of 10/100 at home), but they just sat outside & rusted for about 10 years until I finally tossed them.

Comintern

1:45 PM

Found my morning bug.

FreeMan

@Duga nice!

@this I'm pretty sure I've seen closed issues above open ones

this

@FreeMan if it doesn't re-sort, then yeah that'd definitely be something that GH should improve.

FreeMan

@this so, is GH hosted on GH? If so, you should go open an issue.

@Comintern a star for you!

Duga

[rubberduck-vba/Rubberduck] comintern created pull request #4661: Make Add/Remove References match target project by ID, not name. to merge comintern/Rubberduck/refs into rubberduck-vba/Rubberduck/next

> This was throwing the the DeclarationFinder if multiple projects with the same name were open, meaning the dialog wouldn't show. Didn't notice this before when it was tied to the CE declarations.

Comintern

...and fixed my morning bug.

this

1:51 PM

@FreeMan I submitted the feedback already

Comintern

@FreeMan Not entirely sure that's warranted in that it was literally my bug.

this

(and everyone else should, too)

Comintern

Is there a way to clear all bookmarks in all files except the active one in VS?

FreeMan

@Comintern and another star for you!!

Duga

[rubberduck-vba/Rubberduck] Vogel612 milestoned issue #4334: RD startup error when multiple new Excel projects are open before launch

FreeMan

1:54 PM

@Comintern for cleaning up after yourself

Comintern

LOL

Duga

[rubberduck-vba/Rubberduck] Vogel612 milestoned issue #4649: "Add/Remove Reference" dialogue allows removal of locked references. Sorta...

[rubberduck-vba/Rubberduck] Vogel612 is checking what fun stuff @Duga can say about project cards

[rubberduck-vba/Rubberduck] Vogel612 created project card

FreeMan

@Comintern doing better than my kids. >:(

Duga

[rubberduck-vba/Rubberduck] build for commit bae177d8 on unknown branch: AppVeyor build failed

BUILD FAILURE!

[rubberduck-vba/Rubberduck] Vogel612 project card. Enough said.

Comintern

Wut?

this

1:57 PM

@Duga are you going to ever to say anything more than some snide remarks about project cards?

Duga

[rubberduck-vba/Rubberduck] Vogel612 moved project card

FreeMan

@Comintern cleaning up after yourself.

Duga

[rubberduck-vba/Rubberduck] Vogel612 is bored so why not move a project card

Comintern

Oh damnit. That has to merge with the CE stuff.

Well OK, then.

FreeMan

"kid" (22 yo) dumped her coat on the floor then gave me lip about how hard it is to hang it in the coat closet. Didn't have much to say after pointing out that I put my coat in there every. single. day.

Duga

1:58 PM

[rubberduck-vba/Rubberduck] Vogel612 project card. Enough said.

[rubberduck-vba/Rubberduck] Vogel612 is playing around with a project card

FreeMan

better, but...

can it dynamically size itself up to some sort of maximum?

Duga

[rubberduck-vba/Rubberduck] comintern synchronized pull request #4661: Make Add/Remove References match target project by ID, not name.

[rubberduck-vba/Rubberduck] build for commit 5b624a44 on unknown branch: AppVeyor was unable to build non-mergeable pull request

FreeMan

I mean, I'm running 1900x1200, there's space for it to grow.

Duga

BUILD FAILURE!

FreeMan

but I realize that not everyone's monitor is that big.

Duga

2:00 PM

[rubberduck-vba/Rubberduck] comintern edited pull request #4661: Code Explorer Extreme Makeover (for some values of extreme)

FreeMan

@this thanks for asking. I was worried about offending her and making her go run off and hide...

What are "project cards" anyway?

this

it's all those cards in the Projects

I assume Vogel has been working mainly with 2 projects:

github.com/rubberduck-vba/Rubberduck/projects/19

and github.com/rubberduck-vba/Rubberduck/projects/13

note that whenever you add a issue to a project (or closed an issue that's already on a project), Duga gives you that "is bored so why not move a project card" remark.

Vogel612

it's a bit annoying that the automation doesn't seem to correctly handle adding already closed issues to the project...

FreeMan

@this ah!

Duga

[rubberduck-vba/Rubberduck] comintern added label PR-Status: WIP to pull request #4661: Code Explorer Extreme Makeover (for some values of extreme)

[rubberduck-vba/Rubberduck] comintern edited pull request #4661: Code Explorer Extreme Makeover (for some values of extreme)

Duga

2:24 PM

[rubberduck-vba/Rubberduck] daFreeMan opened issue #4662: Add/Remove references dialog box isn't wide enough

> As a follow on to #4647 (and after installing build .4340) the dialog box still isn't wide enough. The button visibility has been fixed, but that pushed other, arguably less important, information out of the box in its default size:
![2018-12-19 08_58_48-rubberduck - add_remove references](https://user-images.githubusercontent.com/11889733/50225738-55f6c680-036f-11e9-8347-b879f8a42815.png)

I'm running 1900x1200 resolution so there's _plenty_ of room to make that dialogue wider, though I re

[rubberduck-vba/Rubberduck] daFreeMan created comment on issue #4662: Add/Remove references dialog box isn't wide enough

> An alternative fix would be to have the box remember its size so each user could customize it as (s)he sees fit and we would honor that request.

Quack Exchange

0

Q: Retrieving data in multiple formats from Excel with Python

Scenario: I have an excel file that contains some data in the first sheet. That data can be simple strings on a cell or CheckBoxes (marked or not). Data example: +---------+-------+------------------+------+------------------+ | item1 | 2004 | | | | +--...

Duga

[rubberduck-vba/Rubberduck] Vogel612 added label enhancement to issue #4662: Add/Remove references dialog box isn't wide enough

[rubberduck-vba/Rubberduck] Vogel612 added label up-for-grabs to issue #4662: Add/Remove references dialog box isn't wide enough

[rubberduck-vba/Rubberduck] Vogel612 added label difficulty-01-duckling to issue #4662: Add/Remove references dialog box isn't wide enough

[rubberduck-vba/Rubberduck] Vogel612 added label user-interface to issue #4662: Add/Remove references dialog box isn't wide enough

[rubberduck-vba/Rubberduck] Vogel612 added label good first issue to issue #4662: Add/Remove references dialog box isn't wide enough

[rubberduck-vba/Rubberduck] Vogel612 added label wpf to issue #4662: Add/Remove references dialog box isn't wide enough

FreeMan

2:43 PM

yikes!

56

Q: Search for military installed backdoors on laptop

My laptop was confiscated by the military institute of my country and they made me to give them all my passwords (I cannot tell you the name of my country). They did not give it back to me for one week (yes, it was out of my sight for a while). I nuked it from orbit but I just realised that it wa...

malware windows privacy backdoor

What's the magic incantation to make this work?

I have "smart-concatenation" and "Concatenate 'vbNewLine'" enabled:

Mathieu Guindon

jack up max lines to, say, 20

FreeMan

But no key combination seems to get me a ` & _` at the end of my bar =... line:

Public Sub foo()
  Dim bar As String
  bar = "text "
End Sub

is that it? just that it defaults to 2?

I've set it to 20 and hit Ctrl-Enter and it just stares at me...

nothing obvious (to me) in the log (starting with closing the Settings dialogue):

2018-12-19 09:50:08.6282;DEBUG-2.3.1.4340;Rubberduck.UI.Command.MenuItems.ParentMenus.ParentMenuItemBase;(9528291) Executing click handler for menu item 'S&ettings', hash code 32969802;
2018-12-19 09:50:14.6772;TRACE-2.3.1.4340;Rubberduck.Common.Hotkeys.Hotkey;Hotkey for the associated command Rubberduck.UI.Command.Refactorings.CodePaneRefactorRenameCommand was registered with id 49345;
2018-12-19 09:50:14.6928;TRACE-2.3.1.4340;Rubberduck.Common.Hotkeys.Hotkey;Hotkey for the associated command Rubberduck.UI.Command.Refactorings.RefactorEncapsulateFieldCommand was registered with id 49374;

Mathieu Guindon

hm, works here

Version 2.3.1.4330
OS: Microsoft Windows NT 6.1.7601 Service Pack 1, x64
Host Product: Microsoft Office 2010 x86
Host Version: 14.0.7212.5000
Host Executable: EXCEL.EXE

FreeMan

Version 2.3.1.4340
OS: Microsoft Windows NT 10.0.15063.0, x64
Host Product: Microsoft Office 2016 x64
Host Version: 16.0.4711.1000
Host Executable: MSACCESS.EXE

that was the weirdest "I'll show you mine if you'll show me yours" evar!

Mathieu Guindon

lol

FreeMan

2:53 PM

I confirmed that it does seem to be responding to hot-keys, a Ctrl-backtick got me a parse. Sometimes the hot-keys don't work...

Comintern

@FreeMan I should put the horizontal scrollbar on that. I'm thinking that dynamically resizing the form itself would be a little weird (it would also kick the scrollbar out from under the mouse).

Mathieu Guindon

AC exceptions get logged... but AC handlers don't write trace entries when they do kick in.. should they?

FreeMan

@Comintern that's a valid 3rd option and helps discoverability

@MathieuGuindon Wouldn't hurt for finding these kind of issues. ..

it's not like the log doesn't get large anyway...

and disk space is cheap (especially when the boss is paying for it:)

Mathieu Guindon

assuming logging is asynchronous, shouldn't hurt anything

Comintern

Speaking of which, we should probably handle multi-duck logging at some point. IIR there was an issue for multiple instances contending for the log file.

Duga

3:00 PM

[rubberduck-vba/Rubberduck] comintern created comment on issue #4662: Add/Remove references dialog box isn't wide enough

> Agreed that information shouldn't be hidden on the right hand side. It needs its scrollbars back. Dynamically resizing the form itself would be a little weird (it would also kick the scrollbar out from under the mouse). I think I'd find that behavior surprising as hell.

Definitely needs to persist the window size though.

BigBen

3:11 PM

@MathieuGuindon typo in the 3rd paragraph - "cass"...

Mathieu Guindon

thanks, fixed!

Mathieu Guindon

3:27 PM

@BigBen you might want to post answers as answers, it gets you more rep than comments :)

BigBen

hahahaha, I'm bad about that.

FreeMan

3:38 PM

@MathieuGuindon should I open an issue on the AC? Anything else I should test out first?

this

opens VBE's reference dialog

sad ducky

closes VBE's reference dialog. Goes to CE

2

FreeMan

LOL

Mathieu Guindon

@FreeMan sure go ahead :)

FreeMan

opens VBE's <thing>

sad ducky

closes VBE's <thing>. Goes to the duck's version

OOOOOOOOhhhhhhh...... It only works when the cursor is inside the quotes!

^not obvious, or <-- not bright

@MathieuGuindon never mind, works just fine when done properly.

this

uh, would help to know what was the <thing>

waitaminute, that's not related to the lightbulb moment, was it?

Mathieu Guindon

3:45 PM

@FreeMan not doing that would be utterly annoying, wouldn't it?

FreeMan

When Ctrl-Enter at the end of a text string and just outside the close quote, Clipyduck needs to pop up: "I see you're trying to use smart concatenation. Would you like me to put the cursor back inside the quotes to make this work?"

@this any <thing> which the duck has replaced

@MathieuGuindon well, yeah, I guess so. I just haven't intentionally tried using it until now, and I hadn't really thought about how it would work, so...

the bulb was having a dim moment.

Mathieu Guindon

nah, Dim can't be Public ;-)

2

this

I wonder if it's worth it having a setting Override VBE's lame stuff with duck's übercool stuff...

FreeMan

a star for you for the dad quality

@this I thought there was... it's enabled by installing Rubberduck

Mathieu Guindon

[x] Hijack project references dialog

this

3:49 PM

No, I'm referring to overriding the default menus like Tools -> References

^^

Mathieu Guindon

[x] Hijack all the things

3

this

or better, [ ] I want to go back to lame old VBE!

Mathieu Guindon

@FreeMan thank you, thank you, I'm here all week

FreeMan

lol...

to both @this and @MathieuGuindon

IvenBach

@FreeMan I can’t say my country. Yet it’s listed on his profile...

Comintern

3:55 PM

Mute, perhaps?

FreeMan

@IvenBach Yeah, saw those comments.

more like "don't need to say my country"

makes me very happy my country hasn't reached that level (yet)

BTW @IvenBach

14 hours ago, by IvenBach

I'm still as ~~dead sexy~~ fugly as ever.

Don't sell yourself short, you're dead sexy enough to have won a wife!

and keep her

this

@FreeMan kind of an achievement considering the long line of moronic tyrants we've managed to elect in last few terms....

FreeMan

if winning a wife involved duck tape and running from the law, don't share that...

@this yeah, scary stuff from both sides of the aisle...

/politics before we get our hands slapped

IvenBach

4:38 PM

@FreeMan I periodically ask my wife why she married me.

Me: Why'd you marry me?
Wife: 'Cause you make me laugh ~giggles~
Me: Then you think I'm funny looking...
Wife: ~laughs~

2

Inarion

@IvenBach I can relate to this.

She'll also frequently tell me You're stoopid! (Kinda tonge-in-cheek) and that's meant as a compliment. :)

Mathieu Guindon

side note, it took 14 years, but I finally got a legit, not-overkill use case for using array formulas in Excel: getting the nth match with index+match

can't wait for dynamic arrays to change the paradigm and make that much easier to grok

Vogel612

4:57 PM

@MathieuGuindon why'd you need the nth match?

Mathieu Guindon

@Vogel612 I have one table with order details - so I know what fabrics I need, and how many units I need to cut for each, and when I need them.

then I have another table with fabric POs

that table has a row for each PO, so I know how much of each fabric is coming in and when

now I need to know if I have enough fabric to cut the orders, at any point in time

VLOOKUP will only give me the qty/ETA for whatever first PO is in the list for that fabric

Vogel612

oh gosh.

Mathieu Guindon

yeah

this

wait, is Mat using Excel as a database?

Vogel612

always :D

Mathieu Guindon

5:04 PM

lol no, the data is on SQL Server

but the timeline with the aggregated customer groups and order types is a worksheet

...and it needs to be an actual production planning software

array formulas don't solve the problem of "depleting" a fabric PO

Vogel612

cumsum over all fabric types seems like your best bet, actually

it's probably a bit of a mess, though...

Mathieu Guindon

tis

Vogel612

totally unrelated: I have 6.8GiB of 7.7GiB of RAM used, kernel swappiness is set to 60, but the swap partition is only used to 0.45GiB of 3.7GiB ...

Mathieu Guindon

does kernel swappiness make a happy kernel?

Vogel612

depends on whether there's enough swap space and it's used irregularly enough

the closer to 100 the swappiness is, the more likely the kernel is to actually swap some stuff

this

5:09 PM

it might be that the used memory isn't moving that much

It really gets annoying to get an email notification about the 443rd comment repeating same old chestnut from Excel UV...

Vogel612

it's a bit better now after it almost choked to death ...

that kinda seems to get it to work on doing some swapping

Mathieu Guindon

hi @Magisch!

Magisch

Hello Mat

Didnt you use to be a mug?

Mathieu Guindon

yes!

this

@Magisch don't be silly. Mugs don't turn into humans....

Magisch

5:23 PM

I moved away from mostly vba lately

Mathieu Guindon

into C#?

and now you're looking for an awesome OSS project to contribute to? :D

Magisch

no

javascript and tsql

^^

Mathieu Guindon

yay for T-SQL :)

Magisch

And LaTeX templating

Tweeting Duck

There is no perfect app. There is no perfect architecture. There is no perfect code. You can kill yourself chasing any of the above. Never aim for perfect. Perfect is a never ending long tail of time and effort far better spent on improving other things. Aim for great.

Tweeted by Nick_Craver on December 19, 2018 at 11:59 AM

this

5:28 PM

@TweetingDuck hmm didn't he say that already before?

Magisch

@MathieuGuindon It's quite horrifying to look back at my earlier posts and realize that this is all code that is in production right now

Mathieu Guindon

@this I could have sworn I had liked & RTd it, but it wasn't showing as liked or RTd, ...so I re-liked and re-RTd

M.Doerner

@MathieuGuindon Do you really absolutely need an array formula for that?

Mathieu Guindon

@M.Doerner some custom VBA function could do it... pretty sure without VBA or the dynamic arrays feature array formulas are the only hope for that

Magisch

ive been spoiled by weak typing in javascript

Mathieu Guindon

5:36 PM

just like you were spoiled with Variant in VBA :)

M.Doerner

What does the array formula look like for this?

Magisch

but for vba I really only learned with option explicit on all the time so I have no idea how type fuzziness can be used

I almost never used variant tbh

employer really didn't like using variants.

Mathieu Guindon

best not, yeah

FreeMan

@IvenBach I get the same answer

Mathieu Guindon

@M.Doerner {=INDEX(Values,SMALL(IF(Things="ABC",ROW(Things)-ROW(INDEX(Things,1,1))+1),Look‌upValue))}

Magisch

5:38 PM

just like my current employer has a hard ban on using eval

unless manager override is obtained, the version control & ci will not let code with eval in it past

Mathieu Guindon

@Magisch the funny thing is that every time you typed a dot and no intellisense came up, you were probably using a Variant :)

many things return variants in various object models, esp. Excel

Magisch

pretty sure that rarely happened

my vba experience was limited mostly to ms access

Mathieu Guindon

e.g. wb.Worksheets("name").something << late-bound

M.Doerner

Hm, I think I'll try to turn that into an ordinary function later.

Magisch

I recently returned to vba with some excel to write a program for the son of a coworker

IvenBach

5:41 PM

#TIL I toggled the building door to be permanently open since Monday. Whoopsie...

Good thing I was out yesterday when they discovered that.

Magisch

coworker wants to teach his 5 year old to start coding because the kid is interested

IvenBach

@Magisch great time to start.

Mathieu Guindon

gotta train the ducklings early!

Magisch

I'm not convinced 5 years is the best time to start but the kid can write pseudocode that actually leads to implementable simple tasks

IvenBach

Just don’t expect him to understand + - / % or heck any operators....

Mathieu Guindon

5:43 PM

ideally learn to read/write first, yeah

Magisch

made a loop that iterates across a worksheet and checks each populated cell against a list of cell:image pairs in another sheet and copies the images if the texts match

Mathieu Guindon

also, if they grasp variables and operators and functions at that age, ...prepare to sign them up to private school!

Magisch

well the kid can already do some 4th-5th grade math

no clue how but he seems to grasp the concept of a loop and incrementing a counter

Mathieu Guindon

wow

this

^

IvenBach

5:45 PM

He’ll be in school ‘That’s a poor implementation of that formula. You can improve it by...’

Magisch

kid is obsessed with soccer teams

so much so he calculates league scores and stuff

he has that in common with his dad

IvenBach

Use that passion to teach him math and science.

Magisch

the coworker is a sysadmin, but seems to be interested in furthering his son's interests

FreeMan

I was always amazed how kids could calculate a pitcher's ERA (I'm told it's fairly complex), but couldn't solve 2x+6=27 for x...

this

IDK if that is still true but I seem to recall being told that psychologists thinks that kids can't do abstract until later age generally.

Transcript for