VBA Rubberducking - 2017-06-28 (page 1 of 2)

« first day (1118 days earlier) ← previous day next day → last day (2062 days later) »

12:00 AM

@Hosch250 I don't need to go that far.

I just need to sell one widget.

It's a good widget.

RELOAD!

What does it do?

Or is that a secret for now too?

[rubberduck-vba/Rubberduck] 1 opened issue. 1 issue comment.

@Hosch250 I can't say, because every one of you are better programmers than me and this has been going on for 4 years now.

LOL.

12:01 AM

It would take any one of you (or a group of you) literally days to remake it.

To give you a hint, the project has been recreated several times, and the most recent incarnation was created October 11, 2015.

Maybe you should've hired me to do it last year.

Can't afford to.

I registered domains for this project on July 1, 2014.

@EBrown Happy upcoming 3rd vaporware anniversary ;-P

3

@ThunderFrame No kidding.

You know that feeling when you piss money out the window?

@EBrown yep - I'm the proud owner of several domains :-(

12:16 AM

@ThunderFrame I own like a hundred.

I'm pretty sure I spend ~1.2k a year in renewals.

I recently registered knowyourmime.com - just need to think of a product...

I registered b----imfamo.us and made my email batman@.

Because I could.

Pretty sure that one expired, but I still have -----imaweso.me.

lol - I have techs.mx

Mexican domains are a PITA

I also have willyougooutwith.me. For some reason that site is down.

DDOS attack?

12:24 AM

Nah, it's redirecting to my root site, which is fine because that's what I have IIS doing if that site is down.

Oh I deleted that site.

Whoops.

12:53 AM

@Mat'sMug one to bookmark - codingvision.net/miscellaneous/…

2

@Hosch250 what stack are you working with at the new job again?

1:14 AM

[rubberduck-vba/Rubberduck] shadowofsilicon forked us into shadowofsilicon/Rubberduck

4

1 hour later…

2:18 AM

@RubberDuck Depends on the widget.

Usually, it's ASP.NET MVC (C#), HTML, jQuery, and KnockoutJS (good for certain uses, but not for dynamically loading data). I also do a little CSS (we use Bootstrap and SCSS).

And plain JS, of course.

2:55 AM

Good stuff man. You'll have to let me know what you think about Knockout sometime.

3:44 AM

[rubberduck-vba/Rubberduck] retailcoder created branch docs

[rubberduck-vba/Rubberduck] web-flow pushed commit 9b8d8326 to docs: Created TOC.md

[rubberduck-vba/Rubberduck] retailcoder deleted branch readme-cleanup

[rubberduck-vba/Rubberduck] build for commit 9b8d8326 on docs: AppVeyor build succeeded

6 hours later…

9:40 AM

[rubberduck-vba/Rubberduck] pstakashi starred us

3

3 hours later…

12:53 PM

@shadowofsilicon Thank you!! That's been bothering me for a while now, but I've been too busy to report it. Plus, sometimes I think I'm the only one who cares about those little things since I'm much more of a keyboard guy...

@ThunderFrame Is that anything like Chex.mx™?

@FreeMan lol - mine is pronounced tex-mex, to tex-mix

1:12 PM

@ThunderFrame so, if you inject a DLL into a running process, how do you make calls to it since the existing code won't know of any procedure names in it? Or is the presumption that the injected DLL has a procedure of the same name as an existing procedure and will take priority over the existing one, thus executing your new code?

I can definitely see the malware-y nature of doing what he's doing, but I can see the benefit for RD to be able to latch more directly into the VBE process and, for example, get live keystroke updates and be able to reparse exactly and only what's changed on the fly.

1 hour later…

2:15 PM

@FreeMan doing that will be much easier if we subclass the codepane and inject our own editor control

2:45 PM

@Mat'sMug Does that involve the DLL injection techniques described in the article, or is that totally different?

totally different

2:59 PM

Got it. I was trying to determine the method of using the injected DLL.

3:22 PM

> Call Error(4, xKdnr1) ~shudders~

wtf?

lovely names isn't it :)

