VBA Rubberducking

this

5:00 PM

one place implies it cames from Dell factory install, too.

Whether you should believe any of what you read.....

grain of salt not included

KySoto

@Hosch250 lol

i honestly dont know why its installed

or where it came from

or what it does

this

TBH, this feels insane:

#if defined (__BORLANDC__)
#define  _IMPORT __declspec( dllimport )
#define  _CONVENTION __stdcall
#elif defined (_MSC_VER)
#define  _IMPORT _declspec( dllimport )
#define  _CONVENTION _cdecl
#endif

"let's change calling conventions based on which compiler we choose!"

KySoto

uhh

wat?

O_o

yeah i dont see the advantage to that.

Mathieu Guindon

5:19 PM

@this wtaf

FreeMan

@this not sure I want to know where that came from...

this

@FreeMan you asked, I deliver!

FreeMan

yeesh...

this

I wonder what the API authors were thinking when they wrote that header

Mathieu Guindon

~~thinking~~ smoking

FreeMan

5:25 PM

hey, I know, let's confuse the heck out of our users!

this

^^ and ^

KySoto

how funny

the guy actually posted the important part on SO and left it out on reddit

M.Doerner

@Duga Can somebody explain to me which edge case justifies the use of a call statement?

this

Not sure if you saw the linked thread? github.com/rubberduck-vba/Rubberduck/issues/1877

M.Doerner

5:45 PM

I think that is a problem of the quickfix, not of the inspection.

this

but will QF have that info available?

M.Doerner

Why not just replace the statement separator with a newline in this case?

Mathieu Guindon

that would be sensible

M.Doerner

It should get the context.

Mathieu Guindon

but, we would be (correctly) parsing Foo: Foo as line-label; statement-separator; callstmt, no?

@ticker "I've been developing a workbook to launch files and applications, as an alternative to the desktop icons and Start Menu" -- wut

FreeMan

5:54 PM

@this OASIS-SVN has a 32- and 64-bit option. Do I need to match Windows or Office bitness?

or does it matter & just pick 64 because #BiggerIsBetter™

Hosch250

@FreeMan I'd say to match Office bitness.

@MathieuGuindon Wat.

FreeMan

Both office & win are 64-bit so that prolly makes it a moot point...

Hosch250

Can you even easily get x86 Windows anymore?

Used to be an option, but I've not seen it lately.

FreeMan

probably not. not much point in it, I'd think.

There used to be some "good" reasons to stick with 32-bit office, but we're on 64-bit here, so there's that...

from the OASIS-SVN readme file:

Shortcuts
================================================================
STRG+A - markiert alle Objekte auf allen aktiven Seiten
STRG+L - markiert alle Objekte der aktuellen Seite
STRG+U - de-selektiert alle markierten Objekte
STRG+M - kehrt die aktuelle Markierung um
STRG+N - kehrt die aktuelle Markierung auf der aktuellen Seite um
Im Importdialog:
STRG+S - speichert die aktuelle Auswahl zur Verwendung beim Auto-Build
STRG+W - lädt eine gespeicherte Auto-Build-Auswahl
STRG+X - löscht eine gespeicherte Auto-Build-Auswahl

At least I know those are "shortcuts".

They need to extend their i18n to the readme file - way too many fixed strings, not enough resx keys...

hopes he got terms right...

Hosch250

Shortcuts
================================================================
CTRL+A - selects all objects on all active pages
CTRL+L - selects all objects on the current page
CTRL+U - de-selects all selected objects
CTRL+M - reverses the current marker
CTRL+N - reverses the current marker on the current page
In the import dialog:
CTRL+S - saves the current selection for use in auto-build
CTRL+W - loads a saved auto-build selection
CTRL+X - deletes a saved auto-build selection

What in the world did people do before online translators were a thing?

FreeMan

6:02 PM

<-- thanks @Hosch250 for google translating for him...

;)

Hosch250

Bing.

