VBA Rubberducking - 2017-06-28

« first day (1118 days earlier) ← previous day

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

2

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.

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.

« first day (1118 days earlier) ← previous day

Transcript for

Jun28

VBA Rubberducking

Discussions about general VBA. Also the war room of the Rubber...

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

mobile