VBA Rubberducking

Hosch250

20:00

I got the award I was gunning for!

Mathieu Guindon

MVP? :)

this

Congrats!

Hosch250

My boss, and my ex-boss got it too :).

No, Outstanding Achiever. 15% of the company gets it.

Mathieu Guindon

nice

this

ex-boss but not ex-employee, right?

Hosch250

20:01

Correct. She got promoted.

They fired her boss, gave her the position, and split IT up a bit.

Promoted a couple of people to manage certain sections of IT and still do their normal workload.

Mathieu Guindon

@JohnyL try public string Foo { get { return _foo; } int set { _foo = value; } } in C#, tell me how that goes. — Mathieu Guindon 41 secs ago

checks C# 8.x notes to ensure that isn't going to be supported

you never know

Hosch250

@MathieuGuindon 99.999999% sure it won't ever happen.

Mathieu Guindon

I like how it's not quite 100%

the answer should be H*CK NO!!

this

but, but.... I want to be expressive!

don't you slam down on the spirit of creativity, you .... you pencil pushers!

Mathieu Guindon

point is, method overloading doesn't support mismatching return types anyway

i.e. it was never about method overloading

Hosch250

20:08

@MathieuGuindon It's 100% with the current team.

Mathieu Guindon

@this millenial raises hand "what's a pencil?"

"ooooh the 'edit' icon!"

FreeMan

@MathieuGuindon at first I laughed, then I had a sad.

Comintern

I think I'm going to start ignoring SO questions that refer to VBA as a "script" in the title. If I wanted to look at that, I'd follow the [batch-file] tag.

mansellan

@MathieuGuindon actually ISTR that the CLR does support overloading by return type, it's just not legal at the language level (for c# at least)

Comintern

How would you disambiguate the calls?

mansellan

20:23

Not sure... might be received wisdom, heard someone say it but didn't verify.

They claimed obfuscators used it as a trick

Inarion

Hey guys, can someone explain to me why there are two separate places where the Inspection default settings are stored?

IvenBach

I feel like a winner. 16 ducks should be enough for everyone at the pond.

Inarion

(There is Rubberduck.Core/Properties/Settings.settings and Rubberduck.Core/App.config)

Mathieu Guindon

@mansellan gosh that does mean it could happen eventually right?

Inarion

And furthermore, are we supposed to manually keep them in sync? Or are there tools that would do that, and I just happened to not use them adequately?

Mathieu Guindon

20:29

they just gotta convince Eric Lippert to roll up his sleeves and dive back into overload resolution

mansellan

@MathieuGuindon If true I guess. May be wrong info though.

Mathieu Guindon

@Inarion Settings.settings is a designer for App.config

VS is [supposed to] keep them in sync

also...

@MathieuGuindon I didn't understand what you tried to say, but I just realized that my note about overloading has nothing to do with the question. )) — JohnyL 18 mins ago

there's hope!

Inarion

@MathieuGuindon And if it doesn't then my build process isn't doing its job?

Hosch250

@IvenBach 16 ducks?

IvenBach

20:47

Rubber ducks from a claw game.

I couldn’t resist when I saw them. Just a few odd looks from co-workers over how happy they made me.

3

Duga

21:01

[rubberduck-vba/Rubberduck] cswartzvi created comment on issue #4640: Rubberduck Add-In could not be loaded: System.IO.FileLoadException

>
@retailcoder :
> The assembly pubic key tokens aren't sensitive at all, they're just public IDs for known assemblies, namely Office.dll v12.0 in this case (key tokens are identical for that assembly, on every machine in the world)

Haha, thanks for pointing that out. Old habit dies hard I guess; we're a little overly security conscious at my work.

@bclothier :

> 1. Was the workbook read-only, or on a read-only media?

Nope

> 2. Was the file in a trusted location?

I have not

Mathieu Guindon

@IvenBach lol!

Duga

[rubberduck-vba/Rubberduck] retailcoder created comment on issue #4640: Rubberduck Add-In could not be loaded: System.IO.FileLoadException

> My fear is actually a borked Office install... are you in a position to repair the Office installation?

Mathieu Guindon

@Duga please please please let it not be RD's fault

Duga

[rubberduck-vba/Rubberduck] retailcoder edited comment on issue #4640: Rubberduck Add-In could not be loaded: System.IO.FileLoadException

> My fear is actually a borked Office install... are you in a position to repair the Office installation?

Does MZ-Tools load correctly? If MZ-Tools is able to create its menus then the Office.dll should be fine. If MZ-Tools is also having a hard time, ...

[rubberduck-vba/Rubberduck] cswartzvi created comment on issue #4640: Rubberduck Add-In could not be loaded: System.IO.FileLoadException

> No, I am not. However, I might be able to persuade those that are in that position (as a last resort).
Fortunately, MZ-Tools loads (both at start-up and manually) and runs normally.

this

21:16

Welp. I have no idea what it could be.

Duga

[rubberduck-vba/Rubberduck] cswartzvi edited comment on issue #4640: Rubberduck Add-In could not be loaded: System.IO.FileLoadException

> No, I am not. However, I might be able to persuade those that are in that position (as a last resort).
Fortunately, MZ-Tools loads (both at start-up and manually) and runs just fine.

M.Doerner

@Duga I would not be too sure. AFAIK, MZ-Tools uses custom interop assemblies.

this

Aren't we?

M.Doerner

I don't think so.

this

I really should find out how exactly we are using interop.

M.Doerner

21:17

We use MS-provided ones.

this

yes I was thinking more about the versioning

