VBA Rubberducking

Duga

12:00 AM

RELOAD!

[Cardshifter/HTML-Client] 21 commits. 1271 additions. 8478 deletions.

[rubberduck-vba/Rubberduck] 41 commits. 1 closed issue. 7 issue comments. 5518 additions. 2773 deletions.

IvenBach

6:10 AM

@MathieuGuindon It's only taken a year and 5 readings of rubberduckvba.wordpress.com/2016/07/05/… but I've finally absorbed it, I think.

ThunderFrame

9:15 AM

IMO - the blog still needs some CSS/monotype love for code blocks

Hosch250

1:52 PM

Hey, MS emailed me about a call!

5

Hosch250

2:12 PM

I laughed https://t.co/E59jMi8fv9

Tweeted by politicalmath on January 16, 2018 at 4:49 PM

Hosch250

2:29 PM

It's Jason Malinowski and Jinu Joseph.

Vogel612

2:39 PM

@ThunderFrame YES!

Hosch250

@ThunderFrame It might actually have it.

I think it's something like [code] and [/code].

Vogel612

@Hosch250 I'm pretty sure he was talking about the ouptut formatting ...

Hosch250

Yep, that fixes the output formatting.

Vogel612

because that's sorely lacking in that section..

Hosch250

checkersweblog.wordpress.com/2017/02/17/using-tuples-in-f

For an example of that notation ^

Let me recover my password, and I'll post the correct notation.

[code language="fsharp"]

And [/code]

[code language="csharp"]

rubberduckvba.wordpress.com/2017/05/05/inspections-2-1

That's using that on my post on the blog.

Vogel612

2:52 PM

thank you :)

Hosch250

I forgot where I found that. It's not easy to find.

I don't have a list of valid languages, but I'm guessing visualbasic or vb would work pretty good. They might even have vba.

this

FWIW< we used to use that but it had problem and would break when we changed the CSS. We ended up using a WP plugin called Crayon. Of course, that blog can't use WP plugins...

Hosch250

@this And it can't change the CSS.

Time to think of a list of questions to ask. I don't need to ask about source control--they are on GitHub.

this

#TIL HKCU-installed COM objects are NOT available to programs running as admin....

Mathieu Guindon

@Hosch250 oooooh!!

head, meet desk

this

3:06 PM

so now I know the COM registration are ok. It's the AddIn that's not so OK....

Hosch250

@MathieuGuindon desk, meet head

There. Introduction complete.

this

lol - can't find path with: file:///C:/Users/firstname%20lastname/AppData/Roaming/Rubberduck/Rubberduck.dll‌ but can with file:///C:/Users/firstname lastname/AppData/Roaming/Rubberduck/Rubberduck.dll

Vogel612

yea, URL-Encoding is one of these special places in hell

this

for whatever reasons, the regasm chooses to do the percent encoding path but from I see, it works fine with normal paths. Doesn't help explain why addin won't load, though.

I already verified I can successfully CreateObject("Rubberduck.Extension") so I know it can be created but in Excel, if I try to launch the VB with addin registered, I get Out of memory and VBE won't start at all

Mathieu Guindon

3:30 PM

@this put the path in double quotes

@this hmm

this

just to be clear, simply having a Rubberduck.Extension key (even without the required subkeys) is all that's need to stop the VBE cold. Even if LoadBehavior = 0.

Hosch250

@this Perhaps it's because it doesn't have the required subkeys?

this

debugger not a help since the DLL doesn't even get a chance to load, so I know it's something to do with "finding" the class but not sure exactly what.

Yes even with the minimum required subkeys, it will behave the same

As soon as I delete the addin key altogether, VBE will then load

Hosch250

Have you regasm'ed it?

this

this is running w/ no regasm at all

hmm, lemme see what happens when I regasm it.

oh wow

even with the regasm, same error.

i had excluded all the custom registry entries, except for the AddIn key itself, manually regasm'd the assembly

well, now I know it's likely less to do w/ the installer and more with the build something.

