VBA Rubberducking - 2021-06-21

« first day (2572 days earlier) ← previous day next day → last day (608 days later) »

Duga

00:02

REFRESH!

[rubberduck-vba/Rubberduck] {issues=3, commits=5, issue_comments=3}

[rubberduck-vba/Rubberduck] build #5949 for commit 8fb976f3bf @ 2.5.2.5949 build success

[rubberduck-vba/Rubberduck] build for commit 8fb976f3 on inspectiondocs-patch-1: AppVeyor build succeeded

Duga

00:33

[rubberduck-vba/Rubberduck] build #5950 for commit b37e207f5f @ 2.5.2.5950 build success

[rubberduck-vba/Rubberduck] build for commit 8fb976f3 on inspectiondocs-patch-1: AppVeyor build succeeded

Duga

01:16

[rubberduck-vba/Rubberduck] retailcoder pushed 1 commit to next

[rubberduck-vba/Rubberduck] web-flow pushed commit 949d8afc to next

Merge pull request #5816 from rubberduck-vba/inspectiondocs-patch-1

xmldoc patch

Duga

01:41

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot created draft prerelease Prerelease-v2.5.2.5951

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot prereleased draft prerelease Prerelease-v2.5.2.5951

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

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

[rubberduck-vba/Rubberduck] build #5951 for commit 949d8afc3a @ 2.5.2.5951 build success

[rubberduck-vba/Rubberduck] build for commit 949d8afc on next: AppVeyor build succeeded

2 hours later…

Duga

03:14

[rubberduck-vba/Rubberduck] srutzky starred us

4

Duga

04:05

[rubberduck-vba/Rubberduck] Jimmy-Hu starred us

4

4 hours later…

Simon Forsberg

07:41

@Duga @MathieuGuindon You're falling behind :/

3 hours later…

Vogel612

10:27

@SimonForsberg it doesn't help that the development on the duck has been somewhat slow recently.

FreeMan

10:50

Nice little star shower yesterday.

well, this weekend...

Wait, what??? I didn't hear what you said!!!

;)

Kaz

@FreeMan Thought you were talking about chat stars, not RD stars ^^

FreeMan

Ah... :)

Quack Exchange

11:10

0

Q: VBA - Excel add in Convert number to Text currency

No problem yet with the code. Here is a function that can be saved as add in and used as UDF in Microsoft excel to convert a number to text. For example, 4556.45 to RUPEES Four Thousand Five Hundred Fifty Six & PAISE Forty Five (Defaults being set to Indian Rupee). But the function can be adopted...

2 hours later…

Mathieu Guindon

12:46

Day 1 update: commute test successful, heading back home. ...missed the memo about day 1 being all about waiting for the remote equipment at home. Receiving more equipment tomorrow as well, apparently it's a fully-remote gig, which is a nice surprise (was expecting some remote)!

@Duga that didn't work, apparently content updater isn't doing anything with <remarks> tags in inspections' xmldocs

FreeMan

@MathieuGuindon If full-time remote is what you want/like, that's awesome! Some prefer some time in the office. OTOH, at least you know how much time it takes to get there during commute hours! :D

Mathieu Guindon

Yeah, was hoping for remote but was mentally prepared to burn 2 hours/day commuting. Keeping 100% remote is amazing, that alone is pretty much worth $10K or so

So I bought new shoes, dress shirts, and ties, ...all for nothing haha

On the bright side I learned to make a somewhat-decent tie knot

BigBen

lol.

Vogel612

God I still need to retie four or five times every time I am attending a wedding.

Not wearing ties in other cases :D

Mathieu Guindon

@Vogel612 I didn't say I got a decent knot on the first try... must have been around that, 4 or 5 times =)

FreeMan

13:07

@MathieuGuindon You got them with the company discount at the last place you worked, at least, right? Can we get a pic of you in the purple leisure suit? :D:D:D

@Duga Been watching too many Marvel movies/shows with my youngest... I read that as "Jimmy-Woo"...

Kaz

13:44

My next job is going to have to be Work From Anywhere (In The World). I'm moving somewhere hot, sunny, where money goes three times as far, and I'm not coming back.

And if that causes too many issues, I'll set up a UK-based consulting company so other people can pay me, and I can can deal with the hassle of paying myself an income in a foreign country.

Duga

[rubberduck-vba/Rubberduck] daFreeMan created comment on issue #5710: File Permission issue causing Unexpected Error when parsing

> The original issue noted that it was happening only in an Excel host, not Access. That has now changed - I'm having it happen _very_ consistently in Access now, too.