Also FWIW Dim xUmsatz, xOLiP, xSt1B, xSt1P, xSt2B, xSt2P, xSt3B, xSt3P, xSt4B, xSt4P As Long declares xSt4P (whatever that means) as a Long, and everything else is an implicit Variant - a classic beginner mistake. Avoid declaring multiple variables in the same instruction, avoid walls of declarations at the top of a procedure - declare variables as close as possible to their first usage. Thank yourself later. Rubberduck can probably help you with some other VBA traps. — Mat's Mug 3 mins ago

There is so much wrong with that lol.

IKR!

I saw that question, downvoted, and moved along. No way I was gonna try to help him lol.

3:33 PM

@DAXaholic: You could mention further that even if the link is broken, one can put the text cursor within the function name TypeName in VBA-Editor and press [F1]. Then exactly the same information is displayed. And this hopefully will be so as long Excel VBA exists. — Axel Richter Jul 14 '16 at 6:21

if only half the people learning would use F1 half as much as I did learning VB4/5/6... SO would be a much cleaner place

I really should learn my hotkeys and quick tricks lol

I still am in the habit of Debug.Print instead of ?

@Hosch250 Bring it to the big banks and work "blockchain" into the name, you'll be swimming in money.

hehe.. I was using ? to debug my Commodore-BASIC code :)

Even better, build an Etherium Token, call it "Bancor", publish a whitepaper, get handed $150 Million.

registers bancor.org

sounds like "bank" + "encore"

what's an Etherium Token?

3:45 PM

@Mat'sMug It's a way to build a crypto-currency, without building a whole blockchain from scratch. You just build one on top of the Etherium Blockchain.

~swooshed~ mkay

If you like, Etherium coded a class object called "CryptoCurrency". And now, rather than coding your own, you can just say Dim myCurrency As New CryptoCurrency

You get to extract away the whole process of building a blockchain, and Etherium gets to power your network.

I must be old. No idea what the purpose of crypto$ might be.. Other than for shady stuff.

@Mat'sMug So I can buy socks from the silk road.

2

@Mat'sMug The idea is to have a distributed network that doesn't have or require any central authority.

One of the most obvious use-cases is transactions. Especially large international transfers.

But if you can remove the need for a trusted intermediary, that disrupts a giant sector of economic activity.

Think "The Internet".

Except that you can buy a portion of it.

Well, maybe not "The Internet", but "Lots of competing internets".

3:58 PM

@Kaz I own a bunch of domain names, don't those count as portions? :P

@EBrown Not really. This is much more "I own 0.0000001% of all the economic value that moves over the internet".

Which back in 1990, is not a lot.

But by 2010, it's a gigantic fortune.

[rubberduck-vba/Rubberduck] BaronBodissey opened issue #3088: "unknown" exception

> Just following rd advice to create an issue with the log file.

Also, I suggest you instantiate rolling log file as there's so much log that one log file isn't enough.

Best regards.

2017-06-28 18:02:59.0860;INFO-2.0.13.32288;Rubberduck.App;Rubberduck version 2.0.13.32288 loading:
Operating System: Microsoft Windows NT 10.0.15063.0 x64
Host Product: Microsoft Office 2016 x86
Host Version: 16.0.8201.2102
Host Executable: WINWORD.EXE;
2017-06-28 18:03:15.5350;WARN-2.0.13.32288;

@Duga logs get overwritten per-session...

[rubberduck-vba/Rubberduck] retailcoder added label feature-source-control to issue #3088: "unknown" exception

[rubberduck-vba/Rubberduck] retailcoder added label bug to issue #3088: "unknown" exception

[rubberduck-vba/Rubberduck] retailcoder commented on issue #3088: "unknown" exception

> The `COMException` is thrown here:

> **Microsoft.Vbe.Interop._VBComponent.Export(String FileName)**
à Rubberduck.VBEditor.SafeComWrappers.VBA.VBComponent.ExportAsSourceFile(String folder, Boolean tempFile) dans C:\Users\Mathieu\Documents\GitHub\Rubberduck (main)\Rubberduck\Rubberduck.VBEEditor\SafeComWrappers\VBA\VBComponent.cs:ligne 142