Well, actually, I guess it wasn't needed as much, since not anyone could just post something.

FreeMan

kleenex/tissue, whatever...

Hosch250

@FreeMan I don't endorse Google products by referring to search engines by Googling.

FreeMan

lol/serious

Hosch250

IMO, any product/service that becomes a synonym for the whole industry needs to be trust-busted.

FreeMan

6:05 PM

I've converted to duck-duck-go ing for my searches. Not as easy to say.

Hosch250

I did too, for a while, but I didn't get as good results from them (or straight-up Google).

I mostly use SO and MSDN, and I find Bing works better than Google for them.

FreeMan

so long as it finds SO answers for my programming questions, I'll probably be OK.

Hosch250

Or as good, in the case of SO.

KySoto

6:34 PM

@MathieuGuindon you do the rubber duck account on reddit right?

reddit.com/r/vba/comments/cevyac/…

Mathieu Guindon

yeah?

@KySoto commented

IvenBach

My switch to using bing hasn’t affected my ability to research and find what I need.

Findin VBA docs is actually better now.

FreeMan

@KySoto you having any issues with OASIS-SVN losing its settings, or have you not gotten that far yet?

It keeps popping up in German. Enough times that I know exactly what Settings page to go to so I can change it back to English

Mathieu Guindon

@KySoto I hate getting a .xlsm with 50 worksheet modules and some have code, some don't, and you gotta hunt down where the code is. RD's CE is priceless, just for that.

KySoto

@FreeMan i got to the installed the demo and every single time i opened access id get that one error i linked to @this

FreeMan

6:44 PM

I wondered...

KySoto

@MathieuGuindon makes me glad i dont do excel xD

2 hours ago, by KySoto

oops wrong one
There we go.

this said he was going to report the error for me

this

already did

KySoto

there you go, also, thanks.

QHarr

\o

quick question....

when you see late bound such as the following:

GetObject("new:{D5E8041D-920F-45e9-B8FB-B1DEB82C6E5E}")

what is the correct technical term for the identifier:
GetObject("new:{D5E8041D-920F-45e9-B8FB-B1DEB82C6E5E

this

CLSID

that's what teh GUID is

QHarr

6:51 PM

thank you!

this

ProgID always maps to a CLSID

QHarr

are they listed anywhere?

this

but in the case of MSForms.DataObject, there is no ProgID

yeah, they're all in registry. :)

I think there's a wiki....

github.com/rubberduck-vba/Rubberduck/wiki/COM-Registration

QHarr

ah.... how does one know where to look in the registry?

@this thank you

Hosch250

HOLY CRAP.

I just created a new file, and VS crashed HARD.

I did New File -> MyFile.ts -> Create.

this

6:53 PM

there's also a link to the Larry's blog which I found a great source

Hosch250

VS just went down so fast it was weird.

You know how it usually tries to recover?

this

@Hosch250 MyFile.ts there's yer problem.

@Hosch250 this seems to be a new thing - Office does that, too

QHarr

Can one track the CLSID back from the reference you add in via tools > references ?

Hosch250

It didn't. It went down faster than ALT-F4.

It closed as fast as calc.exe.

this

@QHarr Reference.GUID, IIRC.

QHarr

6:55 PM

Oh... in the VBE you can type that?

Mathieu Guindon

via VBIDE API, yes

this

sure. stuff like Application.VBE.References(1).GUID

Mathieu Guindon

@QHarr in the Windows Registry :)

QHarr

Aha...

@MathieuGuindon Doh

Okay.... me go play....

this

probably need to uncheck OMGWTFBBQ ALLOW INSECURE ACCESS YOU BE INSANE MAN setting, though.

Mathieu Guindon

6:56 PM

