VBA Rubberducking

I am actually using a DLAN connector to connect my PC to the router, but the one from Devolo. It works pretty well. However, it only works well because both ends are on the same wire. If you have to go through a circuit breaker, it gets really slow.

Duga

2:02 AM

[rubberduck-vba/Rubberduck] ThunderFrame created comment on issue #3995: VB6 VBForm parse errors

> I'm not sure if you've also seen that:
- hex values are prefixed *and* suffixed with ampersands.
`BackColor = &H00FFFFFF&`
- property names can start with an underscore
`_ExtentX = 5741`
- frx references are *relative*, so they can include any valid path, including `\` and `:` characters.
`TextRTF = $"C:\foo\frmMain.frx":5EE0`

Also, this is a useful test frm - https://github.com/VBGAMER45/Semi-VB-Decompiler/blob/master/Semi%20VB%20Decompiler/frmMain.frm

ThunderFrame

3:38 AM

@mansellan ^^ Try your code on the FRM linked in that comment.

Peter M Taylor

4:43 AM

Just a quick question to ask for all. Does this statement sound true. “That open source RD is in fact maintaining a legacy system of Microsoft’s VBE!”

ThunderFrame

The VBE might be old, but it's still shipped and supported by MS, so IDK if I'd call it legacy just yet

Peter M Taylor

6:43 AM

If that’s the case @ThunderFrame what’s does it take to call the VBE a legacy then irrespective of being shipped or not?

ThunderFrame

@PeterMTaylor VB6 is legacy. Windows XP is legacy. I guess my interpretation is that if it isn't in official support, then it's legacy.

Duga

[rubberduck-vba/Rubberduck] MDoerner created comment on issue #3995: VB6 VBForm parse errors

> Thank you.

The first two should not be a problem since they are a standard hex literal and standard identifier, respectively.

For the third, we will have to see.

Peter M Taylor

Thank you that helps @frames one way of thinking

sorry frames typo

Duga

[rubberduck-vba/Rubberduck] MDoerner edited comment on issue #3995: VB6 VBForm parse errors

> Thank you.

The first two should not be a problem since they are a standard hex literal with a type suffix and a standard identifier, respectively.

For the third, we will have to see.

Duga

7:55 AM

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Parsing/Grammar/VBAParser.g4 of pull request #4111: VB6 - Add missing VBForm grammar cases

ThunderFrame

9:27 AM

@Duga I didn't realize the parser processed any of the FRM lines before the VB Attributes.

Duga

10:36 AM

[rubberduck-vba/Rubberduck] mansellan commented on Rubberduck.Parsing/Grammar/VBAParser.g4 of pull request #4111: VB6 - Add missing VBForm grammar cases

Duga

10:59 AM

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Parsing/Grammar/VBAParser.g4 of pull request #4111: VB6 - Add missing VBForm grammar cases

M.Doerner

@ThunderFrame We started processing them in order to support VB6.

More precisely, to support VB6 forms, which show the entire form declaration part in the editor.

ThunderFrame

11:15 AM

@M.Doerner ok, thanks. Will be interesting to see how it handles that form I referenced

mansellan

@ThunderFrame Planning to work on it some more after work today

@M.Doerner :lightbulb: VB6 doesn't do that - it acts the same way as MsForms showing just the code part. Does that mean we don't need to parse the header?

Duga

11:32 AM

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Parsing/Grammar/VBAParser.g4 of pull request #4111: VB6 - Add missing VBForm grammar cases

ThunderFrame

@mansellan That linked FRM is a nice chunky test case that has almost every feature exercised.

2

IIRC, the whitespace is entirely optional. The indentation is only for readability.

mansellan

11:49 AM

@ThunderFrame Much appreciated. Just this and the resolver issues and VB6 is pretty shippable.

ThunderFrame

@mansellan IDK how the VB6 FRM interpreter knows the format of the items that are embedded in the FRX. I guess for built-in controls, it knows that Caption will be a header and string, and Picture will be a header and blob, but how does it know for 3rd party control properties? I guess it must load the TypeLib and determine the types?

M.Doerner

12:28 PM

My guess is that it simply uses dynamic typing, i.e. It loads everything as Object and uses extended members. If it does not work, it will raise an error at runtime.

Hosch250

1:15 PM

> We aim to invest in GitHub’s social fabric to ensure the OSS community thrives, and GitHub becomes an even more trusted developer home for all developers on all platforms.

blogs.msdn.microsoft.com/devops/2018/06/04/vsts-github/…

Hosch250

2:16 PM

I'm not sure what to think about the results of my vacation. I came back to work completely fed up with it. Not sure if it recharged me out of apathy, or what.

@this Why I read that as ER, I don't know.

IvenBach

@Hosch250 welcome to work

Hosch250

@IvenBach IKR?

Hosch250

2:33 PM

Coworker just showed me a bottle of Leninade.

> Drink, comrade, drink! It's that or the gulag.

Mathieu Guindon

it's good with Victory Gin

Hosch250

2:49 PM

Best. Answer. Ever.

-2

A: How to politely reject a rude advice giver at the gym that won't take it well anyways

Politely grab the nearest fire extinguisher and cool off his attitude.

Mathieu Guindon

"politely" lol

> Please excuse me while I suffocate you in CO2 fumes

FreeMan

3:20 PM

@Hosch250 bunch o'killjoys downvoted that into oblivion! I was about to register and give it an upvote, but not worth it at this point...

Hosch250

@FreeMan They are right that it makes a better comment than answer, though.

It's gone now, but I bet the user couldn't make comments.

FreeMan

3:32 PM

@Hosch250 but, to your point...

43 mins ago, by Hosch250

Best. Answer. Ever.

:)

What's the text in the RD status bar called that tells you what your cursor is currently sitting on?

it's missing in .3398

issue incoming. ;)

Mathieu Guindon

@FreeMan that would be the "context-sensitive selection label", or something like that :)

Duga

[rubberduck-vba/Rubberduck] daFreeMan opened issue #4112: Status bar missing identifier information

> Win10, Office 2016 (desktop), RD .3398

Even after a clean compile and an RD parse, the status bar is _not_ showing me any information about the identifier my cursor is currently on.

![rd missing path](https://user-images.githubusercontent.com/11889733/41607792-db682174-73b4-11e8-911d-0ebd379ac484.PNG)

[rubberduck-vba/Rubberduck] daFreeMan edited issue #4112: Status bar missing context-sensitive selection label

FreeMan

I went with a somewhat more generic "information", but I've updated...

now... I know why my query is timing out (poorly written queries will do that), I need a temporary band-aid of "longer timeout" to let it run until I get back from vacation so I can fix it properly...

Mathieu Guindon

@Duga could be a side-effect / symptom of the current resolver issues

@tilde: i'm a programmer, and we avoid being wrong, which is why i said "probably"... It's like when they ask if a bug's fixed; we say "seems to be working" instead of "yes"... — dandavis 19 hours ago

IvenBach

3:52 PM

^ All outward appearances and testing indicate that the unexpected behavior has been rectified.

IvenBach

4:04 PM

The more I use AC the more it just feels natural.

Hosch250

4:30 PM

You know how you can block electrical signals with faraday cages?

I wonder what would happen if you ran a wire through one.

Probably nothing is my guess, but...

IvenBach

If the wire itself is going through one, nothing.

Hosch250

@IvenBach Thank you.

So, I can't disable big brother's TV by putting a faraday cage around the wire :(

IvenBach

Mind you I'm not an EE.

Nope.

Mathieu Guindon

@IvenBach I can foresee a value-added addictiveness to it :)

"oh gosh, you're not using Rubberduck... I can't. I just can't."

IvenBach

For i = 1 to 10 <Enter> For j = 1 to 10 <Enter> I'm now ready to type the body.

AC still has some minor complaints. Those are far outweighed by the benefits of it.

Duga

4:34 PM

[rubberduck-vba/Rubberduck] daFreeMan created comment on issue #4112: Status bar missing context-sensitive selection label

> This seems to have been a very much 1 time thing. I've got the VBE opened from both Access (where I saw the problem) and Excel now, and I'm not seeing it in either.

Here's the current log. Sorry, I should have posted as soon as I saw it. This is probably a conglomeration of both Access & Excel.

[RubberduckLog.txt](https://github.com/rubberduck-vba/Rubberduck/files/2116055/RubberduckLog.txt)

IvenBach

Public function Foo<Tab> Inputting the As <Type>

Mathieu Guindon

^ I need to fix that. it doubles up the As token if as is already there

IvenBach

Woot! git fetch --prune I understood. ignoranceLevel--

Mathieu Guindon

> LV1 Achievement unlocked: beat the mug at git

:)

I've no idea what --prune does

IvenBach

> Before fetching, remove any remote-tracking references that no longer exist on the remote.

I deleted branches from my repo but my local copies still existed. Previously I would look them up to make sure I wasn't deleting the wrong one. I've since become ~~lazier~~ more efficient and use git fetch --prune

Mathieu Guindon

4:40 PM

hmm

Quack Exchange

-1

Q: How to make the code quicker?

I'm currently using the following code, which seems to run fine with workbooks within 10mb; however I work with large databases, and frequently the size of the files goes over 25/30mb. In those instances the code tends to take ages, and breaks more often than not due to running out of system memo...

vba

Hosch250

@IvenBach If working in VS, it has a setting to do prune automatically.

Relatively recent, and doesn't remember across updates.

IvenBach

They rolled that out ~4 months ago. I remember you telling me.

I don't recall where the setting is.

Hosch250

Source Control Explorer.

IvenBach

Doing it through command prompt is exposing me to more git stuff either way.

Hosch250

4:46 PM

Open the Commit/Branches... dropdown. Select Settings, then Global Settings.

IvenBach

Source Control Explorer is empty for me.

TFS is not your current SC plug-in. Click here to set the current SC plug-in.

Hosch250

Open RD, or something that uses Git, to populate that.

IvenBach

Found it again. In Team Explorer>Settings>Globar/Repo Settings>Prune remote branches during fetch

I do have RD open. That's why having it tell me SC wasn't set up was a bit odd.

:manly-grunt: git remote prune upstream cleaned up the random branches left dangling.

@Vogel612 The mysteries of git begin to unfold before me. It's no less magical, even as I begin to comprehenderize it.

Vogel612

you'll see it becomes less and less magic

IvenBach

It'll still be magic.

Vogel612

4:54 PM

meh#

Hosch250

Meh#? Sounds like a fun language.

Mathieu Guindon

#MehSharp

with its fabulous IDE plugin, MehSharper

Hosch250

LOL.

TFW you need to make sure the release stays on track, and you want to do anything but program.

Read about security exploits, sure.

Develop a language syntax, sure.

But not program.

I'm sick of being a code monkey.

Spend 8 hours a day programming other people's designs.

/complaints

Could be worse.

Vogel612

be glad you don't need to clean up other people's messes yet

Hosch250

@Vogel612 Oh, but I do.

Vogel612

5:00 PM

at least not for ~3 workdays straight

Hosch250

For 5 workdays straight, 3-4 weeks a month.

Fixing and re-fixing and re-re-fixing bugs because I'm not allowed to rewrite the @#*(@ thing.

mansellan

@MathieuGuindon It keeps your repo regular :-)

4

Hosch250

And because we don't have competent testers or any UI tests or any unit tests around this feature because it all wires directly to the DB.

And changing one thing breaks all the other things.

IvenBach

^ Isn't the real world great?

Vogel612

sounds nice...

Hosch250

5:01 PM

Fortunately, we got a new time tracking bucket for support.

I'm logging as many hours of time into support as I did for development.

Maybe that'll show them.

FreeMan

@mansellan LOL

Mathieu Guindon

@Hosch250 reminds me of a certain VB6 gig

Hosch250

@MathieuGuindon Yep.

The company is nice, but if I could just get some of this stuff cleaned up...

I don't see any future cleaning two/three parts of it up, but working on the rest...

Mathieu Guindon

let me guess.... non-technical boss?

Hosch250

@MathieuGuindon She worked as a programmer about 20 years ago, from what I can gather.

She's OK.

She just doesn't have the authority to authorize a rewrite.

Mathieu Guindon

5:05 PM

refactoring?

Hosch250

We need to get the buy-in of sales, upper management, and the people that support the client.

@MathieuGuindon Refactoring is out of the question. We don't refactor here.

Mathieu Guindon

you won't get that

Hosch250

@MathieuGuindon Exactly.

Mathieu Guindon

sales sees 0 value in clean code

Hosch250

We can't refactor unless there is an explicit real business need coming from a client.

Mathieu Guindon

5:06 PM

upper management sees 0 value in clean code

Hosch250

@MathieuGuindon When it hits their pocketbook, they will.

Mathieu Guindon

they won't

Hosch250

When I get a couple hundred hours, I'm going to call a meeting.

IvenBach

I'm reviewing rubberduckvba.wordpress.com/2017/10/25/userform1-show and the designer is the default that gets displayed when you double click on the userform, or right click>View Object?

Mathieu Guindon

@IvenBach huh?

Hosch250

5:07 PM

Say, here's a couple hundred hours I put in in two months that could have been avoided. You are paying me XYZ. Don't you think we should minimize this kind of stuff?

Guess what? The industry has developed techniques to do it, but you have to do it right from the bottom up.

IvenBach

> A UserForm is essentially a class module with a designer and a VB_PredeclaredId attribute.

Mathieu Guindon

and?

IvenBach

Want to make sure I correctly understand designer.

Mathieu Guindon

the designer is the drag-n-drop visual tool you use to "design" the form...

IvenBach

:+1: understood correctly.

Mathieu Guindon

5:09 PM

i.e. what put the "Visual" in "Visual Basic"

IvenBach

Main takeaway is that while a visual designer may be nice, make sure you know how to do it programatically?

Hosch250

@IvenBach Definitely. And, TBH, avoid the designer when possible.

IvenBach

mmk. I can do that now.

Mathieu Guindon

@Hosch250 not impossible, but quite the PITA in MSForms. BTDT.

Hosch250

@MathieuGuindon Me too.

I just go edit the designer file.

That way, the messy-ness is contained somewhat better.

If you write invalid code, the designer breaks. If you write valid code, it's no different than using the designer, but often cleaner.

Mathieu Guindon

5:25 PM

@Hosch250 you're talking WinForms. I mean MSForms, i.e. VB6/VBA

Hosch250

Oh. gets lost

IvenBach

7:39 PM

Thanks for your article Mug. I still have to work on using the MVP concept. But your article clarifies what it is and how to set it up.

Duga

9:09 PM

[rubberduck-vba/Rubberduck] IvenBach opened issue #4113: AutoCorrect using value in string literal and named argument for completion

> Using `Enter` when the cursor is located at `|`
```
Public Sub MVCEforAutoCorrect()
Set sourceInformation = Application.InputBox("for", Type:=8)|
End Sub
```
Results in below.
```
Public Sub MVCEforAutoCorrect()
Set sourceInformation = Application.InputBox("for", Type:=8)
|
Next
End Sub
```
If the cursor is moved to `|` and `Delete` is instead used, note the `Next`
```
Public Sub MVCEforAutoCorrect()
Set sourceInformation = Application.InputBox("for",

Mathieu Guindon

@Duga dupe

IvenBach

Seeing Next has been described. Seeing End Type part of the dupe?

github.com/rubberduck-vba/Rubberduck/issues/4088 is original source.

Mathieu Guindon

oh shit, named parameters now

IvenBach

2 mins ago, by IvenBach

Seeing Next has been described. Seeing End Type part of the dupe?

That was a totally unexpected autocompletion.

Duga

[rubberduck-vba/Rubberduck] IvenBach edited issue #4113: AutoCorrect using value in string literal and named argument for completion

Mathieu Guindon

9:15 PM

make it be about named arguments; string literals is already reported

Duga

[rubberduck-vba/Rubberduck] IvenBach edited issue #4113: AutoCorrect using value in string literal and named argument for completion

[rubberduck-vba/Rubberduck] IvenBach edited issue #4113: AutoCorrect using value in named argument for completion

Mathieu Guindon

:+1:

IvenBach

> This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

Means a whole lot more now that I see all the bugs software tries to resolve.

Duga

[rubberduck-vba/Rubberduck] retailcoder edited issue #4113: AutoCompletion using value in named argument for completion

Mathieu Guindon

TTQW

Peter M Taylor

9:49 PM

@Hosch250 so the link from MS is a commitment for more frequent releases for TS as well as VSTS.

Duga

11:13 PM

[rubberduck-vba/Rubberduck] Vogel612 added label bug to issue #4113: AutoCompletion using value in named argument for completion

[rubberduck-vba/Rubberduck] Vogel612 added label critical to issue #4113: AutoCompletion using value in named argument for completion

[rubberduck-vba/Rubberduck] Vogel612 added label difficulty-03-duck to issue #4113: AutoCompletion using value in named argument for completion

[rubberduck-vba/Rubberduck] Vogel612 added label feature-autocomplete to issue #4113: AutoCompletion using value in named argument for completion

[rubberduck-vba/Rubberduck] Vogel612 assigned retailcoder to issue #4113: AutoCompletion using value in named argument for completion

[rubberduck-vba/Rubberduck] Vogel612 added label status-norepro to issue #4112: Status bar missing context-sensitive selection label

[rubberduck-vba/Rubberduck] Vogel612 added label bug to issue #4112: Status bar missing context-sensitive selection label

[rubberduck-vba/Rubberduck] Vogel612 created comment on issue #4112: Status bar missing context-sensitive selection label

> closing as norepro, until an at least semi-stable repro is added

[rubberduck-vba/Rubberduck] Vogel612 closed issue #4112: Status bar missing context-sensitive selection label

Vogel612

@MathieuGuindon and that's why one does not do this with regex

then again it's not feasible to reparse on every keypress...

not that we have facilities to parse code that's "in typing"

mansellan

11:31 PM

Transcript for