I'm working on my laptop connected via VPN to the corporate network. That should _not_ however, have any impact on the situation, since the file is being written to/read from a _local_ directory on my physically present C: drive (i.e., there is no magic mapping that I'm aware of going on in the background). For example:

```

FreeMan

@Kaz Yeah, a lot of that! The only other flaw I see in your plan is that beach sand can play havock with keyboards & mice.

Kaz

@FreeMan Maybe I'll just get a Villa with a Pool instead :)

Duga

[rubberduck-vba/Rubberduck] SmileyFtW opened issue #5817: Procedure Not Used Inspection - False Positive

[rubberduck-vba/Rubberduck] SmileyFtW added label bug to issue #5817: Procedure Not Used Inspection - False Positive

FreeMan

14:01

@Kaz there you go!

Just to be sure I'm not going to create more problems than I already have...

My laptop is presently non-functional for programming because of the parse error noted above (what? Work without the Duck? getouttahere!!!) Therefore, I did a git push origin <branch> to push my current state from the laptop to my remote origin.

I now need to pull that from the origin (a location on our network) to my desktop machine. To do so, do I git pull branch on the other machine, or do I git fetch, then checkout the appropriate branch?

I mean, I suppose I could just copy the one module from one machine to the other, but then I don't learn anything...

hey, here's my newly minted git expert! ;)

IvenBach

got fetch followed by git merge.

FreeMan

14:20

Isn't git pull equivalent to that^?

either case, that's what I want to do on the other machine, right?

IvenBach

Yes. But performing each step individually helped me learn what is occurring.

FreeMan

gotcha.

FreeMan

14:47

ah, I don't seem to have the branch on origin, despite having done a git push origin <branch>. Seems I have to do git push -u origin <branch> to have it create the branch on origin

FreeMan

15:00

Interesting that TG doesn't do @this for me automatically...

Hosch250

15:13

@Vogel612 That's one of the reasons I'm not attending weddings anymore.

Duga

15:51

[rubberduck-vba/Rubberduck] terryhatch starred us

4

IvenBach

¿Any new articles recently? We nearly got full star power on recently starred chat messages.

BigBen

I'm guessing it's the Community Ad

FreeMan

could be that. ^

Are the ads up already?

BigBen

I think just on meta

18

Q: Community Ads for 2021

We're almost halfway through 2021, and in case you missed it, Open Source Advertising is gonna be a bit different this time! TL;DR: submit and vote for ad proposals before August 2nd! What are Community Ads? Community Ads are community-vetted advertisements that will show up on the main site, or ...

discussion community-ads featured open-source-advertising

FreeMan

16:32

Interesting that the voting is +22/-1. I wonder who doesn't like a rubber duck?

BigBen

Ducks do tend to grow over time, like most animals. And code. — Cody Gray ♦ 2 days ago

hahaha

FreeMan

I do notice that uBlock Origin blocks all of SO/SE's ads. Unless they're not serving any ads at all right now...

2 hours later…

Duga

18:15

[rubberduck-vba/Rubberduck] daFreeMan created comment on issue #5710: File Permission issue causing Unexpected Error when parsing

> Noting that earlier, I'd been able to edit the randomly named file in NPP, then save it & get it to compile cleanly, I've attempted to do that again, but it _didn't_ work on my Access-hosted project.

Three errors from three successive parses:

```
2021-06-21 14:10:55.1146;ERROR-2.5.2.5951;Rubberduck.Parsing.VBA.Parsing.ModuleParser; Unexpected exception thrown in thread 30 while parsing module Tools, ParseTaskID 3c7b85cd-89c0-404f-a5ae-b1c465aecadf.;System.UnauthorizedAccessException: Ac

Duga

18:50

[rubberduck-vba/Rubberduck] Vogel612 added label code-path-analysis to issue #5817: Procedure Not Used Inspection - False Positive

Duga

19:43

[rubberduck-vba/Rubberduck] retailcoder created comment on issue #5817: Procedure Not Used Inspection - False Positive

> Could it be just the With block throwing a wrench here?

Mathieu Guindon

@FreeMan a small number of (annoying) users seems to consistently just downvote every single ad, every year - not a big deal usually, assuming a decent-looking ad that adheres to the posting rules. Low-effort ads, and/or ads that don't comply with the rules, tend to get hit hard (and rarely recover)

The meta post itself is currently +34/-16

Most of it being downvotes from the disgruntled user base backing SO surrogates

(from what it looks like anyway, reading the comments)

Mathieu Guindon

20:23