since we are not embedding the interops (I believe) to avoid locking us to a specific version of Office

M.Doerner

I think they are backwards-compatible,

Mathieu Guindon

^

that's why 12.0 makes no difference when you're running 16.0

M.Doerner

I.e. whatever you build with an older one should run with the newer one, too.

this

hmmm.

one thing not clear to me though - why would RD work on office prior to 2007?

AIUI, it was reported it can run just fine on Office 2003

M.Doerner

21:20

As long as you only call stuff that already existed back then, you should probably be safe.

mansellan

@this PIAs for Office 12 and VBA, home-rolled IAs for Office 8 and VB6.

this

i find it puzzling because that does not jive with my early experience of VSTO - it was embedding interop which also mean that it would blow up on a different version of Office, and required a new set of PIA to be shipped just to enable users to use a new version.

mansellan

@this And even 2000. I guess it's because the DispIds don't differ. Certain properties can't be called in early Office \ VB6, hence the missing toolbar icons in those.

this

(unless they did something in .NET 4 to make it less fragile, IDK)

@mansellan sure, but even in VBA, you can only go forward, not backward

mansellan

hmm...

this

21:23

so if you had an Excel project referencing Outlook 14.0, it will blow up when loaded on a computer that only has Outlook 2007 (12.0).

but the same project is fine on another computer with Outlook 2016.

mansellan

but the IAs do late-binding to the TLB IIUC?

via the clsids in the registry

(kinda out of my depth though)

this

TBH I don't know. I never really studied the internal mechanics of PIA.

M.Doerner

@this I have quite exactly this problem at work atm.

this

hence my puzzlement as to why RD would be even working if it's built against 12.0 PIAs.

M.Doerner

Somebody in IT had the glorious idea to update an add-in distributed to the entire company with office 2016. Unfortunately, we are still on 2010.

mansellan

21:26

@M.Doerner uh, whoops...

this

(and that might be also relevant to the poor sod's issue - I don't know if PIA will behave similarly to VBA reference in that if a newer version it will automatically forward to that version)

@M.Doerner fun!

M.Doerner

So, whenever I open anything, I get an error message that the reference to Word 16 was missing.

IIRC, we repeatedly got issues with RD breaking for people that had multiple office versions installed on their system over time, probably in the wrong order.

this

yeah, mutliple versions of Office is not very well-supported scenario

M.Doerner

There might be something funky with the PIA registration.

this

true it's possible but I don't think MSFT invest in so much effort in separation WRT versions. Especially not with Outlook

M.Doerner

21:29

MS says it should be OK, but only if installed in the right order.

this

yes that's the official documentation but the experience is otherwise.

I've seen machines get their references borked up

e.g. 2010 loading 2016 MSO.dll

M.Doerner

Fun

this

and that isn't always recoverable, not even after repair. Uninstall & install would be the only option

Duga

[rubberduck-vba/Rubberduck] retailcoder created comment on issue #4640: Rubberduck Add-In could not be loaded: System.IO.FileLoadException

> MZ-Tools is using its own interop libraries.. this complicates the comparison.

You wouldn't happen to have multiple, side-by-side installs of Office?

[rubberduck-vba/Rubberduck] retailcoder edited comment on issue #4640: Rubberduck Add-In could not be loaded: System.IO.FileLoadException

> MZ-Tools is using its own interop libraries.. this complicates the comparison.

You wouldn't happen to have multiple, side-by-side installs of different versions of Office?

M.Doerner

We really need a wiki page for the steps one as to take when adding something to RD; it is far too easy to forget something.

This happened to me just now for the annotations.

It is not enough to add an AnnotationType and a corresponding implementation of IAnnotation. One also has to add a creator to the AnnotationFactory.

Peter M Taylor

21:44

I like the hat on your icon @M.Doerner. :)

M.Doerner

It is the only one I have atm.

Peter M Taylor

Is it possible when an addin assembled/compiled from a newer verison conflicts when running with an older verison like 2010? Was thinking along the lines that I downloaded PowerPivot so it could work in 2010.

The innards could make that sort of error.

I see a blue hat on @MathieuGuindon. Nice.

Mathieu Guindon

:)

@M.Doerner are you making an "adding a new annotation type" wiki page? I could write one tonight, but since you're fresh into it...

M.Doerner

I would rather get on with finally writing my quickfix.

Currently, I am adding the missing tests for the inspection.

Mathieu Guindon

I'm fine with that :)

M.Doerner

21:57

Hm, testing whether the MissingAttributeInspection works for Exposed and PredeclaredIdis probably pointless, but I will do it for the sake of completeness.

Btw, do we use the IgnoreModule annotation to ignore something everywhere in a module?

Mathieu Guindon

that should be the case, yes

M.Doerner

Then we need a new annotation to ignore stuff for modules.

Mathieu Guindon

IIRC the attribute/annotation inspections have a [CannotAnnotate] attribute though

M.Doerner

That makes sense.

If there is any inspection targeting both modules and members, we will run into a problem.

Mathieu Guindon

that would be IdentifierNotUsedInspection, which luckily is just a .resx resource key that's shared among all "[Thing]NotUsed" inspections :)

Mathieu Guindon

22:17

TTFGH

Hosch250

22:57

I'm wearing the duck hat :)

IvenBach

23:16

Stuck at a painting activity... made the best of it and painted a Rubberduck. Whatever you do, do it with confidence. I’m owning it!

M.Doerner

23:58

How do I properly add a new entry to the quickfix resources?

I added it via the ResXManager, but the designer does not want to update. So, I cannot reference it. Or am I doing something wrong?

Transcript for