VBA Rubberducking

12:01 AM

RELOAD!

[rubberduck-vba/Rubberduck] 2 issue comments.

[Zomis/AdventOfCode2017] 2 commits. 130 additions. 4 deletions.

[Zomis/factorio-downloads] 2 commits. 35 additions.

[Zomis/factorio-posts] 13 commits. 140 additions. 24 deletions.

[Zomis/FactorioMods] 1 commit. 117 additions.

[Zomis/SweepLearn] 1 commit. 165 additions. 21 deletions.

2 hours later…

Mat's Mug

1:47 AM

Status: wood chopped for the winter, toilet repaired, mug exhausted

Peter M Taylor

Take it easy mate especially when your recovering from a cold.

2:12 AM

[rubberduck-vba/Rubberduck] bclothier synchronized pull request #3588: Feature extract method Update 2

[rubberduck-vba/Rubberduck] bclothier commented on Rubberduck.VBEEditor/Extensions/CodeModuleExtensions.cs of pull request #3588: Feature extract method Update 2

3 hours later…

ThunderFrame

5:36 AM

@Mat'sMug When Winter is Coming in Canada, seems more serious than around these parts...

1 hour later…

QHarr

6:50 AM

Just to feedback that RubberDuck is back up and running in my Excel installation after the problems i was experiencing earlier this week. Nothing special done, guess it was a random thing, but i am so happy!!!!

5 hours later…

11:52 AM

[rubberduck-vba/Rubberduck] bclothier opened issue #3589: Inspection for (mis)usage of module fields backed by property

> Given this code:

```
Private BackingField As String

Public Property Get Field() As String
Field = BackingField
End Property

Public Property Let(NewValue As String)
'Some complicated logic goes here...
BackingField = NewValue
End Property

Public Sub Doh()
BackingField = "Bypassing the logic!"
End Sub
```
It's too easy to wrongly reference the backing field within the module; there are instances where bypassing the logic embedded in the setter is fine, but I think i

2 hours later…

1:33 PM

[rubberduck-vba/Rubberduck] Vogel612 added label feature-inspections to issue #3589: Inspection for (mis)usage of module fields backed by property

[rubberduck-vba/Rubberduck] Vogel612 added label enhancement to issue #3589: Inspection for (mis)usage of module fields backed by property

FreeMan

1:55 PM

@Hosch250 Yoda talks he does

@FreeMan s/did/in

@Mat'sMug Wood fireplace?

Mostly for show, I take it? You guys seriously can't be using wood as your main heat source still :P

[rubberduck-vba/Rubberduck] Hosch250 commented on issue #3589: Inspection for (mis)usage of module fields backed by property

> Brilliant idea. The IgnoreOnce attribute should automatically work, but it would be something we need to test.

2:20 PM

@Mat'sMug I hope that the toilet repair wasn't precipitated by the wood chopping. It makes for a poor chopping block.

FreeMan

@this Leads to splinters in uncomfortable places

@this Did you get a chance to copy that commit data to your repo?

@Hosch250 yeah it's in the current PR

Cool.

Just need to make the combobox always show. That's going to be a little harder.

yeah, don't know why they thought it was a great idea to not show it.

2:23 PM

I'll take a look soon as I can; probably on the weekend.

if nothing else, we'll just add neon colors flashing on it to indicate it's editable. Should be OK.

Mat's Mug

@Hosch250 yeah.. and yeah, just because it's nice. We have this thing called electricity up here too lol

Yeah, I love fire too.

Fire and ice are two of the most beautiful things :)

5 hours later…

7:15 PM

I needed to query some computers to get the specs (Ram, HD, VideoCard, etc...) and used powershell to do that. I used Win32_ComputerSystem class. Does anyone know if the scripts are in C or C++?

7:26 PM

Does it really matter?

ThunderFrame

8:04 PM

@IvenBach darkoperator.com/blog/2013/1/31/…