fml I need a new UPS... power just went out multiple times for like half a second - not even enough for fans to stop spinning... enough to initiate a reboot twice in 5 seconds though.

HackSlash

A good UPS is expensive. I've had a couple of cheap ones that can't support my PC. Always overprovision. I need to get a Kil-a-watt to measure the actual usage of my powerstrip and go from there.

Mathieu Guindon

21:06

mine has been a glorified power bar with a flat battery for like 2 years now.... I deserve all the power failures I get lol

this

if it's still capable of supporting your setup, it'd be cheaper to get a battery replacement.

Vogel612

How the heck is y'all's electrical grid so prone to short-term power failures?

this

FWIW, I have an upright UPS that has served me for 4 years, just replaced the battery few months ago.

@Vogel612 it's always dirty?

Vogel612

Even if I wanted to run a small server, I would probably not need a UPS

@this I didn't understand that particular joke...

Mathieu Guindon

@Vogel612 lack of German Engineering!

this

21:09

The point is that brownout is the greater danger than blackout. The power you get from your grid is rarely clean.

Vogel612

@this yea, but that's what the power unit is for, is it not?

@MathieuGuindon The German power grid is ... very old and not as cost-effective as it could (or maybe should) be.

this

But if you have a laptop or all-in-one, then it's actually cheaper to put a UPS in between than to let it directly at the power unit.

Otherwise, it can really sap your power unit's life and even cause problems due to the dirty power.

Vogel612

I have never needed to replace a power unit due to dirty power...

this

I lived in 1920's house where they still have tubs'n'knobs wiring (yikes!) and it killed 3 power units on the same laptop before I realized what was going on.

Vogel612

And I also have never heard of any of my friends needing to.

@this ohhh yea, that'd do it

this

21:13

shrugs I can only tell you that it's a danger, even if you do have a new constructed home that's wired according to current code.

the thing about brownouts is that you won't even know it

Vogel612

Maybe in the US :D

this

but it is silently killing your power units.

Vogel612

I think the 230V grid helps with avoiding such issues

this

for that reason, all my major electrical appliances has to be hooked via UPS. TVs and like get the cheap-o UPS brand I don't need power in blackout. I only want clean power.

Vogel612

again: I've never had to replace a power unit, and I've had the same PC for almost a decade at this point.

this

21:15

for my work computer, I get the bigger UPS, and I don't have to worry about replacing power units.

then you're a fortunate fellow.

I deal with what I must deal with.

one more consideration - I'd wage many people don't even know that when their favorite phone or laptop dies, they don't blame the dirty power. They just say "piece of junk" and then buy another phone/laptop.

Vogel612

hmm ... that might be true.

Another issue is malware infections and poor "digital hygiene" (for lack of a better term) making lots of end user devices slower than they need to be...

this

yes, it's not very easy to measure.

I only became aware of that issue only because of that stupid 1920's house

so... dons the tinfoil hat, I must put UPS in front of my electrical appliances.

Vogel612

~shrugs

another possibly weird question: How many keyboards over on your side of the pond have a dedicated AltGr key?

this

oh yeah, I did not even know that was a thing until recently.

Vogel612

I've gotten myself a new keyboard and didn't pay enough attention and now I have one with a us layout.

this

21:22

you can configure it, though, no?

Vogel612

It's taking a bit of getting used to, but the mechanical keys are great, so I don't think I will return it..

it has too few keys...

There's literally not enough keys for the default layout I am used to.

and the affected key is the <>| key, so it's not like I can just not have it ...

this

wait, is this a laptop?

Vogel612

wireless mechanical keyboard.

this

those keys are on a standard US layout keyboard but laptops sometime omits them

Peilonrayz

@Vogel612 QWERTZ going from a short to a long left shift?

Vogel612

21:27

@Peilonrayz except the keycaps are labelled QWERTY, ya...

this

If it's a small keyboard, that would be why, I guess. I honestly don't like keyboards without keypads & arrowkeys. There's much less consistency for those keyboard layouts even though they are all technically "US".

Vogel612

Though my laptop keyboard has a long left shift as well and instead moves that key to the right side of the space bar.

@this I needed it to be shorter, so I elected to forego the numpad (but kept the arrow keys)

For a more 'fixed' setup I'd have gotten a numpad

Peilonrayz

@Vogel612 I'm lucky QWERTY was \| because otherwise the transition would have been very painful. Do you have a split enter? I found getting used to both super annoying.

Vogel612

@Peilonrayz there is a split enter, but I am used to that from my laptop keyboard.

So I "just" need to get used to the yz switch and all the special chars being somewhere else.

