VBA Rubberducking

7:20 PM

@mansellan except that the level and fulcrum will be quite stressed

mansellan

so, our link to the data centre where we host all our test environments has been down all day (no backup, which is why it doesn't yet host production), so no actual work could be done. Spent my whole day extending the Core 3 configuration system to encompass our company requirements. It's been blissful

Hoping it stays down all week!

@FreeMan then it's either 0 or 1 :)

@MathieuGuindon within T-SQL at least.

So... I just tried to :check inspections: in one of the oldest VBA powerpoint macro at our company :-)

One module - 3500 lines. Why not.

@SonGokussj4 but at least it runs, right?!

7:31 PM

You mean RD or the script.

Because RD is having heavy difficulties :D

assuming it's that old and is still in use, the script

Yeah. It's still updated. The script started in, like, year 2002

hoping the "?!" implied some bit of sarcasm

because of the requirements to newest addition, it's still updated regularry :-)

*regullary

copy

7:32 PM

but... why in PPT?

i mean you can't use it for making actual presentation?

right?

Because it's creating presentation.

Like 80-pages long presentation with all the colors and calculations and... I don't know. In the gui, there are a LOT of options and through the years many "source data" have changed but it has to be backward compatible...

here's the thing. Access or even Excel makes much better application front-end for generating presentations.

so you load all of the data source locations and it does the harder-part of manipulating them into the desired slides?

O.O why though?

@Cyril Not spreadsheet. Slides.

for Access, because it's actually designed to create applications?

7:35 PM

i just edited to change that! lol

e.g. you get your purty forms

sorry, my head is stuck in the realm of context menus and trying to not write an addin

Vogel612

@SonGokussj4 yea, 5k inspection results can kinda do that ...

[rubberduck-vba/Rubberduck] MDoerner added label bug to issue #5201: Is there a way to declare Jagged arrays so they don't trigger the "Indexed unbound default member access" inspection?

[rubberduck-vba/Rubberduck] MDoerner assigned MDoerner to issue #5201: Is there a way to declare Jagged arrays so they don't trigger the "Indexed unbound default member access" inspection?

well, try to go to your boss and say "hey, I want to recode this 17 years-still-working-updating application into something nice"

"Yeah! Why not! How long would it take?"

"about 4 months?"

"GO do your CURRENT job..."

7:37 PM

not sure it necessarily requires 4 months

i bet you could copy'n'paste the code over and find'n'replace some of the references

so more like a day or two of work to put it in Access or Excel.

Ah, well. Water under the bridge.

i would say that it depends on your boss... i took a year to update/redo a spreadsheet started in 2003, which was on the side of my primary function

had the general manager behind me so had top-down support

It is just that PowerPoint isn't a thing you'd use to build applications with.

@this For someone that haven't done --anything-- in Access ever? I don't even know what's the difference between Excel/Word/Access/PowerPoint VBA...

(arguably nor is Excel)

That's the point. There aren't much.

@Cyril Noice.

7:39 PM

You still can run the same code from Access or Excel to build PPT slides

Interesting. And Access is why better to create PPT slides than PPT?

the only caveat is that if it's macro-recorded or doesn't fully qualify references, it might need adjustment to make the references explicit

Because it's a RAD tool meant to build applications? With forms & everything? Ability to lock down the environment so they can't mess with design stuff?

^^ Excel.Range and Word.Range are two very different things.

@this and because access requires additional licensing, i would choose excel as the better option, while they both perform damn near identically in this aspect

The man behind this is coding in VBA (not complicated stuff) for 20 years once per week.

@this Hah.... Maybe I will google a little tomorrow at work..

7:41 PM

@Cyril AIUI, that argument is somehow less of an issue as most of O365 licensing now come with Access

@this i wish mine did...

But even if they cheaped out, technically you only need one seat for the developer / maintainer, and everyone use the redistributable runtime

That's what we usually recommend to companies who are in same boat as you are

Access requires additional licensing? That's news for me. (we don't have 365)

It depends on which Office you get

if you got the basic version, it probably doesn't

Okay.

7:43 PM

if you got the business / professional / whatever the term Microsoft's using, it has Access.

We're company with 400 people so I don't think we have the basic one.

[rubberduck-vba/Rubberduck] retailcoder created comment on issue #5201: Is there a way to declare Jagged arrays so they don't trigger the "Indexed unbound default member access" inspection?

> Sounds like a little oversight - basically array subscripts and function calls are grammatically identical in VBA, so the resolver needs to look at what's being indexed *and whether that's declared as an array*, and then we should be good.

Note that if a jagged array is just a `Variant`, I doubt we'll be able to prevent firing this result.

(@MDoerner feel free to contradict me)

---

Things may get hairy though, for arrays may be holding objects... which may have an indexed default m

Used to be that Home & Student version from few years ago did not include it but IINM, it now does with basic O365

i've got business/enterprise 365 with no Access. i haven't seen Access as part of the generic Office platform since 2010

