VBA Rubberducking

« first day (2804 days earlier) ← previous day next day → last day (376 days later) »

Duga

00:00

REFRESH!

[Minesweeper] 92 Games Played. 67 Bombs Used. 11855 Moves Performed. 24 New Users

1 hour later…

this

01:16

@HackSlash this is more "official" (for some value of official): docs.microsoft.com/en-us/DeployOffice/security/…

6 hours later…

Duga

07:23

[rubberduck-vba/Rubberduck] ykurihara-git starred us

4 hours later…

Freeflow

10:57

To get a learner permit to drive a car one of the qualifying tests should be that you have ridden a bicycle over a distance of 5000 miles in the past two years (on roads used by cars). Only then will you have a true understanding of the utterly abysmally low standard of driving prevailing (even here in the UK).

1 hour later…

FreeMan

12:06

@MathieuGuindon Seems they've been doing that for years, haven't they? I've had to click the yellow "enable macros" banner for as long as I've been at my current job for anything that wasn't in my Trusted Locations list.

Ah, read the article. "MOTW" also seems to apply to files located anywhere on an internal network. Or, at least it can be configured that way by local IT folk.

@Freeflow That's not a bad idea at all!

1 hour later…

this

13:19

Just to note, though, it works out to requiring bicycling 7 miles a day 7 days a week for 2 years. Not gonna to have a lot of qualifying people (which is arguably not a bad thing either)

FreeMan

13:59

Us 'muricans could use the exercise. You seen the average size of us?

Interesting new message from Excel:

Really? I opened a CSV and you're warning me about saving in .txt format? What's that about?

this

I think .txt, .csv and .tab are all "text" format and thus equivalent. Some intern got lazy and hardcoded .txt instead of looking at the file extension?

FreeMan

14:18

This is a totally new warning, though. Either that or I clicked "ignore" in the (distant) past and something has reset the ignore flag...

this

not sure it's new. I've seen it before.

FreeMan

> Either that or I clicked "ignore" in the (distant) past

I guess that applies, then.

oh well...

this

Excel really, really, really want you to save it as a .xlsx because features!!1!

FreeMan

features I don't need since this is just the intermediary file between 3rd party app and a SQL table, but sure. ;)

this

BUT FEATURES!!1!

FreeMan

14:20

lol

\o/

laughing and partying are so close...

or is that "throwing hands up in frustration and giving up"? that's often the alternate to laughing...

life was so much easier when there was only :-) and :-(

this

:-|

FreeMan

\ol

this

hey, you can do a wave

\o/ \o o
o/ \o/ \o
o o/ \o/

FreeMan

someone's bored

this

yes, waiting

FreeMan

14:33

then read this

Q: Discovered developer doing Leetcode puzzles when he should be working

I hired a remote developer to work on a project with a client some months ago. He has been playing around on Leetcode.com throughout the working day hours, when he has active tasks in progress. I'm estimating for up to 2 hours per day. They are not communicating that they are blocked on their tas...

this

oof

FreeMan

in particular this answer

a lot of really good answers in support of said developer and not the boss posting the question.

2 hours later…

Duga

16:41

[rubberduck-vba/Rubberduck] jhoobergs added label bug to issue #5944: Running a unit test which fakes both MsgBox.Returns and InputBox.Returns fails

[rubberduck-vba/Rubberduck] jhoobergs opened issue #5944: Running a unit test which fakes both MsgBox.Returns and InputBox.Returns fails

> **Rubberduck version information**

Rubberduck version 2.5.2.5906 loading:
Operating System: Microsoft Windows NT 10.0.19042.0 x64
Host Product: Microsoft Office x86
Host Version: 16.0.14827.20158
Host Executable: EXCEL.EXE;

**Description**
Running a unit test which fakes both MsgBox.Returns and InputBox.Returns fails with "Running a test method failed with an exception".

**To Reproduce**
Steps to reproduce the behavior:
1. Create the following procedure
`

1 hour later…

Duga

17:46

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot created comment on issue #5944: Running a unit test which fakes both MsgBox.Returns and InputBox.Returns fails

> Side note, the "Unexpected exceptino" typo should be fixed together with this issue.

Vogel612

@Duga somebody been playing with robots, huh?

Duga

[rubberduck-vba/Rubberduck] Vogel612 added label feature-fakes to issue #5944: Running a unit test which fakes both MsgBox.Returns and InputBox.Returns fails

[rubberduck-vba/Rubberduck] Vogel612 added label feature-unit-testing to issue #5944: Running a unit test which fakes both MsgBox.Returns and InputBox.Returns fails

this

Welp, looks like robot apocalypse is here now. Nice knowing y'all.

Freeflow

SO I'm sat here scratching my head during a debugging session only to find that vartype(<stack>) returns the value 8 (as string) and that if I debug.Print <stack> I get "System.Collections.Stack" and consequently the code to filter out objects with a default string property is failing (Case VarType(p.Input) = vbString And IsObject(p.Input)). I don't get this issue when I pass in an <arraylist> or <queue>.s

2 hours later…

this

19:45

@Freeflow I think the only way around that is to write your own function with OERN + Set tmp = ...; if the Set fails, it ain't an object and you can then use VarType().

IsObject() is supposed to do that but it fails because it takes a Variant and therefore the implicit member access rules applies.

Hosch250

@Freeflow During my last years of high school and college, I did about 3k each summer.

100/wk for roughly 30 weeks, depending on weather.

Hosch250

20:01

@BigBen I realized the more I know, the less I answer on SO. Granted, my areas of expertise (primarily C# and ASP.NET Core) are already covered well.

BigBen

@Hosch250 nice one. I agree, well, getting bored with answering VBA questions on SO and moving on to other languages.

Hosch250

What's up with y'all?

My contract at work got pulled abruptly a week ago ending today, but I have a new one lined up for tomorrow.

Going from C#/ASP.NET Core microservice backends with CI/CI pipelines and terraform-created resources in Azure (everything I've worked on) to a Node/Express app with Apollo Client/Server GraphQL, React frontend, and Neo4j database.

BigBen

nice switch

Hosch250

My current company hopes to bring me back in a few months, but the VP running the project got a new boss who wants to know the current system before he writes the VP a blank check.

We were migrating an old system to a new microservice-based system, so no databases yet (we were writing an API around the old system/DB), but we were going to start migrating databases and making the microservices entirely self-contained shortly.

Looking forward to learning neo4j, though. Fiddled around with it a bit on Sunday, and it's pretty neat.

3 hours later…

Freeflow

22:55

@this Yes, the like most problems, once you know what is causing the problem its easy to solve. Elucidating the problem is the skill. It doesn't stop you the rolling of the eyes and prefixing Microsoft with a variety of Anglo Saxon crudities.

Duga

23:45

[rubberduck-vba/Rubberduck] 1515 stars vs. [decalage2/oletools] 1934 stars