(it makes so much more sense to have + and * on the same key, for example, but that's just not a thing...)

Peilonrayz

@Vogel612 I don't think I've ever seen a split enter with a short shift. You 'should' have an extra key. Unless the laptop gobbled up the space for a more compact layout... Maybe I've just not seen enough laptops

Vogel612

21:36

user image

Peilonrayz

Nice :D

Vogel612

Yea, it's really compact and nice to type on. And it doesn't try to escape when typing :D

Peilonrayz

Doesn't escape when typing?! I'm guessing your talking about rubber on the bottom?

Vogel612

yup

this

Out of curiosity, does it come with some kind of protector? Otherwise how do you make sure it's not being squashed when stored?

Peilonrayz

21:42

Oh D: Yeah that'd not be fun

@Vogel612 Obligatory; what colour are your switches ;)

Vogel612

@Peilonrayz blue

@this it didn't come with anything

Peilonrayz

Yeah, blues are quite nice. I like them more than my browns, but they're pretty noisy... my family didn't like the sound of my browns... never mind blues );

this

I'd be worried about storing it in a backpack or laptop bag - the way keys stick out, it'd make me think that storing in such containers would ruin the keyboards.

Vogel612

Dunno, it sounds pretty subdued to me, but that might be because I was used to some godawful mechanical keyboards from my school days... Couldn't think while anyone was typing there...

@this I haven't had it for long, so I haven't encountered that issue yet... I'm not moving my workspace all that often and with the pandemic I basically fully work from home.

it's just that my primary keyboard is slowly starting to show its age (and price) and I wanted to be more flexible with the replacement ...

Peilonrayz

@Vogel612 lol. I'm sure you'll enjoy your keyboard :D

this

21:47

I agree. it does looks great and more comfortable than those cheap-o flat keyboard they're hawking nowadays.

Vogel612

it feels a bit small for my hands, but that's to be expected for something that's intended to be portable

Feeds

You can come on in, we're all fully vaccinated. Except the spare room off the living room. Don't go in there, we're not fully vaccinated in there.

Peilonrayz

@this I've had my browns for like 5-10 years. I got some second hand blues from a friend who had them longer than I did, and split drink on them. (temporarily breaking the keyboard) My first key died on the blues this year ):

this

Educate this schmuck.... what exactly are blue/brown switches?

IvenBach

^ You are not alone. I'm ignorant to this also.

Vogel612

21:56

@this the colors are basically a proxy for the actuation behavior. That scheme is not universal, but it usually seems to map pretty well.

this

If you're talking about the mechanism used underneath the keys, I've not actually seen anything other than white or beige (maybe that's the brown)

Peilonrayz

Typically (for switches based on CherryMX colours) Red/Black = Linear force for the spring in the switch. Brown/Blue = non-linear so the force for the spring to go down is different for the force to go up (I know there's a physics word for this, but forget it). Then the difference between blue=clicky and brown=silent

this

ahh so it's not physically colored but just a reference?

Peilonrayz

If you yank a keycap off, the stems are coloured too :) But yes tells you what the spec for the switch is

this

Gotcha. I should look at a keycap next time I pop it off. I don't recall seeing any colors except white/beige as I mentioned.

Peilonrayz

21:59

You've probably not got mechanical switches, so are just white/beige

this

I know that around here foam is the popular choice for the cheap-o keyboards which is quiet but it's annoying to type with. My keyboard has something like a lever under the key.

My apple laptop did have something called scissor switch (?) which was quite nice.

Peilonrayz

AFAIK most cheap-o keyboards use membrane. So you have to press down on some plastic to to connect the switch - rather than a spring on mechanical keyboards. Scissor switches are quite nice IMO

this

yes, that's what I meant by "foam"

and they're horrid to type with, I try to avoid those.

Peilonrayz

Yeah that makes sense. Do you use the Apple ones much then?

this

I'm on an iMac. :)

Peilonrayz

22:09

Ah :) I can see how you've gotten away from the foam keyboards :)

this

Indeed!

2 hours later…

Duga

23:47

[rubberduck-vba/Rubberduck]: 1361 stars vs. [decalage2/oletools]: 1614 stars

2

« first day (2572 days earlier) ← previous day next day → last day (608 days later) »

Transcript for

Jun '2121

VBA Rubberducking

This chat has moved to Discord: discord.gg/MYX9RECenJ

antlr com-interop parsing rubberduck vb6 vba whiskey-tango-foxtrot

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC

site design / logo © 2025 Stack Exchange Inc; legal

mobile