weird

O.O

I will check that out tomorrow.

7:44 PM

could it be that they excluded it from the installation image?

Some IT dept think that installing Access will herald the Armageddon while happily ignoring all the security leaks in bajillion Excel spreadsheets floating around.

@this i would say doubtful as i've asked numerous times abotu getting Access access so i can work with databases and they won't buy licenses outsdie of a specific group for this company

and that group... Infrastructure

Interesting.

Are they on VL?

VL meaning?

volume licensing

i believe that is the case

7:47 PM

may be that they negotiated a deal to save bucks by excluding Access

would make sense. as a standalone that's like $280/person/year

dang, now I need to check if my Office 2019 ProPlus install installed Access

which is also a bit too much considering that more likely you only have one or two guys developing/maintaining while everyone else are merely just using it

writing to an SQLite database with excel really, really hurts me... i just want Access so it's one language lol

so buying only one seat for full license and distributing runtime would be much more effective.

TBH, I do really wish they'd kind of merge Access and Excel.

7:50 PM

[rubberduck-vba/Rubberduck] MDoerner created comment on issue #5201: Is there a way to declare Jagged arrays so they don't trigger the "Indexed unbound default member access" inspection?

> Sorry, this is actually a resolver bug. I overlooked the possibility that a double index access can be an array access both times, if the element type is `Variant`.

I will change the resolver to not consider index accesses on variables of type `Variant` to be default member accesses.

The inspection results should then vanish automatically.

(not sure merge is the best word)

@this so that Excel becomes an actual database?

but the point being, Excel is great for what-if, charts, data analysis whereas Access has all the GUI stuff you need to build an application.

i have always treated those very differently, and mat just hit on why... lol

LIke I said, "merge" wasn't the right word.

7:51 PM

[rubberduck-vba/Rubberduck] MDoerner added label resolver to issue #5201: Is there a way to declare Jagged arrays so they don't trigger the "Indexed unbound default member access" inspection?

i missed you saying that after Duga's post. sorry

I'm primarily annoyed with the fact that Microsoft keeps insisting on re-inventing its own wheels when it comes to data linking / importing / exporting.

Both Excel and Access has several overlaps in that area

and it's not 100%, which makes it doubly annoying.

Lke you said, there should be just one tool/language

and I'd rather Access use Excel as a charting engine, etc.

@this you know, I'd get on board with that, if they dropped the whole "database engine" part of Access and made it all run off SQL Server (lite or whatever)

IOW kill Access-SQL

IKR?

You'd thunk they'd put forward SSCE as the logical successor

Oops, we are deprecating it! mwahahahaha

lol

7:53 PM

Microsoft is its own worst enemy

but they keep making money off it, so why change?

you mean to tell me they make money off making users suffering?!? :-o

the one language would be amazing though... make excel access dependent so, like this said, charts/etc. would display there

The funny thing is that in recent version, Access got a new update of its charting engine which is based on the same engine that Excel uses.... with some differences.

@this elle oh elle. if only i could find the shpeal (sp?) about how IT groups make things more difficult to ensure they have jobs

alright, time to sink into context menus again... powerquery just isn't being as accessible as i need it to be. have a good evening folks

8:36 PM

BTW, @Cyril, did you take your bear picture?

@Hosch250 i found it online years ago... dont' remember where i found it

OK.

does he look familiar?

[rubberduck-vba/Rubberduck] Senipah created comment on issue #5201: Is there a way to declare Jagged arrays so they don't trigger the "Indexed unbound default member access" inspection?

> Thanks @MDoerner !

@Cyril No, just wondered if you'd snapped the picture.

FreeMan

8:50 PM

@Cyril Smokey? Is that you??

LOL, the pictures of smokey carrying fawns with a fire in the background make me laugh. Because that's some of bears favorite food.

Fauns?

Wouldn't do Smokey much good to have overcooked meats, no?

Pretty sure fawns ≠ fauns.

@IvenBach Deer babies, not fauns...

Ignorance. #Words. Mine. Show.

8:56 PM

Hmm gets me wondering, though-

If you killed a faun, do you get charged with half a murder?

@MathieuGuindon @Duga The problem is not the first array access, but the second. This is always an array access on a Variant for a jagged array.

I'd think you wouldn't get charged with any murder, since they aren't really human.

Just because something looks human doesn't mean it is.

OTOH, if they were an endangered species....

Well, it's not just looking, though. The common description is "half-man, half goat".

and they have lot of human qualities like speech and intelligence.

@this Hmmm. I imagine the intersection would be interesting biologically.

I guess it comes down to whether you want to treat humanity as a discrete unit or indiscrete unit.

8:59 PM

The reproduction, too...

Huh.

Greeks were kind of crazy.

If someone married a faun, could they be charged with bestiality?

Oooo, yeah.

@this Yeah, they were. Most of their gods were porn stars and whores.

^

9:02 PM