the debug build has the same error. :(

whhaaaaaa

it's on the next, too

Duga

4:31 PM

[rubberduck-vba/Rubberduck] bclothier commented on issue #3817: Rubberduck.Extension should add CommandLineSafe DWORD value

> I think there is another piece of evidence that CommandLineSafe simply doesn't apply to VBA hosts -- the MZ Tools 3.0 and Watchdog both has the parameter set. However, when viewing via the add-in manager, the Command Line option which is always greyed out is persistently blank, in spite of having the key. That indicates to me that VBE isn't bothering to read the key despite having a checkbox for it (which I assume was borrowed from VB6 which do support that setting).

IvenBach

@Hosch250 well done. If a good sign. Good luck.

this

hmm. something's rotten here. I install 2.1.1 installer, it loads. Unregister it, clean, rebuild the next, and it loads....

Duga

[rubberduck-vba/Rubberduck] retailcoder commented on issue #3817: Rubberduck.Extension should add CommandLineSafe DWORD value

> As far as I know that setting is ignored / has no effect whatsoever in the VBA IDE. Doesn't hurt to have it I guess... Fun fact: early RD builds did specify that value, it was removed specifically because useless in VBA.

this

and my branch works.... WTF/min++;

hey, now. I unregistered w/ regasm and it still loads?

that's good, though as that's an evidence that regasm is NOT required to make addin loaded, but... why can it still find it...

this

4:58 PM

my, less and less sense. turns out regasm.exe isn't deleting registry entries it's supposed to delete when unregistering.

going to take a walk before my WTF buffer overflows.

3

IvenBach

5:15 PM

@MathieuGuindon rubberduckvba.wordpress.com/2018/03/15/vba-trap-default-members is missing an if on ‘foo = ActiveSheet.Range("B12").ValuesError(foo) Then’

At least it displays as lacking on my phone.

Mathieu Guindon

@this or, you're using the wrong build location? or the wrong bitness for regasm?

@IvenBach huh, they're completely separate statements... It's If IsError(foo) Then

I need to fix the code formatting across all posts

Hosch250

I'd offer to help, but I don't have edit access to posts that aren't mine.

Mathieu Guindon

The bright side is that doing it repeatedly for dozens of code blocks, I'll have no excuse to not do it for any future post =)

2

IvenBach

5:32 PM

@MathieuGuindon they don’t show up as separate. They appear to be smashed together and that’s what caught my eye. ‘valueserror’ isn’t a member I’d seen before.

For inspections we have language opportunities. Should there be one for specific hosts?

Hosch250

@IvenBach That might not be a bad option.

Something like ExcelOpportunities?

Or more generic HostOpportunities?

IvenBach

I know it’s not designed for a specific host but it’s be helpful to know of any Inspections that tie directly to which host

Hosch250

Should RD even ship with host opportunities by default? That's something I would seriously consider making add-in options that they check a box to install.

IvenBach

I’d find it helpful but mug could do another RD poll and get customer feedback.

this

FWIW, i'd just ship it. If it's not needed, nobody gonna to miss it

That is a case where giving more options => confusion

IvenBach

5:40 PM

#ThereIsNoOption

this

bTW, if anyone could do me a big favor and pull down the next, uninstall the release build completely from the system, can we verify it runs OK on other system?

oh probably should unregister the release, too.

@MathieuGuindon I'm using the registry entries to verify where I should unregister from. Normally that delete keys.

CallumDA

This seems like one that you guys could answer well stackoverflow.com/questions/49350845/implement-a-string

this

6:02 PM

#TIL I remember why I hate writing Windows installers. The phrase "doing same thing again and again expecting a different result is insanity" simply do not apply to windows installer.

Mathieu Guindon

6:20 PM

@CallumDA the answer with the default member is pretty much what I'd have suggested... Although, it's arguable whether doing that is a good idea

BTW you may have missed this:

22

Q: Putting down my mug

I joined CR in May 2013, but only started living here in September of that year. I remember very well then, the site had been in beta for almost 1000 days, and I kept thinking that was a shame, CR was such an awesome twist of the Stack Exchange format, it had to "graduate". Soon I met folks that...

@IvenBach meh. The few Excel-specific inspections won't fire results in other hosts, and user can disable them already

CallumDA

6:45 PM

@MathieuGuindon, fair play - you've given a hell of a lot to this community!

Mathieu Guindon

I love Chip Pearson's work - but saying the default member of a Range is it's Value, is taking a bit of a shortcut. The default member is a hidden member named [_Default] (you can see it in the object browser if you toggle hidden members), which seems to return the Value... but if it was consistently the case, then the default member would have been the Value property, not some hidden member. Clearly there's more to it than meets the eyes! ...and this is why default members are evil: you can't know what your code really does without digging into implementation details. — Mathieu Guindon 18 secs ago

@CallumDA thanks! ...and I'm not done =)

this

7:12 PM

~~hmm. I think I may have solved it.~~

Hosch250

7:26 PM

@this I like the edit :)

this

TBH I really really wish Windows never had registry. It's always the freaking registry that causes pain and misery. MSI formats, too.

Vogel612

8:23 PM

MS just missed the junction at directory tree based configuration

Hosch250

9:28 PM

I wouldn't be surprised if they'd redesign it if they possibly could without nuking every program written for Windows ever.

Vogel612

well... they did write WSL.. it's theoretically "just" a matter of building an adapter between registry and a virtual file system

next step is replacing the virtual with a mixed filesystem and then deprecating registry

and then finally replacing the mixed filesystem with a raw disk filesystem

Hosch250

As far as that goes, I guess most applications don't even really use it anymore.

Most .NET applications doesn't register things with the registry, AFAIK, and neither do Windows Store apps.

this

this won't address the underlying problem though - it's not really about the storage format but more about the DLL hell problem introduced with a "public" list

Vogel612

9:53 PM

FWIW at a certain point *NIX systems have a similar problem with the paths of sharedobjects libs

this

yeah, that's true. Upgrading PHP would be very very painful pre-Docker (and pre PHP-5 I guess)

used to be that it was intimately tied to the OS version, which was brutually stupid

Hosch250

10:29 PM

@MathieuGuindon You should get one of these things: youtube.com/watch?v=C1bg31Xsfsk

Mathieu Guindon

@Hosch250 LOL

Hosch250