VBA Rubberducking

Duga

12:02 AM

RELOAD!

[MDoerner/AdventOfCode2020] 3 commits. 992 additions. 2 deletions.

[rubberduck-vba/Rubberduck] 10 commits. 29011 additions. 9182 deletions.

[Minesweeper] Games Played: 61, Bombs Used: 42, Moves Performed: 8194, New Users: 10

IvenBach

1:56 AM

Is that you tracking downloads Mug?

this

2:08 AM

Very interesting use of colon

Mathieu Guindon

2:27 AM

wtf, I'm crashing on startup with .5906

BZngr

@this Agreed - using formatting to expose an inconsistent line of code. I've also seen colons for variable initialization code like Dim val As Long: val = 6 and I have to confess it looks cleaner and more compact - but I often see the declaration and miss the assignment...still undecided regarding that usage.

this

imy main problem is that its verbose because Dim foo As Foo : Set foo = New Foo when we really want just Dim foo As Foo = New Foo`

so i dsilike this particular (ab)use of colon.

Mathieu Guindon

adding vertical whitespace between the member signatures would help, I think.

it's ...crowded

this

The article does make a compelling case in the case of boilerplate code formatting though.

Mathieu Guindon

yeah

aka "that chunk of one-liner members you copy-paste between implementations because you can't derive from a common base class"

this

2:37 AM

^

the copy-pasta is strong with VBA

Mathieu Guindon

argh of course no repro with a debugger attached

Feeds

I think of myself as the David Attenborough of factory mailing equipment.

this

@MathieuGuindon log more?

Mathieu Guindon

ffs no more repro on the work laptop, and the startup was amazingly fast and it parsed automatically too

could have been some kind of one-off or race condition

I think we need to just disable the automatic initial parse

Hosch250

2:57 AM

@MathieuGuindon I got my boss to start using that, lol.

Also, conference is tomorrow, if anyone is interested. Check it out at sessions.mndevconf.com.

As official tech support and speaker, I need to go to bed. Oh, and a fiber cable got cut in my area so I don't have internet. I need to head to my mom's in the morning...

Mathieu Guindon

'night!

Duga

8:25 AM

[rubberduck-vba/Rubberduck] AR0x7E7 created comment on issue #4906: Encoding problem when adding attributes

> > @clig `VBComponent.cs` is fine, document modules are never reimported from the exported text file:
>
> https://github.com/rubberduck-vba/Rubberduck/blob/c33764648111ac09a8c6b1701e228686db5e92c9/Rubberduck.VBEditor.VBA/SafeComWrappers/VB/VBComponent.cs#L210-L223
>
> `TemplateFileHandler` looks like it might need a closer look though - thanks!

Running current release version 2.5.2.5906: one module of my project is exported in utf8 encoding, the other one in ANSI (checked with Notepad+

this

9:06 AM

Dim c As String
Dim l As Long
l = 123
c = "abc" * 1 & "abc"

#Why

FreeMan

11:08 AM

> Built with ❤️ by AppVeyor CI on [main] - https://ci.appveyor.com/project/rubberduck-vba/rubberduck/build/2.5.2.5906

This version fixes 40 bugs,

Shouldn't that be

> Built with ❤️ by AppVeyor CI on [main] - https://ci.appveyor.com/project/rubberduck-vba/rubberduck/build/2.5.2.5906

This version fixes **41** bugs,

@MathieuGuindon No repo in VBA (don't have VB installed to test)

@this #WhyNot

VBA only gives you the rope. The user hangs himself.

this

11:23 AM

No, I don't think the analogy works.

More like, it gives the user a dynamite. You don't know how long the fuse is, so as it's burning, you can only wait in anticipation of being blown to smithereens. That's worse than hanging.

Or, jumping out of the plane with the false promise that your backpack does have a functional parachute, realizing it's nonfunctional and you can only watch the ground rapidly approaching you and turn you into a pancake.

FreeMan

I dunno, it's not explicitly the language's fault that many programming practices now considered bad were taught as the norm when it was originally released.

And, of course, that VBA was targeted at non programmers who probably wouldn't have followed best practices, even if they'd known them, because "I'm only going to write this little bit of code that will only be used for a few months, a year tops, because IT will adjust our primary systems to handle this soon." and they didn't know their Excel worksheet would still be in use 18 years later...

Duga

11:56 AM

[rubberduck-vba/Rubberduck] Talorthain created comment on issue #5755: msgbox at start

> Hi, I have had the same issue in the latest release version. The only other addin I had was MZtools. I removed this addin and it started to work correctly.

[rubberduck-vba/Rubberduck] Talorthain edited comment on issue #5755: msgbox at start

> Hi, I have had the same issue in the latest release version.
![image](https://user-images.githubusercontent.com/6796503/116999986-52620100-acd8-11eb-9c84-f551a378e925.png)

![image](https://user-images.githubusercontent.com/6796503/116999951-47a76c00-acd8-11eb-9dac-f0910495381d.png)

The only other addin I had was MZtools. I removed this addin and it started to work correctly.

Son Goku ssj4

@Hosch250 sessions.mndevconf.com but what time and topic? :)

Duga

[rubberduck-vba/Rubberduck] aitorsol created comment on issue #5755: msgbox at start

> I have MZtools too but i like it so much and i don't want to uninstall it

El mar., 4 may. 2021 13:57, Anthony ***@***.***> escribió:

> Hi, I have had the same issue in the latest release version. The only
> other addin I had was MZtools. I removed this addin and it started to work
> correctly.
>
> —
> You are receiving this because you authored the thread.
> Reply to this email directly, view it on GitHub
> <https://github.com/rubberduck-vba/Rubberduck/issues/5755#issuecomment-831885249>,
>

[rubberduck-vba/Rubberduck] daFreeMan created comment on issue #5755: msgbox at start

> @aitorsol - it's not about permanently removing MZTools, but about testing to find out where the conflict is. Unfortunately, at the moment, it's up to you to decide which you want to use (you can alternate between them for their different functionality if you desire) until the Rubberduck team can get this issue resolved.

[rubberduck-vba/Rubberduck] aitorsol created comment on issue #5755: msgbox at start

> I am very happy with MZtools and I need it every day and I am sure that is
what interferes with the current version of Rubberduck to not working. I
will wait for the next version to try again because I am interested in this
utility.

El mar., 4 may. 2021 14:14, Brett Shepard ***@***.***>
escribió:

> @aitorsol <https://github.com/aitorsol> - it's not about permanently
> removing MZTools, but about testing to find out where the conflict is.
> Unfortunately, at the moment, it's up to you to dec

[rubberduck-vba/Rubberduck] Talorthain created comment on issue #5755: msgbox at start

> Hi, I like MZtool as well. It has features not in rubber duck, so I will be reinstalling it, but just wanted to test MZtools not loading.

N.b. I didnt uninstall, I disabled it from the Addin manager...

Regards

Anthony Taylor
________________________________
From: aitorsol ***@***.***>
Sent: 04 May 2021 13:08
To: rubberduck-vba/Rubberduck ***@***.***>
Cc: Anthony ***@***.***>; Comment ***@***.***>
Subject: Re: [rubberduck-vba/Rubberduck] msgbox at start (#5755)

I have MZtools too but i lik

Mathieu Guindon

1:14 PM

v2.5.2.1: 218 downloads overnight

FreeMan

wo0t!

Hosch250

@SonGokussj4 conference starts at 9 central time, I talk at 2. Topics are all sorts of dev stuff.

We have nearly 50 talks. And they are all recorded and available after the talk.

FreeMan

1:31 PM

@Hosch250 Giving a talk, eh? I'm going to have to tune in, see the real face & voice behind the cute puppy avatar! :)

Hosch250

It's probably not going to be especially polished.

But the other talks should be great. It's just $20 for a ticket. And you get access to last year too.

FreeMan

2:38 PM

Well, thank you very much, Comcrap... Just decided to do some work in our local network closet and took down my service for about 30 minutes with no warning. >:(

this

@FreeMan Comcrap : Stopped reading, identified the problem.

2

Duga

3:51 PM

[rubberduck-vba/Rubberduck] retailcoder synchronized pull request #5751: Introducing 'Peek Definition' commands

FreeMan

4:17 PM

TBF, they did increase my connection speed a few years ago without a rate increase, and I generally get higher speedtest.net speeds than they advertise, but... taking service down in the middle of the day without warning? Bad form! Don't mind all the people working from home or our youngest in the middle of a time-limited college final...

Duga

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

this

feh. speedtest.net is worthless if you're at the mercy of your porn-surfing neighbors.

Hosch250

Heh, someone cut the fiber cable so I don't have any internet.

I'm at my mom's for my talk today.

FreeMan

@this And, I'm 99.99999% certain that connections to known speedtest sites are #1 on the QoS priority list, while voice calls are #10, and everything else is lower. I get stunning test speeds and never get anywhere near that in real world downloads. But whatever...

Oh, and actually, service was up and down for 2 hours. :/

Mathieu Guindon

4:34 PM

current status: struggling to get the navigate and find all refs popup commands to work correctly from non-CE context menu

HackSlash

Network connections are as fast as the slowest operation. Generally, you're going to be limited by disk IO on the server you are connected to. This can be seen when downloading a game from Steam, which is the best service I have ever seen. I regularly get 40-70MB\s downloads from Steam but I've never seen speeds like that anywhere else.

Max throughput on gigbit fiber is ~120MB/s so Steam can at least saturate %50 of the pipe.

this

4:49 PM

I don't think disk IO is usually the bottleneck usually. Disk IO usually is some magnitudes faster than network traffic. It's the last mile that's the bottleneck usually.

HackSlash

Spinning rust is really similar to gigbit. They both push about ~120MB/s in my real world testing. Local copies and network copies run at similar speeds. What you say is true for any solid state storage solution. That's where you need 10GB networks.

or 40GB networks if you hate money

When talking about a server with multiple users, the disk IO is hammered. They need really robust storage solutions to keep up with the network requests.

Vogel612

in-memory caching is a thing for such servers

this

5:10 PM

I also think it bears pointing out that they are more likely to use some form of RAID storage where they can boost the output, particularly for read-heavy workload.

Upgrading storage and memory are relatively cheap. Getting better QoS? mucho money.

Son Goku ssj4

6:33 PM

@Hosch250 half hour. Nice, I didn't miss it. Good luck :-)

Hosch250

I'm getting ready to go live.

Hosch250

7:53 PM

Did I put y'all to sleep?