VBA Rubberducking

« first day (2805 days earlier) ← previous day next day → last day (375 days later) »

Duga

00:00

REFRESH!

[Minesweeper] 117 Games Played. 70 Bombs Used. 16869 Moves Performed. 20 New Users

[rubberduck-vba/Rubberduck] 1 issues opened. 1 issue comments

2 hours later…

mansellan

01:45

MS really want to kill VBA. I can see the plan. Start with MOTW, then strip consumer editions of Office from running VBA at all, then default corporate editions of Office to "disallow" (GPO override available), then remove entirely.

If twinBAASIC blows up, they might just reconsider.

4 hours later…

Mathieu Guindon

06:16

Website update status: implemented search, finished indenter page, and adding sub-features works nicely now. Todo: oauth2 to GitHub for admin page and authenticated endpoints, some front-end work, a couple UX enhancements to the admin page, actual content editing, error pages ... basically almost everything important works, getting to the final touches =)

6 hours later…

FreeMan

12:21

waves @Hosch250, but #LateToTheParty as usual...

2 hours later…

this

13:53

@mansellan what is a twinBAASIC?

That said, I wouldn't be surprised that if twinBASIC did become a thing, MSFT would be happy to wash its hands of VBA and tell "use twinBASIC!"

FreeMan

14:07

But then there wouldn't be a quick, simple, easy to get to, built right in tool for Bob in Accounting to be able to automate his lookups in his Excel-as-a-database workbook.

BigBen

@FreeMan this rings true on so many levels

(speaking as someone who deals with several Bobs In Accounting)

(also, Finance is no better, and finance people can't code)

FreeMan

"Accounting" is just as generic a name for non-programmers as "Bob" is for accountants, so just go with it. Sheesh!

FreeMan

14:21

Heck, "Bob in Accounting" could actually be "Dinish in IT" who is a genius at setting up networking and routers, but wouldn't know a function if it jumped up and bit him in the butt.

BigBen

I don't know many Dinish's in IT, but I suspect you are 100% correct.

Why would one use Not Win64? What's wrong with using #If Win32? — BigBen 2 mins ago

Attempting to use #If Not Win64 is just weird, right? I'm not crazy?

this

14:36

It's not safe.

Better: #If Win64 = False Then

Mathieu Guindon

This needs an inspection

this

Compare: ?Not True, Not 1, Not True = Not 1

BigBen

Agreed, it's not safe.

this

aren't you glad you live in world where my truth doesn't have to be your truth or Bob's truth, but Bob, you and I all agree on what's false?

BigBen

rofl

Duga

14:55

[rubberduck-vba/Rubberduck] retailcoder added label enhancement to issue #5945: #IfNot Inspection

[rubberduck-vba/Rubberduck] retailcoder added label up-for-grabs to issue #5945: #IfNot Inspection

[rubberduck-vba/Rubberduck] retailcoder opened issue #5945: #IfNot Inspection

> **What**
Flag precompiler directives involving a `Not` operator flipping a precompiler constant.

**Why**
Truthy value is 1, which yields unexpected results when a `Not` operator gets involved.

**Example**
This code should trigger the inspection:

```vb
#If Not Win64 Then ' expression is always true
#EndIf
```

---

**QuickFixes**

1. **Use Explicit Equality Check**

Example code, after quickfix is applied:

```vb
#If Win64 = 0 Then
#EndIf
```

-

FreeMan

@this No, not really. :/

this

@FreeMan My truth says that you're happy, so be happy!

FreeMan

Yeah, so long as nobody's truth decides that I feel like FreeWoman today.

this

15:12

It's hilarious. If they can insist that you call a him a her because it's how THEY feel, they completely disregard YOUR feeling that a him is a him.

and that's playing by their rules, even. Doesn't even address the fact that truth isn't subjective at all (so "my truth" and "your truth" are patently nonsense to begin with but that doesn't stop them so...)

FreeMan

I will agree with you 100%, but not continue any further in the conversation because the logical holes in their arguments are large enough to safely fly an A380 through, but they refuse to see them. Plus, it tends to get my blood pressure up and I don't need that right now.