(hence why I laugh my brains out at any blog that claims late-binding makes things work even when the library isn't installed on the machine running the code)

this

WTF?

they have that content?

O_o

Look, if you wrap your VCR's plug in a piece of foil, you don't even need to plug it in!

Mathieu Guindon

I swear I read it somewhere - it's what prompted me to write my article on late binding

this

if you ever find the link, share.

that needs to be named'n'shamed. hard

Mathieu Guindon

lol

this

i mean, c'mon. Just runt he code.

YOu'll get a runtime error in no time flat

it ain't magical, kids!

Mathieu Guindon

6:59 PM

truth is, I gave them the benefit of the doubt - arguably what they really meant was that you could fail graciously instead of outright failing to compile

this

Yes, that would be a good reason.

Mathieu Guindon

but between that and "works", I agree there's quite a margin

this

but I'd hope you at least have error handling around that block of code

KySoto

it would be neat if you could trap a reference missing error

Mathieu Guindon

anything involving CreateObject should have proper error handling

this

7:01 PM

which is why I mainly latebind.

s/b should must

Mathieu Guindon

@KySoto you do.. or rather, the compiler does

early binding, by definition, binds the types at compile time

KySoto

yeah, except when you are running the access runtime

then its just goes, runtime error, bai

Mathieu Guindon

?

this

@MathieuGuindon Unfortunately,that doesn't help if you're distributing the application.

KySoto

doesnt say why it failed at that point

this

7:02 PM

@KySoto runtime is not relevant.

Mathieu Guindon

@this assuming an org that has all workstations running the same OS and the same Office install, it shouldn't make any difference

this

It would manifest just the same on an full version

Mathieu Guindon

problems start when you have half the sales team on a Mac

KySoto

@this true, it would

Mathieu Guindon

then half the rest of the office on Win7, and the other half on XP Win10

this

7:03 PM

@MathieuGuindon ooo, lucky you. You are so lucky to work at a sane org that has an uniform environment! Truly, you live a blessed life.

KySoto

but that assumes its not just a configuration error on that particular client

Mathieu Guindon

@this I don't. but I run Win7 and up until recently was the only workstation left with Office 2010

KySoto

somehow the barcode label software didnt get installed, or it borked itself despite the fact it was included in the image

this

@KySoto but see, those classes of error should be trapped. In case of references, that is easily done with late binding.

Mathieu Guindon

if the VBA dev is the one behind everyone else, there's no problem

KySoto

7:04 PM

@this except when you cant late bind because you have need to trap events

this

That's usually the case, yes but that isn't a hard guarantee, unfortunately.

Events from where?

Mathieu Guindon

meh. if it doesn't work, email helpdesk and leave me alone.

KySoto

also have an email client we use

but yeah the two big things we cant late bind are the barcode controls

and the email client, because i hook into the email failed event and log it

this

In those cases, you must distribute an installer

you've left the realm of xcopy deployment.

KySoto

hence the reason i said, configuration failure

this

7:06 PM

email client = Outlook?

KySoto

no, vbsendmail

im half tempted to go and set up a powershell script or something and use the .net client for it all

this

uh this?

KySoto

yep

this

No, just get Wayne's vbMAPI. Poof, no more reference problems.

KySoto

it was one of those things that my boss introduced into the environment

this

7:07 PM

wait - that works if you want to use MAPI rather than SMTP

KySoto

and its one of those , it works so keep usin it

actually... thinking about it, it was probably a space issue

we have thin clients

i dont think there was enough space to install outlook on them

use a small dll, and get your emailing done, or deal with the huge install of outlook

i mean, its not THAT big, but i wanna say the earlier thin clients had 16-30 gigs of space

idk

Mathieu Guindon

7:40 PM

@KySoto I hate reddit. I can't help replying to everyone and I feel like I'm hijacking every thread I jump into.

and then I spend the rest of the day watching my karma points go up and down

(i.e. I kind of like it too much)

Whatever is wrong with this, it looks like the wrong way to do whatever it is you're doing. — Tim Williams 16 secs ago

so. much. this.

FreeMan

8:14 PM

In versions of Excel after 2007, the limit for nested IF statements was increased from 7 to 64. You've hit the 64-deep limit, so you're done. That said, please give us more info so we can help you find a much better way of doing this (as this method is... awkward... at best). — FreeMan 7 secs ago

Hosch250

@FreeMan Shame. They should've left it at 7.

this

^

I wonder what justifications they used to bump from 7 to 64

Mathieu Guindon

@Hosch250 yup

@this "because we can"

and they didn't stop and ask themselves whether they should

this

IvenBach

"The Little Engine That Could Have, But Didn't Because It Knew Better" Doesn't have the same feel to it.

3

> Refactoring is a natural part of maintaining software over time.

Hosch250

8:29 PM

It also doesn't have the same motivation to encourage kids to push ahead over obstacles.

this

there are parodies like "The little engine that couldn't"

Hosch250

@this I like how the town is build perpendicular to the hill.

this

didn't find any for "shouldn't", though.

@Hosch250 must be inhabited by slanted people, I guess?

Hosch250

Well, the kids are vertical...

IvenBach

Ermagawd that's a mindf*(k as an adult... How have I never noticed that before?

this

8:32 PM

@IvenBach you could say it's just camera at a dutch angle

Hosch250

It also detracts from the story.

this

i mean, train going downhill doesn't feel like an accomplishment, you know?

^^

Hosch250

What engine can't go downhill?

this

one that's rusted so badly that it's one big block of rust?

Hosch250

Well, sure.

IvenBach

8:50 PM

#TIL en.wikipedia.org/wiki/Dutch_angle

The things I've learned at this pond astound me.

Mathieu Guindon

@FreeMan saved

IvenBach

@FreeMan I wish I could unsee that.

Mathieu Guindon

@IvenBach prepare for an earthquake in CA when OP proceeds to facepalm upon reading my answer

IvenBach

9:07 PM

For the love of all that is feathered, yellow, and fowl. Please take that individual away from Excel. PEBCAK for sure.

After seeing that I need to take a walk and #Breathe.

Andrzej O

9:20 PM

its beautiful and genius in a way, instead of looking for smartet/ simpler way to do do stuff let's repeat n times one think. For a moment i thought that i see endlessly looped debug print with error dump...

Duga

[rubberduck-vba/Rubberduck] Vogel612 created comment on issue #5057: ObsoleteCallStatment inspection needs an overhaul

> this should check the corresponding endOfStatement for being a COLON instead of working off line positions

[rubberduck-vba/Rubberduck] Vogel612 added label difficulty-01-duckling to issue #5057: ObsoleteCallStatment inspection needs an overhaul

[rubberduck-vba/Rubberduck] Vogel612 added label performance to issue #5057: ObsoleteCallStatment inspection needs an overhaul

[rubberduck-vba/Rubberduck] retailcoder created comment on issue #5057: ObsoleteCallStatment inspection needs an overhaul

> @Vogel612 in the listener - not the inspection itself, right?

Vogel612

9:36 PM

yes, that's exactly what I meant.

though it shouldn't make that much of a difference where we check, because the Listener collects a reference to the context anyways.

KySoto

9:56 PM

guys... reddit.com/r/sysadmin/comments/cetyaf/…

@MathieuGuindon i feel ya.

Mathieu Guindon

10:54 PM

@Vogel612 yeah, but the inspection gets much simpler when it simply iterates the contexts and spawns a result for each (not ignored) one =)

IvenBach

11:23 PM

0

Q: KeyBinding works as UserControl but not when pusing property element syntax in XAML

As title sates I can't get KeyBinding to work when using property element syntax. I've followed the InputBinding Class example from the documentation and can only get KeyBinding to work when using a UserControl and would like to understand why that is, and if possible what I'm doing wrong. Belo...

I feel like it's something so blatant too.

IvenBach

11:36 PM

@IvenBach Yes. Yes it is... The position of DataContext = this being before InitializeComponent();. Time to update the question.

Transcript for