Does the path include spaces? Is it a UNC path?

[rubberduck-vba/Rubberduck] BaronBodissey commented on issue #3088: "unknown" exception

> nop:
C:\Users\memyself\Desktop\DotNet\Office\repogittestrubberduck

4:18 PM

hi @A.S.H!

hey! Mat's !!

how is everything?

I think RD source control is going to Hell.. other than that all is good :)

why? what do you mean?

#SoManyIssues

solve them one-by-one :D

5

4:21 PM

[rubberduck-vba/Rubberduck] retailcoder commented on issue #3088: "unknown" exception

> hmm, would the ProjectId happen to contain funky characters? Verify the %appdata%\Rubberduck\SourceControl.rubberduck configuration file.

I'll eventually lose it and just rewrite the damn thing

@Mat'sMug You're reaching your breaking point.

[rubberduck-vba/Rubberduck] BaronBodissey commented on issue #3088: "unknown" exception

> nop...for what I see:

<?xml version="1.0" encoding="utf-8"?>
<Configuration>
<SourceControlSettings>
<UserName />
<EmailAddress />
<DefaultRepositoryLocation />
<Repositories>
<Repository>
<Id>97244304</Id>
<LocalLocation>C:\Users\memyself\Desktop\DotNet\Office\repogittestrubberduck\Project</LocalLocation>
<RemoteLocation>C:\Users\memyself\Desktop\DotNet\Office\repogittestrubberduck\Project</RemoteLocation>
</Repository>

[rubberduck-vba/Rubberduck] BaronBodissey commented on issue #3088: "unknown" exception

> nop...for what I see:

```
<?xml version="1.0" encoding="utf-8"?>
<Configuration>
<SourceControlSettings>
<UserName />
<EmailAddress />
<DefaultRepositoryLocation />
<Repositories>
<Repository>
<Id>97244304</Id>
<LocalLocation>C:\Users\memyself\Desktop\DotNet\Office\repogittestrubberduck\Project</LocalLocation>
<RemoteLocation>C:\Users\memyself\Desktop\DotNet\Office\repogittestrubberduck\Project</RemoteLocation>
</Repository>

@TrevorD ah! good one! Just so happens that the next release of Rubberduck will introduce @PredeclaredId, @Exposed, @DefaultMember, @Enumerator and @Description annotations (aka "magic comments"), and an inspection quick-fix to synchronize annotations and attributes =) — Mat's Mug 30 secs ago

good timing there

@IvenBach I am. Source control has been flaky from the start, half the time for stupid reasons.

@Mat'sMug I feel sorry to hear that, but you know, it's always like that in this business. "des hauts et des bas" ;)

4:32 PM

[rubberduck-vba/Rubberduck] retailcoder commented on issue #3088: "unknown" exception

> Is it the only open project? Source Control was designed to work with the active project, wheels come off if there's project-switching involved... TBH source control wheels come off for too many reasons to my taste though.

0

Q: Select highest and second highest values

i've written a procedure to where it selects the first and second highest values not already selected (as designated by previous highlights of green and yellow). The first highest ignores anything already highlighted in green or yellow and selects the highest value. The second highest value ignor...

2 hours later…

6:17 PM

@SiddharthRout thanks! Now I need it to be able to infer types from usage, and that inspection+quickfix will be complete! =) — Mat's Mug 1 min ago

shadowofsilicon

6:28 PM

can anyone help me; I had a working build of Rubberduck. I switched over to my github fork that I made yesterday, and now VS won't build Rubberduck.dll

is VS running as administrator?

shadowofsilicon

yes

ok good.

did you de-register the build in the other location?

or wait a minute

"VS won't build Rubberduck.dll" - what error(s) are you getting?

shadowofsilicon

haha i feel silly... after staring at this for 30 minutes i read through the list of errors - it was bad code i entered last night lol

@BrandonBarney You're trying to be beat @Mat'sMug for verbosity, aren't you?

6:33 PM

What do you mean? But, in all fairness, it wouldnt be unlike me. I am an English major after all :p.

@IvenBach if that's referring to issue 3088, I think it's a different Brandon :)

It would be indeed lol.

He's starting to infect his ducklings, making them type paragraphs of correcting goodness.

Oh you mean on CodeReview?

oh, he posted a CR answer?

6:34 PM

3

Q: Select highest and second highest values

i've written a procedure to where it selects the first and second highest values not already selected (as designated by previous highlights of green and yellow). The first highest ignores anything already highlighted in green or yellow and selects the highest value. The second highest value ignor...

You bet. I definitely learned after Mat's Mug for that lol.

> Shameless Plug For Rubberduck

love it!

lol

I fingers of dyslexia don't let me do any long-winded explanations...

to be fair, with RD I just give bad indentation a mere smirk nowadays :)

6:36 PM

I envy a bit those that can.

Yeah, I used RD for the indentation bit lol

No way i was manually fixing it

@BrandonBarney I had to reject that edit, since it modified OP's (horrible) [lack of] indentation. I did remove the illegal line breaks though, well spotted!

No worries. I wasnt sure if the indentation should be left given how bad it was, but I figured I would put the edit out there :)

aye, [bad] indentation is definitely a reviewable aspect of the code :)

FWIW I think there's a huge missed opportunity to eliminate most of these redundant loops - SearchRange only needs to be iterated once...

ok, twice, since OP is re-purposing SearchRange

I did consider that. My approach would be to use a collection of some sort to hold the highest three values. My concern was trying to teach someone too much at once.

With his current approach to the problem, I doubt he will understand the logic behind that type of routine.

6:45 PM

Don't worry about force feeding new ducklings. Foie gras is part of the learning curve.

2

you don't need to supply copy-pastable code - but pointing out the redundant looping could be worth it. pretty sure someone will come along and mention it anyway :)

With programming there is a big risk of scaring someone away altogether. People tend to think "I cant learn math" but letting them do it without realizing, and then pointing out "That's math" works.

7:31 PM

I don't understand this Late Bound member inspection.

I was using Application.CountA(). I read the inspection text and tried replacing everything with Application.WorksheetFunction.CountA() as I understood the text to be saying. I refreshed, then open the Code Inspections, and the results were still there. Then I tried it just as WorksheetFunction.CountA(), same thing.

What am I misunderstanding?

that would be a bug

try saving, closing everything and then re-loading RD

Will do, thank you!

LMK if it works

I suspect it's a caching issue

(probably already fixed in current build though)

Yes, that cleared it up.

I'm going to run a few more tests for you.

I'm going to replace it with Application.CountA() again and see if it shows up in inspections. And then I'm going to disable and re-enable Rubberduck to see if that resolves it being stuck.

Anyone in here have experience in Data Analytics? In particular I have a question about finding the most important properties that affect an observation on a large dataset.

7:38 PM

@puzzlepiece87 whatever you do, don't disable/re-enable RD through the VBE's "Add-Ins" menu

(or be prepared for a spectacular VBE seizure)

@BrandonBarney I might be able to help you.

@Mat'sMug Oh really? I didn't know that. I didn't get a seizure when I did it before. Good to know.

@Mat'sMug First test passed - when I change it back to Application.CountA(), the results re-appear in Code Inspections.

from release notes:

I have a set of data with hundreds of thousands of rows of data. All at the individual record level (which is important). I wanted to run a coefficient matrix on the data to see the relationships between the different observations, but due to the size of the data I am unable to load it into R (not enough RAM). Is there a good way of creating a summary of the data that will still show accurate results for the relationships between the properties and the observation I am looking at?

> Unloading, and then re-loading the add-in from the IDE's "addins manager" will no longer wreck the IDE and its host, but still won't re-load correctly. Don't do that.

@Mat'sMug Good to know.

7:42 PM

@puzzlepiece87 aye, and then the Excel.Application.CountA declaration's references collection won't get reset on re-parse, which is why the inspection results "stick". fix confirmed in an unreleased commit some time ago by @M.Doerner

@Mat'sMug Second test failed as expected - after making the code inspection results show up again, changing back to WorksheetFunction.CountA does not clear the results. I won't do the disable/re-enable test because of what you told me.

For the record, even better would be a way of parsing a large amount of data into R without running into the RAM issue. So any code packages for that would be great.

@BrandonBarney Hey sorry, I'm completely unable to help with that since I don't use R. My only idea would be sampling.

Can half your data load into R?

No worries. Its a rather specific problem :). I may have to sample it, but I am comparing a subset population to a greater population as is, so I would need to sample both.

Sampling should be a last ditch solution anyway

7:46 PM

And to complicate matters, this change could impact thousands of people, so I would prefer to load it all and analyze it that way.

Since you would have to get a random half of your data like 30+ times, then load it into R, which I'm sure would be an enormous pain.

Yeah, that wouldnt be feasible.

Plus, it's been a long time since I've taken statistics and I'm unsure exactly how many samples you'd have to take to have reliable indicators.

I would literally rather buy more RAM for my work computer lol.

:D

7:48 PM

Though...I wonder if my boss's computer has enough ram. He has an extra 8gb... That may be the route to go lol

For some distributions you can get away with 30+ samples to approximate the means, correlations, etc., but I forget if that changes once you start doing mass samples rather than individual samples.

I imagine mass samples would be more accurate but it's all fuzzy in my head

Yeah, I am not confident enough in the field on my own to risk it while still giving a recommendation.

Anytime you can wrest your boss's computer away, you have to do it. Power move ;)

lol

Lunch time

7:49 PM

The next course I teach = new home computer, and if I can somehow sneak it past my wife that means the Razer Pro

Also, RD hasn't had 2-3 stars/forks today, tell everyone to wake up lol.

Razer Pro huh?

Lol hilarious

$4500?

If you make enough money to afford that easily, you have won at life my friend :)

What are the specs on this monster

I know its ridiculous, I just want it. The reasonable side of me will likely go for a rig thats closer to $1800. I dont make that much at my job, but I make 4k per course (8 weeks) so thats the only reason why I can justify it.

32gb RAM, beast of a processor/graphics card, thunderbolt ports, etc.

@BrandonBarney what courses do you teach?

I teach Intro to Composition I and Intro to Creative Writing

After looking at the specs, I feel like you could almost get this same thing for $1800 from Sager.

7:53 PM

As much as I can dream about the Razer Pro though, my wife likely will block that before I can get anywhere near it.

Do you want the 14" or the 17"?

17"

Oh never mind then

I considered the HP Omen, but 16GB is it's max RAM option.

Yeah from Sager I think it would cost about $2500 instead of $4500

7:54 PM

I have a few months before it is even a possibility, and I'll likely go for a cheaper rig since I should be a rational human being that makes sound financial decisions.

A man can dream though!

The other thing you should do before you buy is to read a review with heat testing to make sure all that power isn't being throttled to pieces.

I saw some laptops that were shipping with SLI video cards, which is basically just ripping people off at that point.

Yeah, I have to pay special attention to how it handles heat. I pretty much ruined my last laptop because I abused it.

I wouldn't recommend a laptop with a top end processor and video card like that (or like mine) without at least 2 fans.

I got a Sager laptop with a 970 and core i7 two years ago for $1300 that I've been really happy with.

I see new faces

I got mine for ~1500 and loved it, but of course ruined it by leaving it always on/always plugged in and without ventilation. I bought my wife an 1800 rig that still runs beautifully and has had no issues.

7:57 PM

(15" and TN screen and no SSD, which is why I'm guessing your hypothetical 17" top everything monster would be $2500 from Sager)

So I want to splurge a bit this time, but also treat it well.

Sounds smart :)

Is it safe to assume you game big time on it?

Hi @Jelly

The big thing is I plan to spend the next few years developing my skills in Data Science so I need a capable rig.

I actually dont game on my laptop at all, I just like having the performance there when I need it. I enjoy photo processing, some gaming (for a bit at a time), but mostly programming.

@BrandonBarney Ah, got it. I should probably follow your lead but for now I'm working on mastering VBA and SQL and starting C#.

So I know a graphics chip is generally a waste, but I still go for a good rig.

shadowofsilicon

7:59 PM

I have a PR for issue #3087... when I submit the PR, how to I assign it to that issue? I

My job is Data Analytics so in some ways I am forced to learn Data Science further lol

@BrandonBarney If I ever #AutomateAllTheThings I'll probably be back into Data Analytics also. That's where I started basically.

I took a detour from Data Analytics to healthcare.

Which has lots of overlap.

[rubberduck-vba/Rubberduck] retailcoder assigned shadowofsilicon to issue #3087: Rename dialog - OK button should be default selection

@shadowofsilicon you don't ;-)

Gotta go for the day. See you all tomorrow!

8:02 PM

later!

Later!

@shadowofsilicon you can reference the issue by adding a comment e.g. "ref. #3087" in the PR itself

shadowofsilicon

I figured that "assign" was the wrong terminology... but I figured there must be a way to tag it

ideally when you make a commit that closes an issue, you use GitHub's magic keywords in the commit message

e.g. "closes #3087"

that way GitHub knows there's an incoming commit that will close the issue, and when the PR is merged, the issue gets closed automagically :)

shadowofsilicon

awesome! thanks!

8:07 PM

[rubberduck-vba/Rubberduck] shadowofsilicon created pull request #3089: Rename dialog button keyboard shortcuts to merge shadowofsilicon/Rubberduck/next into rubberduck-vba/Rubberduck/next

@Mat'sMug Is it a fixed bug that RD code inspections show "(variable) is never assigned" for passed parameters referenced inside subs/functions?

(Let me know if that's confusing)

@shadowofsilicon that worked!

user image

Nice job @shadowofsilicon!

shadowofsilicon

Thanks! First contribution to an open source project. Huzzah!

6

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

8:10 PM

@puzzlepiece87 probably, need to check. I would expect a number of tests to fail if that's the case... although, some inspections are rather poorly covered

@Duga huh, that's all it needed?!!

01-duckling indeed!

[rubberduck-vba/Rubberduck] retailcoder closed issue #3087: Rename dialog - OK button should be default selection

[rubberduck-vba/Rubberduck] retailcoder merged pull request #3089: Rename dialog button keyboard shortcuts from shadowofsilicon/Rubberduck/next into rubberduck-vba/Rubberduck/next

@shadowofsilicon awesome! keep 'em coming! :)

[rubberduck-vba/Rubberduck] shadowofsilicon pushed commit 246586ae to next: Set IsDefault to "OK" button, IsCancel to "Cancel" button, and default focus to textbox in Rename refactoring dialog

[rubberduck-vba/Rubberduck] andrewzschetzsche pushed commit 83bfe42a to next: fix previous commit

shadowofsilicon

@Mat'sMug Yup. Two lines. If only it was that simple to get the text automatically selected in the text box, it would have been included too.

@Mat'sMug You are right. For example, the same situation fails the Undeclared variable inspection.

8:12 PM

also fixed

@shadowofsilicon that probably needs some code-behind event handler to be registered

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

yup

177

A: How to automatically select all text on focus in WPF TextBox?

We have it so the first click selects all, and another click goes to cursor (our application is designed for use on tablets with pens). You might find it useful. public class ClickSelectTextBox : TextBox { public ClickSelectTextBox() { AddHandler(PreviewMouseLeftButtonDownEvent,...

IOW subclass the TextBox control and add the behavior, save the new control in the Rubberduck.UI.Controls namespace; done, and reusable :)

@shadowofsilicon Well done. @Mat'sMug welcomes any capable coders he doesn't have to hand-hold, I'm one of those.

@puzzlepiece87 Best way to start is trying and failing. Make it a goal to start your entrance into C# by the end of summer.

any contribution is welcome, however small it may be

[rubberduck-vba/Rubberduck] Vogel612 removed label status-deferred from issue #2603: Control declarations aren't cleared from the cache on reparse.

[rubberduck-vba/Rubberduck] Vogel612 added label feature-request to issue #3023: Option to have RD run the IDE toolbar 'Debug>Compile' on parsing

[rubberduck-vba/Rubberduck] Vogel612 added label status-declined to issue #3023: Option to have RD run the IDE toolbar 'Debug>Compile' on parsing

8:29 PM

@IvenBach I'm not in a hurry - I may need to start job applications any day, so learning new languages isn't my first priority at the moment.

Protip: with Rubberduck's next release (scheduled some time in July), you can replace 'Description: {foo bar} with '@Description("foo bar"), and then you'll get to see that description at call sites and in the Object Browser! =) — Mat's Mug 6 secs ago

That will be a nice feature!

aye, getting module and member attributes more widely known is a good thing. we just need to figure out a way to neatly expose the functionality - annotations aren't exactly easily discoverable ATM

@Ignore (for inspections) and @TestModule and @TestMethod and the other test-related annotations, and @NoIndent are probably ok as-is, but the new ones...

I think I'll post selfies on SO

lol, googling "vba adding predeclaredid attribute" turns up Chris' blog, RD News, SO docs, .......and then RD issues #2851 and #1491

8:50 PM

(Though possibly only for you due to Google personalization)

@puzzlepiece87 I wish you the best of luck if you do look for work.

@IvenBach Thanks - it depends on US national news. From my personal and employment perspective, the news this week was good.

@Mat'sMug We could create mini-refactorings that add the attributes.

I love my current job.

@M.Doerner it's currently in SynchronizeAttributesQuickFix (although, member attributes aren't implemented yet)

Oh, you mean for discoverability - hmm even simpler, make them add the annotation, and let the inspection tell the user they need to sync attributes

Hmm, or break that quickfix down into a bunch of small refactorings, expose the refactorings as commands, and make the quickfix call the appropriate refactorings

No, the quickfix is for synchronizing attributes, i.e. when there's an annotation without a corresponding attribute.. that wouldn't work...

So yeah, make them add the annotation, and then the MissingAttributeInspection will just do its job

@puzzlepiece87 a way to handle module and member attributes has been on the RD wishlist since day 1 =)

9:04 PM

The dream, realized!

Also, I got another piece of the dream yesterday.

So my own code is in decent shape, so I mostly rely on the code inspections feature.

The quickfix still needs a way to work off a bunch of inspection results though.. Otherwise it's kinda wasteful to export, tweak, reimport and reparse for every missing attribute/annotation in a module

But yesterday a coworker came to me to rescue his project at the last minute

So I had the indenter going, I was "Fix all occurrences in project"ing, RD was getting the work done.

And it blew up in your face while coworker was watching?

I'll probably feel even more comfortable doing emergency refactors once I get to play around with the extract method tools. I'm going to do that tomorrow.

Extract Method is currently disabled

9:07 PM

Ha no, it was surviving okay, we got it done in time to rescue his training class today.

(sadly)

Oh, so it is :(

That's okay, thanks for all the work :)

I don't want to be one of the people who absolutely requires a calculator for long division anyway.

You can download 1.4.3.at home and try the old implementation if you want =)

:P

I'd rather try Next branch, but I barely have anything to play with at home.

Just a vote-counting thing I made for church that I will clean up and slap on github and my resume if I start job hunting.

1.4.3 had a number of parser issues... Testing it out for kicks would make you appreciate all the work that went into 2.x even more! ;-)

9:12 PM

Ha, I'm already appreciative due to the bugs in 2.0.13

I've heard you all mention several being fixed already and I'm grateful :)

I mean, performance probably improved something like 10000%

2

You all have come a long way :)

I'm sure @RubberDuck is very proud also :)

9:29 PM

[rubberduck-vba/Rubberduck] shadowofsilicon opened issue #3090: Rename dialog, text in text box should be selected on load

> User selects the dialog from the menu, types in the new value, and presses Enter. Bam!

@shadowofsilicon Your emphasis is duly noted.

@Duga user presses refactor/rename hotkey, types in the new name, enter, done. mouse: untouched.

[rubberduck-vba/Rubberduck] shadowofsilicon created pull request #3091: select all text in textbox when loading to merge shadowofsilicon/Rubberduck/next into rubberduck-vba/Rubberduck/next

> I admit that I don't understand how this works...

But eventually I will learn enough to understand.

Closes #3090

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

@puzzlepiece87 more like guilty that I've not been more help.

@RubberDuck hey there!

BTW I haven't heard back from last email, hope I didn't creep you out lol - I'm all moved in now :)

9:42 PM

@Mat'sMug and you & I wrote those SO docs! Lol

:)

@Mat'sMug oh no! Not at all. I was just telling @Hosch250 that I need to get those mailed out.

Things have been nuts. A lot of team churn and I'm gearing up to tackle MIT's open courseware.

look at you. not so long ago that duckling was leaving the VBA nest and flapping at its first C# code

4

you've come a long way!

@RubberDuck How long do you have working with C#?

@IvenBach since his first commit on Rubberduck :)

9:50 PM

I should have asked "In a work-employed" environment.

Seems RD is the entry point for a few in regards to C#.

Ok, I'm forced to upvote this. But I have to say this kind of circular-referencing code is completely disgusting and I would be very mad at whoever used this trick in production code. That hack defies the VBA call stack logic, defies common sense, defies everything that's good in the world. — Mat's Mug 2 mins ago

reply of the year:

@Mat'sMug You should know by now that I have no logic (even if VBA does have call stack logic), that I have no common sense, and that I (and everything else in the world) can't be called "good". :D — YowE3K 43 secs ago

10:02 PM

@IvenBach I did it professionally for 18 months. Currently working with Scala, Java, Ruby, Groovy, Hadoop, Spark, and Kafka.

Oh. I'm also coaching a team on Kanban and XP... I might have bit off a bit much to chew with the new job.

Oh god. I'm such an imposter.

6

How long had you worked with C# before you started being employed because of it?

@RubberDuck #FakeItTillYouMakeIt seems to be the rule of thumb.

Uhhhh 6 months of RD? Another 3-6 of learning before that?

@IvenBach word

You were learning stuff constantly while on the job?

gosh, TTQW

[rubberduck-vba/Rubberduck] IvenBach opened issue #3092: Right click>Rubberduck>ToDo Items

> Functionality exists for 'Find all references...', just no ToDo items.

[rubberduck-vba/Rubberduck] IvenBach edited issue #3092: Right click>Rubberduck>ToDo Items

10:10 PM

@IvenBach yeah. Absolutely was and still am.

Glad I'm not the only one that feels inadequate at what they do.

Distributed systems are.... interesting. A whole different beast from desktop and "normal" web stack.

Nah mate. I think the best of us always feel a bit inadequate.

@RubberDuck soo ... I'm working at the "Institute for Parallel and Distributed Systems" at Uni Stuttgart.

@RubberDuck I have ups and downs, it's curious to see other developers that feel similarly inadequate. Sometimes I feel wonderful because I fix some stupid bug I've tracked for a few days, and other times I feel like "meh"

and some of the people there could use a good coaching on XP and Kanban

there's a whole bunch of CS masters lectures on the subject

and only checking the introductory lecture made me curious already...

10:30 PM

@Vogel612 that's seriously interesting.

And most academics could I imagine.

Current-Self is shaking my head at Past-Self and the way I coded this... this... nasty thing.

2

@Vogel612 have you worked with Akka at all? It's really got my attention. I've been wanting to learn it better.

nah. I didn't get to do any scala yet ...

all the code I've seen to date about that was Java.

and the distributed systems are not something I'm currently programming.

I'm basically just at that institute and doing standard application programming..

had some touches with ActiveMQ.

maybe you heard of TOSCA? that's what I'm on right now.

[rubberduck-vba/Rubberduck] shadowofsilicon edited pull request #3091: Rename dialog - select all text in textbox when loading

10:50 PM

No. Even not heard of that. googling

I'm guessing not the opera. en.m.wikipedia.org/wiki/Tosca

good guess :)

« first day (1118 days earlier) ← previous day next day → last day (2062 days later) »

Transcript for

Jun '1728

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 © 2024 Stack Exchange Inc; legal

mobile