BZngr

15:28

Sooo - my system keeps coercing me to upgrade to Windows 11...anybody here know of reasons to resist?

FreeMan

Alternatively, any good reasons to accept?

I mean, does the "wait until SP1" advice of yore still apply?

this

I don't upgrade until SP1 precisely for that reason.

but will Windows 11 even have SP?

FreeMan

Yeah, they release an SP every 6 months or so. They just don't call it that anymore. Much like they fixed the BSOD by not making it blue and giving it a different name. ;)

this

I think it's now SFSOD now.

BZngr

SFSOD? Save for some other day?

this

15:53

Sad Face Screen Of Death

BZngr

Vogel612

@this at the danger of getting into a long discussion: How is your "feeling" about their pronoun relevant?

it's not like you were asked to kick a puppy

don't get me wrong, you are still perfectly allowed to use any pronoun that you want, but xkcd 1357 applies

this

@Vogel612 That's precisely my point. They want to use a different pronoun. Fine by me. Can they force me to use it their way? Nope.

Vogel612

@this sure, technically they can't force you. But if you don't want to use their pronoun, you're being a jerk about it....

it's a bit like deciding that "I don't like your name, so I'll use a different name than your name for you, expecting you to behave as if I used your name."

like ... defining a shell alias on their machine

sounds like a good way to make enemies, huh?

this

So if Bob asks me to call him Napoleon, the great French emperor, I should just go along?

Vogel612

16:05

that's ... a weird example, but why wouldn't you?

What's it to you what Napoleon, the great French emperor wants to be called? (except maybe that you'd want to be allowed to shorten it to Napoleon, but eh)

this

There's a difference between an alias and an identity. This is not same thing as Robert asking to be called "Bob" and being rude and instead on calling him "Rob" or "Robert". Should I call a fish a turtle? If I insisted on it, I would be clinically insane.

Vogel612

how is a name not an alias?

this

Ok, I do have to admit there is some identity tied up in a name. A man named Robert insisting on being called Roberta is denying the biological fact that he's a man and thus should have a masculine name and be referred with male pronouns.

A Leslie might not have that problem because it's not as clearly masculine/feminine but we still understand the difference between "This is Leslie and he's our best worker." vs. "This is Leslie and she's our best worker."

Vogel612

@this "biological fact" is making some interesting assumptions that just don't apply

this

The point being, the identity is very much innate thing, a biological fact and we do reflect that in our names even if we have our nicknames which up to now has usually followed the same identity (Robert called "Bob" or "Robby" but not "Roberta").

Vogel612

16:14

note that "man" is also just an alias for a categorization

that's what is meant when people say "gender is a social construct"

gender is a label for a box that includes people based on a set of shared characteristics

this

Nope. A male is one with XX; A femlae is one with XY. This is embedded in DNA throughout the body.

Vogel612

right. except you probably meant the other way round, ... and again ignoring multiple, well-documented phenomena where there's more than two (or less than two) chromosomes as well as various genetic mutations that result in different sensitivity to testosterone or estrogen

which is like ... whoops

biological sex is a bimodal spectrum

this

Yes, aware of those. But I'm not going to point to degeneracy as a proof that it's a spectrum.

Vogel612

"degeneracy" is a ... loaded word

this

Our genome has been steadily getting more and more degenerate. Because most mutations are harmless, they don't get selected out and as a consequence we as whole are getting more sicker than previous generations. If left unchecked, the species will hit a critical mass and collapse entirely.

Mathieu Guindon

16:27

c.f. Targaryens

(jk)

Vogel612

@this that's some eugenicist nonsense

the logical consequence of that school of thought is mercy-killing people that lose a limb in an accident

this

uh, no. Eugenicists would have accelerated this.

There is a reason why a mutt on average is more healthy than a thoroughbred dog.

Doesn't change the fact that mutations are steadily accumulating in the genome, however. It's called "genetic entropy", IIRC.

2 hours later…