^^^^ I'm glad we don't have to worry about that.

I should start identifying as one just to screw people over.

Isn't the Greek family tree as twisted and in-bred as the comic heros?

IDK. I'm given to understand that it's more appalling than what you'd see in the comic books.

You know Aesop's Fable? Cute little fables to read to kids, right? Convenient that they left out several other fables that involves rape or bestiality or whatnots.

Comics have censors to get past. Don't think the Greeks had that.

Not sure censorship was even a thing.

well, there's Socrates, so...

9:12 PM

We've got a couple guests spying on our room, LOL.

What a conversation to walk into.

@user626610 Welcome to the war pond.

BTW, guys, you probably can't talk unless you have 15 rep on any .stackexchange domain site.

A mod can give you write access.

@Vogel612 you there to wave your ModWand for chat permissions?

@user11378204 I'll welcome you, since Iven didn't :D

Funny thing, most people we enable privs for never even chat.

:blush: I looked in the top right and only saw 626610.

@IvenBach Zues and Hera were Brother-Sister Husband-Wife. That's bad enough right there.

9:15 PM

[rubberduck-vba/Rubberduck] bclothier created comment on pull request #5196: Suspend Parser for RenameRefactoring of Modules and Projects

> @BZngr -- some background info:

The main reason it's set to `-1` is because when I wrote the suspension logic, we didn't know yet if there might be a case where suspension might cause the host to lock up. So far, it hasn't been reported, but since it was trivial to provide the timeout, I included it but used infinite timeout as the default since we anticipate that all suspensions would be short in duration (meaning milliseconds) and there should be safeguards in place to prevent it from loc

@IvenBach Well, so were Adam and Eve's children, although that was portrayed as being out of necessity.

And Adam and Eve were even closer.

More like siamese twins.

> Daaayyuuuum rib you be looking pretty fine! I'll make you my wife.

Slim pickings when there is no option.

LOL. Normal people just eat their ribs...

I'ma just walk away from that one.

:D

@IvenBach There's another food joke here too.

Possibly a rich/poor one too, LOL.

Something about you must be rich if you think ribs are slim pickings...

It's not coming to me.

9:24 PM

@Hosch250 Wasn't it Lot's daughters that wanted their father to have a son?

Yes.

Tradition has it they thought they were the only people alive, and it was up to them to keep the human race going.

Which is why they weren't punished more harshly.

Actually I understand that this is a case of reporting, not espousing.

Reminds me of en.wikipedia.org/wiki/Home_(The_X-Files).

The daughters made their father drunk under the belief that they were the only people left (Sodom and Gomorrah having been destroyed) when that was not the case.

In Christianity, it is taught as that.

Judaism, from what I've read, teaches that they were rather rewarded for following the command to reproduce.

9:28 PM

Interesting. Didn't know that.

Seems backward, though.

That's a questionnaire box that should never be checked.

Back to dev work.

9:51 PM

@M.Doerner yeah, we have no way of knowing that the second (1) in arrayOfCollections(1)(1) is accessing a Collection object's Item property, or that arrayOfArrays(1)(1) is accessing subscript 1 of the inner jagged array at index 1

ttgh

Q: Excel Import Data from Different Workbook Dynamic Headers

10:04 PM

Oh, come on. Why does not resolving indexed expressions on Variant variables as default member accesses break the AssignmentNotUsedInspection?

There is not even a reference for the assignment.

Quack Exchange

0

I have this code below that copies data into a master workbook, in sheets "Inputs1", by matching the column headers from the master workbook with the source workbook. If a column header matches, it will copy and paste that column to the related column in the master workbook. The macro works grea...

Ah, I see.

I cannot read. That is the problem.

Missed an !.

10:34 PM

[rubberduck-vba/Rubberduck] bclothier created comment on pull request #5182: Replace #if DEBUG with conditional methods

Hm, still failing.

> Due to a reading comprehension failure, multiple `Conditional` attributes are not `AND`'d but rather `OR`'d. Consequently, this:

```
[Conditional("DEBUG")]
[Conditional("SOME_OTHER_FLAG")]
```

will not work the way we want it. For now, I'm going to remove the `DEBUG` flag and leave in the other flag, which is more unlikely that it'll be set, which ensures that it won't be enabled by mistake when running a debug build.

The downside is that if the flag is left on the release build b

10:52 PM

I am so glad we have base project files. Flags would be a PITA otherwise.

11:16 PM

[rubberduck-vba/Rubberduck] MDoerner synchronized pull request #5167: Suspicious Let assignment inspection

[rubberduck-vba/Rubberduck] MDoerner edited pull request #5167: Suspicious Let assignment inspection

[rubberduck-vba/Rubberduck] MDoerner removed label PR-Status: Conflicting from pull request #5167: Suspicious Let assignment inspection

11:30 PM

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

11:42 PM

Did I mention I'm looking into possibly buying a horse?

I was having trouble finding a place to keep her, but now I found one, and I need to decide.