> when Microsoft developed the first versions of WMI they use DCOM (Distributed Component Object Model) wish if a proprietary Microsoft Technology, so the standards and cross compatibility just took a back seat at the time, on more recent versions of the operating system with Windows Management Framework 2.0 and above MS started to include more and more of the standards and shifter to using WS-Management SOAP-based protocol thru their WinRM (Windows Remote Management) protocol.

QHarr

8:42 PM

So i know i am being dumb but i inserted a TestMethod1 for TDD. All i have inserted is 'Arrange: Dim myTest As String 'Act: myTest = "Me" 'Assert: Assert.AreEqual "Me2" , myTest

It fails as expected but i am getting an object variable or With block variable not set Run-time error 91

In my tired madness what obvious thing am i missing? Such that TestFail produces this?

8:57 PM

@Hosch250 makes for a significantly smaller heating oil bill

Yep. We have a neighbor who does it.

He uses it on really cold days because it gets really, really hot.

He just goes around the neighborhood and collects logs from fallen trees and stuff.

also makes for great exercise

Talking about that, do you live near the Black Forest (or what remains of it)?

I don't understand that last part.

also "near"... well for you americans, probably.

I'm not that strong in my geography.

9:03 PM

@Hosch250 I don't think it does. I just needed to use [string]::Format("Foo {0}", $Bar) and wasn't sure if it was C, C++, etc...

it's a bit less than an hour's drive on the Autobahn to get to Pforzheim, which is the "north end" of the Black Forest

I wasn't sure if it was still around, or if it had died out or been cut down or been destroyed in the wars.

Lacking any experience it's hard to ask the correct question.

@IvenBach Looks like C++.

C doesn't have classes, and that would be C++ notation for a static member of a class, IIRC.

Thanks.

9:05 PM

@Hosch250 thank you very much for two very hearty laughs

I try and ask Google before coming to the ducks.

@Vogel612 NP.

The Black Forest is alive and kicking.

Out here, we've lost a lot of forests to industrialization and many of the remaining protected ones are threatened by various beetles and fungi, so...

Climate change slowly changes it's composition from dark needlewoods to more leafy trees like birch, oak and possibly hazel

the forest just isn't quite accessible enough to be viable for industrial purposes and even before that people seem to have been more future-oriented than they get credit for

IIUC parts of it were "Bannwald" since quite some time

and you forget that Germany went from a feudal system, where only nobility was allowed to fell trees to industrialization pretty quickly

9:10 PM

It's been a big tourist spot forever.

Did you ever read Three Men on the Bummel?

It's about the English author and his friends who went on a touring trip through it back somewhere in the late 1800's/early 1900's.

no, I did not. Is it good?

There's also Three Men in a Boat, which is about the same characters touring the Thames before they were married.

I thought so.

It's not always the most complimentary, but it's funny.

If you like Twain, you'd probably like those two.

1 hour later…

ThunderFrame

10:43 PM

I ate a lot of sausage in Freiberg, didn't see a lot of trees.

11:00 PM

Duck check: TestExplorer shows 0ms for the duration if run via Rubberduck>UnitTests>Run All Tests for me. If I run it through the TextExplorer window a duration does come up. Can anyone else confirm this?

[rubberduck-vba/Rubberduck] IvenBach opened issue #3590: Test Explorer shows duration of 0ms for all tests if run by Rubberduck>UnitTests>Run All Tests

> Going through `Rubberduck>UnitTests>Run All Tests` produces the image below. Note the 0ms timer for each test.
![untitled](https://user-images.githubusercontent.com/26076874/33581169-a732bc02-d904-11e7-8942-743c25940eb4.png)

Using `TestExplorer>Run>All Tests` produces the times show below.
![untitled2](https://user-images.githubusercontent.com/26076874/33581197-c432f66e-d904-11e7-8f2e-e2fd34a0a9eb.png)

<misguidedEnthusiasm>Let's see if we can break the 600 mark for open issues!</misguidedEnthusiasm>