VBA Rubberducking

Duga

00:01

RELOAD!

[bruglesco/memory-card] 1 commit. 60 additions. 52 deletions.

[Cardshifter/HTML-Client] 6 commits. 223 additions. 22 deletions.

[rubberduck-vba/Rubberduck] 5 commits. 1 opened issue. 1 closed issue. 2 issue comments. 138 additions. 38 deletions.

Duga

01:12

[rubberduck-vba/Rubberduck] bclothier added label technical-debt to pull request #3975: Reflection API & COM management

[rubberduck-vba/Rubberduck] bclothier added label PR-Status: Review Requested to pull request #3975: Reflection API & COM management

[rubberduck-vba/Rubberduck] bclothier created pull request #3975: Reflection API & COM management to merge bclothier/Rubberduck/techdebt into rubberduck-vba/Rubberduck/next

> This technically is 2 PRs in one and it's turning out to be bigger than I really want it to be. So to help things, I'm putting it up the WIP for reviews by other. The PR started out as COM cleanup but as I cleaned up, I found that there were many leaking GUIDs, more than what I anticipated, and many COM classes, both in the API and in the Main/Core did not completely follow the proposed guideline set by @comintern in #2903. So to that end, we have 2 major parts: COM Cleanup 1. We move...

some stuff around, as per discussion in #3862. We introduce a new project, Rubberduck.SharedResources which now houses the GUIDs and ProgIDs. 2. We also move over the RootComWrapperFactory to the Main. 3. Since the previous changes to the installer disabled the API project, we need to enable it again, so we had to update the Rubberduck.Deployment to handle multiple COM assembly registration. 4. Enforce consistent code standard for COM management Rubberduck Code Analyzer As per the...

point iv above, we are seeing too many opportunities for subtle bugs relating to COM management to slip by in the PR. To that end, it seems prudent that Rubberduck solution be able to follow a standard. Instead of hoping that all contributors will diligently read a lengthy wiki article and remember to follow the guideline at all times -- and being human, even a long term contributor can easily overlook a little thing, we will make use of Roslyn Code Analyzer project, Rubberduck.CodeAnalysis...

which provides us with a place to define our domain-specific rules that we wish to enforce on all of the Rubberduck's subprojects to ensure they all follow the guidelines. This is only a start, however. At the present the analyzer will inspect: 1) whether a type is COM-visible and if so.... 2) verify that it has a Guid attribute that references a constant defined in RubberduckGuid 3) and if it's a class type then.... a) verify that it has a ClassInterface attribute that is set to...

ClassInterfaceType.None b) verify that it has a ProgId attribute that references a constant defined in RubberduckProgId c) verify that it has a ComDefaultInterface attribute present and it is using typeof (e.g. not a string) 5) or if it's an interface type then... a) verify that it has a InterfaceType attribute that should be either InterfaceIsDual (recommended) or InterfaceIsIDispatch (usually for event interfaces only) TODO: 1) test the installer more thoroughly 2) fix the...

event setup for the ParserState. It need to be redone completely. 3) Make ParserState non-Newable - it shouldn't be constructable by VBA code. It's best if we force it via a factory method provided on our side. 4) Similarly, check if we can prevent creation of hidden members (ref #2559) by making constructors internal

[rubberduck-vba/Rubberduck] bclothier added label PR-Status: WIP to pull request #3975: Reflection API & COM management

[rubberduck-vba/Rubberduck] bclothier edited pull request #3975: Reflection API & COM management

Mathieu Guindon

this is glorious

Duga

[rubberduck-vba/Rubberduck] build for commit cddadde8 on unknown branch: AppVeyor build failed

BUILD FAILURE!

Mathieu Guindon

*will be

:)

this

C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\Bin\Microsoft.Common.CurrentVersion.targets(1603,5): error : Project 'C:\projects\rubberduck\RubberduckCodeAnalysis\RubberduckCodeAnalysis\RubberduckCodeAnalysis.csproj' targets 'netstandard1.3'. It cannot be referenced by a project that targets '.NETFramework,Version=v4.5'. [C:\projects\rubberduck\Rubberduck.SharedResources\Rubberduck.SharedResources.csproj]
Command exited with code 1

I think AppVeyor's a filthy liar. I can build it locally.

But GTK, though - that means some more research is needed to make it work anywhere.

May not be few days before I get to that, though. Hopefully there'll be enough comments/feedback on this PR since I moved a lot of stuff and I know nobody wants to review 100000 files changed PR. ;)

Tweeting Duck

02:57

#DidYouKnow Rubberduck's Code Explorer "copy to clipboard" button writes all user declarations to the clipboard, and you can then paste them as HTML, XML, or CSV. #VBA #OSS #Tools

Tweeted by rubberduckvba on April 30, 2018 at 2:42 AM

Tweeted by rubberduckvba on April 30, 2018 at 2:44 AM in reply to rubberduckvba

Updated page on RD News: "Using Rubberduck"

Tweeted by rubberduckvba on April 30, 2018 at 2:57 AM

Tweeting Duck

04:08

Updated: "Using Rubberduck" https://rubberduckvba.wordpress.com/using-rubberduck/

Tweeted by rubberduckvba on April 30, 2018 at 2:59 AM

New page: "the Rubberduck command bar" https://rubberduckvba.wordpress.com/using-rubberduck/the-rubberduck-commandbar-context-menu/

Tweeted by rubberduckvba on April 30, 2018 at 3:00 AM

New page: "the Code Explorer" https://rubberduckvba.wordpress.com/using-rubberduck/code-explorer/

Tweeted by rubberduckvba on April 30, 2018 at 3:00 AM

oops, that one's still WIP

Tweeted by rubberduckvba on April 30, 2018 at 3:00 AM in reply to rubberduckvba

Mathieu Guindon

05:39

@this hadn't relized your PR was also introducing the resources project... see if you can merge this branch into it... I got all the icons and .resx files moved to Rubberduck.Resources here, but overlap/conflict with your work... my bad - LMK if you got the resources down too, I'll discard that branch then

bedtime

QHarr

09:26

Anyone home?

Inarion

Nope - I'm at work.

;)

QHarr

lol

I will re-phrase! Anyone on here and know anything about vba/typeahead.js ?

this

@MathieuGuindon heh. TBH I did not want to address this in the PR since I wanted this to be its own PR but that's another case where I managed to painted myself into a corner. :\ My version only moves only the Guid/ProgId but I did not move any other resources into the new project. BTW, I did try to use Resources originally but found that this creates problems in various classes which already has a class Resources so I decided on SharedResources to avoid the conflicts....

....If you still want, I can merge but as stated, that'd make the PR even more bigger and we know how much fun it is to review a big PR.

@QHarr haven't used typeahead.js - what does it have to do w/ VBA, thou?

QHarr

09:43

I am answering an SO webscraping question and whilst I can do what appears to be all the required steps I am not getting the expected result. And I think it is because when I do currPage.getElementById("ctl00_ContentPlaceHolder1_suche_bezirk").Value = "10777 Berlin/Schöneberg"

Although the value appears in the typeahead box I don't think it is retained when the submit button is pressed

If I copy paste the entry and then select the corresponding item from the drop down that appears then all is fine.

this

still not understanding what it has to do w/ VBA; nor why one needs a "typeahead.js" to scrape.

QHarr

This website pflegelotse.de/(S(emrwr4o1bnpqqdsqigfbepc2))/presentation/… has a box for where to search (Wo möchten Sie suchen?)

It's classname is typeahead tt-input

Some basic googling suggests this is a typeahead box

I guess it queries server side to return suggested items

this

so, to see - you want to automate this?

by basically injecting text into this so that you can scrape the result somehow?

QHarr

Yes. I have done all the other steps including entering data into this box but I dont think it is retained

this

I would assume that you should use something that simulates user interaction

because presumably it's reacting to the interaction

and most likely stuffing it in a hidden textbox or whatever

so simulating paste is likely your best bet, I think. I assume you're using Selenium - it should have something for that, I think.

QHarr

09:50

Yeah but Focus clear what ever is in the box and drended sendkeys hasn't worked. And yes there are 3 hidden boxes which I assumed where actually used for a query.

I am not using selenium. Just vba and the dreaded IE

I wanted to avoid selenium for this. It has become a bee in my bonnet that I wanted to solve.

I also targeted the hidden boxes and tried targeting the dropdown list. No success with the latter

I can't simulate the text entry to pull up the drop down selection box.

I think that may be key

But simulate paste.....I will need to have a play with that idea

this

were I you, I'd buckle down and do it w/ selenium

other methods are too fragile

QHarr

:sighs:

this

actually, that's not exactly accurate -- were I you, I would not even try scraping at all. I'd be phoning them and pushing for a proper API.

QHarr

:laughs:

this

I know. not all comply and they're dumb for it.

QHarr

09:56

It just frustrates me that I am 80% sure that it can be done and it is just my lack of js /asp knowledge that is the problem...

oh... and using the wrong tool for the job!

@this Many thanks. I may have to back down and try it the easier way. Sounds stupid when I say it like that. I will also look into how I simulate paste.

Quack Exchange

10:28

-1

Q: Find and Match Values Column b and Column G and Show Result in Column P

If one entry of bulk code(Column B) contains Intermediate against it in Material Type(Column G), then if that bulk code repeats again, display bulk received as YES in Column P I write following Code but it not working Sub bulk_received() Dim bulk_codes As Range Dim pack_codes As Range ...

ashleedawg

10:41

@QHarr you have to match the text from the autocomplete exactly, right before the click will fire, right?

QHarr

@ashleedawg. Welcome to the Pond. I haven't tried. So far I have been just direct writing to the box. I tried selecting the typeahead drop down without success. In theory as text is "entered" into the box, a drop down with selections should appear, then a complete match selected from the items in the drop down made and "entered".

Peter M Taylor

11:14

@ashleedawg welcoming you too in the pond. Just felt the ripple waves of sorts. :)

Mathieu Guindon

12:18

@MSExcel sad news http://www.kccremation.com/ObituaryDetails.aspx?id=23658 Charles “Chip” H. Pearson, 51, died April 19, 2018, at St. Luke’s Hospital from severe head injuries received in a car accident on April 8 in Kansas City MO. Chip was awarded Microsoft’s MVP for sixteen straight years.

Tweeted by ExcelAnalytics on April 30, 2018 at 11:53 AM in reply to ExcelAnalytics

this

@MathieuGuindon :( That sucks. His website is one of pretty comprehensive site covering VBA.

Inarion

@MathieuGuindon RIP, Chip :(

4

I certainly had more than one insightful moment reading on his site.

this

12:36

Oof....

> He is survived by his parents. His older brother Steven and younger sister Susan died earlier. A private service will be held.

Condolences to his parents, wherever they may be.

Tweeting Duck

12:49

My deepest sympathies to Mr. Pearson's family. I'm speechless, this is so sad.. https://twitter.com/ExcelAnalytics/status/990922030966026240

Tweeted by rubberduckvba on April 30, 2018 at 12:16 PM

FreeMan

As the father of 2 boys and a girl, I can't even begin to imagine their sorrow.

FreeMan

13:03

On a more positive note, this is pretty handy: idownvotedbecau.se

Duga

14:09

[rubberduck-vba/Rubberduck] retailcoder commented on pull request #3709: Czech language support

> Changes are coming up regarding organization of resources; this PR will be conflicting. Feel free to re-submit after resources are streamlined into the Rubberduck.Resources project.

[rubberduck-vba/Rubberduck] retailcoder rejected pull request #3709: Czech language support

Mathieu Guindon

@this should I PR my changes then?

this

Yeah, if you manage to have not problems w/ the Resources conflicting with whatever menu/comamnds is using, go for it.

I can then sync since I basically only move 2 files and it's not really the PR's scope -- it's supposed to clean up the COM but....

a penny in, a pound out, or however they phrase it.

Mathieu Guindon

my computer literally rebooted on me as I was pushing the commit last night.. I know the project builds but I'm not 100% sure everything is A-OK yet

I'll make the PR

this

cool

Duga

[rubberduck-vba/Rubberduck] retailcoder created pull request #3976: Introducing Rubberduck.Resources to merge retailcoder/Rubberduck/resources into rubberduck-vba/Rubberduck/next

> This will likely conflict with #3975 a bit.

ref. #3862

[rubberduck-vba/Rubberduck] retailcoder added label technical-debt to pull request #3976: Introducing Rubberduck.Resources

[rubberduck-vba/Rubberduck] retailcoder added label localization to pull request #3976: Introducing Rubberduck.Resources

this

14:19

now i'm glad I didn't merge that. 401 files... yikes!

Duga

[rubberduck-vba/Rubberduck] retailcoder added label PR-Status: WIP to pull request #3976: Introducing Rubberduck.Resources

Mathieu Guindon

@this yeah.. lots of XAML

mostly just using statements added everywhere

this

definitely was a better choice, being its own PR

yeah but when we touch that many files, it's easier to keep the scope small.

Mathieu Guindon

true

I noticed a couple of hard-coded GUIDs, didn't touch them

this

yeah, my pR will clean them up. when it's approved & merged, I'll make sure to push my changes forward, no worries.

Mathieu Guindon

14:23

public override Image Image => Resources.Resources.FindSymbol;

I don't like that Rubberduck.Resources.Resources.resx file

I'll rename it

possibly eliminate it

this

I think that's what I was seeing and why I changed to SharedResources to avoid that.

Mathieu Guindon

also I'm missing the inspection resources, they're still under Rubberduck.Parsing.Resources

this

didn't realize it was a literal resource file (I should have checked; last night i assumed it was something built-in to XAML or something like that)

Mathieu Guindon

it was under Rubberduck.Properties

and it only contains images... somewhat overlaps/duplicates the PNG icons

definitely some legacy resource file, ...probably dates all the way back to commit #1

this

i did find the images for the original InstallShield installer, so.... yeah.

Mathieu Guindon

14:26

Source="../../../../../Rubberduck/Rubberduck.Resources/Icons/Fugue/cross-script.png"

not sure I like the relative paths either

Vogel612

Are the regex-assistant resources also moved?

Mathieu Guindon

missed them as well

this

Does it really have to be?

Surely you should be able to reference via the project reference, done.

Mathieu Guindon

I did wonder whether they should move

A) centralize all resources in one place
B) keep feature-specific resources with feature-specific project

this

i mean, if C# can find the assembly without using relative path directly, surely XAML should...

Mathieu Guindon

14:29

like I said, I merely just moved stuff around, didn't do much cleanup. the inline image sources should be control resources declared at the top

I wonder if we could use Resx ResxName=Rubberduck.Resources.RubberduckUI markup extension to pull images too?

this

images is kinda of UI....

but, then again, if you could, why not just do it properly with Rubberduck.Resources.Images

Mathieu Guindon

that's kind of what Rubberduck.Resources.Resources.resx means to do

I'll give it a shot tonight, but then again I don't want to scope-creep that already-huge PR

Duga

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

Tweeting Duck

RiP Chip Pearson http://excelmatters.com/2018/04/30/rip-chip-pearson/

Tweeted by roryarchibald on April 30, 2018 at 12:41 PM

Duga

[rubberduck-vba/Rubberduck] retailcoder commented on pull request #3976: Introducing Rubberduck.Resources

> Missing Rubberduck.Parsing.Inspections resources. Also, should feature-specific resources be moved there as well? e.g. @Vogel612's Regex assistant tool?

IvenBach

15:32

@TweetingDuck Did not know about this.

Vityata

15:48

@TweetingDuck RIP :(

Hosch250

@IvenBach More details above.

3 hours ago, by Mathieu Guindon

@MSExcel sad news http://www.kccremation.com/ObituaryDetails.aspx?id=23658 Charles “Chip” H. Pearson, 51, died April 19, 2018, at St. Luke’s Hospital from severe head injuries received in a car accident on April 8 in Kansas City MO. Chip was awarded Microsoft’s MVP for sixteen straight years.

Tweeted by ExcelAnalytics on April 30, 2018 at 11:53 AM in reply to ExcelAnalytics

IvenBach

16:00

I have learned from and greatly appreciated all the information he has on his site.

Hosch250

Only thing we can do now is pass it on--and make sure the site stays up.

IvenBach

... 404 trying to access his site.

Hosch250

Already took it down?

That was fast...

@IvenBach What's the URL?

IvenBach

cpearson.com

Any and all links to it are 404.

Mathieu Guindon

half of SO's external VBA links have gone dead

Hosch250

16:03

Yep. They took it down.

They still own the domain.

IvenBach

A severe disturbance in the force has just happened. I've felt thousands of Excel users die just a little bit inside...

Hosch250

First step is to get his information. Bet we can nab it off Google's "backup" of the internet.

Second step is to re-host it.

Vogel612

check whether the waybackmachine has something

Hosch250

@Vogel612 April 8th is the last snapshot.

web.archive.org/web/20180408015807/http://www.cpearson.com/…

Vogel612

that seems pretty up-to-date

this

16:05

I don't think Chip was updating his site for a good while.

IvenBach

^

If he was they must've been very minor edits.

this

In spite of that, it was still high on your typical trawling for anything VBA.

Hosch250

The accident happened early April.

this

yeah apparently he was hospitialized for a good while but just didn't make it. :\

Hosch250

If someone can download that, I can take the next steps to getting it up and hosted, I guess.

this

16:07

that just.... sucks.

esp for his poor parents.

Hosch250

New design to emphasize it isn't him anymore, but proper citation?

Or just dump it the way it was?

this

could be sticky.

Hosch250

Yeah, especially the legal issues.

this

Were I you, I'd make a copy now but not host it until I have had a chance to talk with the next of kin.

Mathieu Guindon

@Hosch250 not without contacting the family

Hosch250

16:08

First step is to download it so it doesn't get 100% lost.

Right.

this

and I have to be willing that it might be a good while before they are willing to talk.

Hosch250

@MathieuGuindon OK.

this

Can't have strangers pounding on the door asking for a website they might not even know about.

Hosch250

But really, download it quick before it goes down if you have access to a personal machine. I'm at work.

Mathieu Guindon

@this might have been a timing coincidence, but I doubt the domain simply expired...

Hosch250

16:09

@this On the other hand, it might help them to know that it isn't just them.

@MathieuGuindon I checked. It's not expired.

IvenBach

@Hosch250 How/Where do you go to check for site expiration?

Hosch250

@IvenBach Whois.

Mathieu Guindon

so they took it down while they sort things out. let the dust settle, see what happens.

this

@Hosch250 yes, that's true - I do admit I'm a bit gunshy when approaching a total stranger - I just don't know his story, you know? I'd much rather that someone who actually knew him (and his family) be the one to make request.

Hosch250

@this If it were me, I'd email his contact on the website and hope they see it.

this

16:11

that could work.

Hosch250

Also, tweet at his account, if he has one.

Mathieu Guindon

Roger Govier just emailed the Excel DL

IvenBach

Hope he had something in a Will & Trust stating his wishes for the site.

this

^ @MathieuGuindon ^

IvenBach

I joke about the bus factor but there is truth to it.

Hosch250

16:17

@IvenBach Like the time the Google bus ran over an MS employee?

IvenBach

Ooof... Irony.

Didn't hear about that one.

Duga

[rubberduck-vba/Rubberduck] IvenBach synchronized pull request #3971: Update about control

IvenBach

@Duga @Vogel612 Got your edits.

Vogel612

nice :)

Any questions about how PRs work?

IvenBach

I'll count Monday morning as weekend.

Hosch250

16:22

@Vogel612 He's made a few before.

IvenBach

Not pulling stuff into my repo though.

Vogel612

but not received them to his repo

IvenBach

^

Hosch250

Oh, I see.

We are just finalizing teaching people about outgoing PRs now.

IvenBach

GH has it set up so even I can do it.

@Vogel612 If I have questions I'll surely ping you about them.

Vogel612

16:24

:+1:

IvenBach

I need to get back to my Ribbon modification examples. Still stoked I'm understanding the basics. Long ways to go still.

Vogel612

that's what we're here for. That said, I gotta go grab groceries for surprise visitors

Toodles! :)

Hosch250

@Vogel612 Gotta hate surprise visitors :P

Vogel612

I invited them, but we originally planned to meet at an outside venue

now they're coming here, somewhat unexpectedly

Hosch250

Oh, that's a little better.

Duga

16:35

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

[rubberduck-vba/Rubberduck] [codecov[bot]](github.com/apps/codecov) commented on pull request #3971: Update about control

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3971?src=pr&el=h1) Report
> Merging [#3971](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3971?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/1b1fe5cb0a9f3f17e4016128b4808fda16af7982?src=pr&el=desc) will **increase** coverage by `0.03%`.
> The diff coverage is `76.92%`.

```diff
@@ Coverage Diff @@
## next #3971 +/- ##
=======================

[rubberduck-vba/Rubberduck] build for commit 47455db0 on unknown branch: 57.84% (target 0%)

IvenBach

Duck check: msdn.microsoft.com/en-us/library/… "Invalidates the cached value for a single control on the Ribbon user interface." in laymans means it's ensuring cached info will always be correct?

this

IMO, it's a crappy name

IvenBach

I get the idea of caching information. That way you avoid repeated calls to get information.

this

think of it more like Redraw

or Repaint

IvenBach

I agree the name isn't optimal.

Repaint as in painting the image on the screen to make sure what the user sees is accurate?

this

16:41

whether there's a cache or not, that's not germane to your work, so yeah it's just giving you noise.

yes.

therefore if you change soemthing and you wnat to show it on ribbon, you must invalidate it

IvenBach

That invalidates whatever is cached, IE it goes out and acquires whatever the valid information ought to be.

this

which implies you must have set the information before you invalidate

if you remember that ribbon largely operate on callbacks

Mathieu Guindon

take VBA out or the Replace statement: Workbooks(Replace(tBurdenMaster, theFilePath, "")) — Zac 12 mins ago

this

invalidating will most likely cause the callback to be callbacked again

@MathieuGuindon no entiendo

Mathieu Guindon

@Zac that's useless advice at best, and a bad idea at worst. Fully-qualified library calls are always a good idea. That way if you have your own Replace function you know which one this is invoking. — Mathieu Guindon 7 mins ago

#OneSavedSoul

this

16:45

that's common - "this looks unfamiliar, so it must be bad"

Mathieu Guindon

has no effect whatsoever on the problem at hand

IvenBach

Leaving the comfort zone is scary enough that most people try not to.

Hosch250

Panera or Jimmy Johns for lunch?

Mathieu Guindon

McDonald's

Hosch250

Gross.

IvenBach

16:47

Hatam

Hosch250

Also, there isn't one in walking distance that I know of.

@IvenBach Not sure what that is.

I did Jimmy Johns last time, so I guess I'll do Panera this time.

IvenBach

@Hosch250 Persian restaurant across the street from me. Lunch special is $8 and you get enough for lunch and dinner. It's mmmmm tasty.

Hosch250

@IvenBach Sounds cool.

My sister usually packs my lunch, but she neither packed it nor told me to pack it, so I get to eat out today.

IvenBach

17:00

Deck check: A callback is just a specific word for "Do this instruction" at the appropriate time.

Mathieu Guindon

> I'll be back

IvenBach

Depending on the language it can be passed as a delegate, or in VBA a string for the method's name.

Mathieu Guindon

mostly correct, yes

this

pssssttttt....... what is an event?

IvenBach

@this Something I use but don't yet have a full understanding of how it works.

this

17:04

what does an event do?

Mathieu Guindon

fancypants bells & whistles for a templated method :)

IvenBach

I'm pretty sure you're alluding to the fact that an event is basically a callback in an of itself.

Mathieu Guindon

@IvenBach the handler is

Duga

[rubberduck-vba/Rubberduck] [codecov[bot]](github.com/apps/codecov) commented on pull request #3971: Update about control

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3971?src=pr&el=h1) Report
> Merging [#3971](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3971?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/1b1fe5cb0a9f3f17e4016128b4808fda16af7982?src=pr&el=desc) will **increase** coverage by `0.03%`.
> The diff coverage is `76.92%`.

```diff
@@ Coverage Diff @@
## next #3971 +/- ##
=======================

Mathieu Guindon

    protected abstract void DoStuff();

    private void DoSomething()
    {
        // stuff...
        DoStuff();
        // more stuff...
    }

IvenBach

17:06

I don't understand the difference between the event and the handler.

this

handler is the code you write that reacts to an event

e.g. if you have VBA code in a Worksheet_SelectionChange procedure, that's a handler

and yes, events is just basically a callback at its heart -- but the difference between a callback and a bona fide event is that a callback is simply a pointer to something. There is no contract, no expectation, no guarntee it won't crash, et cetera

Mathieu Guindon

^ above is a templated method. when you derive a type from this class, you need to implement DoStuff, right? DoSomething doesn't know what DoStuff is going to do, only that it's going to be invoked.

IvenBach

And the event occurs, in this example, when the user edits a cell.

Mathieu Guindon

public event EventHandler<CellEditEventArgs> Editing;

^ the class that defines the event knows when to raise that event

this

and when the user edits a cell, Excel's internal code is doing something similar to the DoSomething that Mat illustrated

Mathieu Guindon

17:09

it doesn't know or care whether something will handle the event

IvenBach

@MathieuGuindon The requirement to implement is because of the abstract keyword which indicates that it can only be a stub (no implementation allowed).

Mathieu Guindon

@IvenBach yeah but I might have taken a too-complicated route to explain.. ignore me :)

IvenBach

You tend to greatly overestimate my ability to comprehend...

Mathieu Guindon

Editing?.Invoke(this, new CellEditEventArgs(oldContent, newContent));

^ this would invoke the Editing event

FreeMan

@IvenBach you're on the left coast and @Hosch250 is on the North coast (I believe), so that wasn't all that helpful... :/

Hosch250

17:14

@FreeMan Coast?

Mathieu Guindon

@FreeMan north coast? lol

Hosch250

Not in Alaska yet.

FreeMan

17:27

@Hosch250 You're in MN, right? That's America's North Coast. Or, forehead, if you prefer, because it's just below America's hat.

:)

So. Very. True. commitstrip.com/en/2018/04/30/…

IvenBach

Mug mayn't like his country being referred to as a hat.

FreeMan

@IvenBach may note that the "hat" references only began once the swag was sent out... He didn't seem to mind too much then. Or, at least, didn't vociferously express his displeasure with the term.

IvenBach

Were there RD hats?

Hosch250

@IvenBach Not last time, I don't think.

I should ask Mat if he minds if I get an RD bike helmet.

Oh wait, he sent stickers. I can use those.

IvenBach

I really want a RD hat. I hate branding logos vehemently but I'll proudly wear one for RD.

Hosch250

17:39

Shouldn't be too hard to print baseball hats.

IvenBach

18:15

:blub blub: I'm drowning in browser tabs. @skiwi how do you manage so many?

Mathieu Guindon

hint: he doesn't ;-)

(at least, I don't think he does - or, he's a robot)

Hosch250

@IvenBach He just lets them build up, then closes them all at once.

skiwi

@IvenBach There's pinned tabs, tabs on the left hand side that are new and tabs on the right hand side that are new

IvenBach

I've been pretty good so far, 48 to go through. It's not helpful that 1 single tab can asexually reproduce to become 15+ tabs though...

Hosch250

@IvenBach Ah, you are at that stage. You'll advance quickly now.

IvenBach

18:24

They're more troublesome than tribbles.

Hosch250

When it feels like you have to read the entire internet to get it down.

Pretty soon you'll be able to skim articles more quickly "yep, yep, where's the one paragraph that mentions ABC?".

IvenBach

I've been there for a long time... I just was never at a level where I could understand what I was reading.

I'm doing that on some of the stuff I read now.

Hosch250

Give it another couple months.

IvenBach

That's why I've been so thankful to the others at this pond.

skiwi

I've only got 348 tabs though, that's not a lot at all

In this window, at least

IvenBach

18:27

Alone I couldn't figure out how to crack open the black box of learning.

@skiwi Making progress it seems.

skiwi

There's been times I've been at 2000+

And then it crashed

Hosch250

@skiwi Serves you right.

IvenBach

The first step is admitting you have a problem.

skiwi

I don't have a problem, my browser has one

Mathieu Guindon

browser's problem is 18 inches away from the monitor?

3

;-)

Hosch250

18:35

@skiwi owes Mozilla something for every tab he doesn't remember he has open :P

skiwi

I believe Firefox add some point released an update that improved performance with lots of tabs open

IvenBach

:click: There goes another bit of knowledge into the correct spot.

Mathieu Guindon

@Dai hehe.. that's precisely why I do Rubberduck ...wanna help? — Mathieu Guindon 9 secs ago

^ former Microsoft employee

Hosch250

> My employer's legal department requires me to declare that every opinion I express on Stack Overflow is also the opinion of the entire company, of every employee, and of the executive management. I am never wrong and am always right.

LOL!

IvenBach

18:55

Oh dear...

Duga

[rubberduck-vba/Rubberduck] bclothier commented on pull request #3976: Introducing Rubberduck.Resources

> I do think this is a case of choosing your own poisons. That said, I can offer one reason to centralize the resources --- it eliminate the guesswork of "do I need to share it?". A changing of resource is now only a namespace realignment; no project references needs to be changed, and though it's not strictly necessary, there is something to be said for having all i18n stuff in one place.

The bad is that of course, it can turn into a kitchen sink and we so totally don't want it. Also when w

Duga

19:06

[rubberduck-vba/Rubberduck] retailcoder commented on pull request #3976: Introducing Rubberduck.Resources

> @bclothier okay then I'll pick the "let's put everything we can under `Rubberduck.Resources`"; the DLL itself might not need to be updated anytime soon, but if we add Italian and Spanish translations then we should be able to do that without needing to recompile the regex assistant.

Thoughts?

IvenBach

20:20

@Hosch250 When you're going through documentation do you ever expect to understand it all or just the parts you've worked with or need to learn?

Hosch250

@IvenBach Both.

I expect to understand all of the parts I need to know.

I don't try to eat it at one gulp.

IvenBach

I'm doing it right then. #SoMuchToLearn

Duck check: Reading w3.org/TR/xmlschema-2/#boolean I've learned that trying to use foo="True" produces an error. foo="1" doesn't. I get the idea of make code, XML in this case, say what it does. Have any of you ever seen data that was persisted with 1 or 0 before?

Hosch250

@IvenBach Every day.

SQL Server stores true/false as 1/0.

IvenBach

:+1: Now I won't have an episode of WTF when I encounter it. At least I'm aware its an option.

IvenBach

20:44

For controls that are self closing <label Text="foo" /> is it typical to leave a space before the />? I've seen that and wondered about it for a while now.

Hosch250

I usually do.

Mathieu Guindon

#MeToo

IvenBach

Why? That's what I'm wondering.

Mathieu Guindon

because semantics

Hosch250

@IvenBach It helps my eye see that it isn't just a closing >.

With the whitespace, my eye catches the /> easily.

Mathieu Guindon

20:45

^

mark the date, I just agreed with @Hosch250 on something!

Hosch250

Without it, I often just see > and go "why the heck didn't they indent their code?"

Mathieu Guindon

(kidding)

IvenBach

:+1:

Hosch250

@MathieuGuindon We fight that often?

Mathieu Guindon

lol nah

IvenBach

20:46

I figured there was a reason. That was one I came up with. The other is it allows easier addition of more attributes, but that's a pretty weak argument.

Hosch250

@IvenBach Hmm?

Mathieu Guindon

well, a word for that would be "maintenance"

and it's a totally legit thing to worry about

IvenBach

Future-Me will be glad I ask all these duckheaded questions. :wink:

IvenBach

21:09

Duck check: For XML any value of an attribute will always be enclosed within doublequotes?

Duga

21:33

[rubberduck-vba/Rubberduck] sushrut91 commented on issue #3033: Rubberduck stuck on "Pending" Status.. Sub menu disabled

> I tried rubber duck in Corel Draw X7 VBE today. Facing the same issue. My exception is with command bar too as follows:

`2018-04-30 17:19:45.9533;INFO-2.2.6672.28001;Rubberduck.Parsing.VBA.RubberduckParserState;RubberduckParserState (4) is invoking StateChanged (UnexpectedError);
2018-04-30 17:19:52.6104;TRACE-2.2.6672.28001;Rubberduck.VBEditor.SafeComWrappers.Office.Core.CommandBarButton;Executing handler for: CommandBar 'Code Metrics' (tag: Custom Popup 13025890::ToolsMenu::CodeMetricsCo

[rubberduck-vba/Rubberduck] retailcoder commented on issue #3033: Rubberduck stuck on "Pending" Status.. Sub menu disabled

> I tried rubber duck in Corel Draw X7 VBE today. Facing the same issue. My exception is with command bar too as follows:

```
2018-04-30 17:19:45.9533;INFO-2.2.6672.28001;Rubberduck.Parsing.VBA.RubberduckParserState;RubberduckParserState (4) is invoking StateChanged (UnexpectedError);
2018-04-30 17:19:52.6104;TRACE-2.2.6672.28001;Rubberduck.VBEditor.SafeComWrappers.Office.Core.CommandBarButton;Executing handler for: CommandBar 'Code Metrics' (tag: Custom Popup 13025890::ToolsMenu::CodeMetri

[rubberduck-vba/Rubberduck] sushrut91 commented on issue #3033: Rubberduck stuck on "Pending" Status.. Sub menu disabled

> I tried rubber duck in Corel Draw X7 VBE today. Facing the same issue. Can someone point me out why this is happening & if this is resolved for anyone in Excel. I really want to unit test my vba code using rubberduck and would appreciate if some one helps me out. Thanks !
[RubberduckLog.txt](https://github.com/rubberduck-vba/Rubberduck/files/1962222/RubberduckLog.txt)

[rubberduck-vba/Rubberduck] retailcoder commented on issue #3033: Rubberduck stuck on "Pending" Status.. Sub menu disabled

> Seems updating the CommandBar button's caption (to reflect parser state) is throwing a COM exception again.

[rubberduck-vba/Rubberduck] retailcoder commented on issue #3033: Rubberduck stuck on "Pending" Status.. Sub menu disabled

> Seems updating the CommandBar button's caption (to reflect parser state) is throwing a COM exception again. @sushrut91 would you happen to know what version of the Office CommandBar Corel Draw X7 is using? Also, do you have Office installed? Which version, and was it installed before or after Corel Draw?

Duga

21:51

[rubberduck-vba/Rubberduck] retailcoder commented on issue #3033: Rubberduck stuck on "Pending" Status.. Sub menu disabled

> Seems updating the CommandBar button's caption (to reflect parser state) is throwing a COM exception again. @sushrut91 would you happen to know what version of the Office CommandBar Corel Draw X7 is using? Also, do you have Office installed? Which version, and was it installed before or after Corel Draw?

Corel Draw X7 was released in 2014, making its contemporary Office version Office 2013; if you have installed X7 on top of a later version of Office (2016?), the COM registration for the co

Mathieu Guindon

@Duga is there not a way to avoid this stupid mess?

Mathieu Guindon

22:03

Are you saying writing the CSV file one cell at a time will be "far more efficient" than using Excel's built-in SaveAs CSV format? — Mathieu Guindon 17 secs ago

TTQW

Duga

22:18

[rubberduck-vba/Rubberduck] sushrut91 commented on issue #3033: Rubberduck stuck on "Pending" Status.. Sub menu disabled

> Hello Mathieu,

I don't have any version of MS Office installed on my machine. My machine has Windows 10 Pro 64 bit. I am unable to exactly see which version of Office CommandBar Corel Draw X7 is using but please take a look at the screenshots maybe it may give some pointers towards the version.

Is office installation necessary for RubberDuck to work ? I don't want to spend on buying MS office. Is there a work around ?
![img1](https://user-images.githubusercontent.com/15870575/39453157-

Duga

22:31

[rubberduck-vba/Rubberduck] sushrut91 commented on issue #3033: Rubberduck stuck on "Pending" Status.. Sub menu disabled

> I don't have any version of MS Office installed on my machine. My machine has Windows 10 Pro 64 bit. I am unable to exactly see which version of Office CommandBar Corel Draw X7 is using but please take a look at the screenshots maybe it may give some pointers towards the version.

Is office installation necessary for RubberDuck to work ? I don't want to spend on buying MS office. Is there a work around ?
![img1](https://user-images.githubusercontent.com/15870575/39453157-d14251ee-4ca2-11e8

Mathieu Guindon

22:50

And when you write an Excel range to an array, then iterate through the elements of the array, that is not the same as iterating through "one cell at a time". When you iterate cells in a worksheet there is communication that occurs between the Excel application and VBA; and that takes time. Arrays are native to VBA and are lightning fast compared to iterating through a range "one cell at a time". — JBStovers 27 mins ago

Thanks, I'd never known! ........... looks at gold tag badges, MVP award, wonders what's wrong with the world

Hosch250

@MathieuGuindon You got the check regardless.

IvenBach

@MathieuGuindon Reading from the cells takes virtually no time. It's the writing to them that's the major speed reducer. Either way I'm all for loading it into an array variant.

I'm glad you took the time to explain everything along the way.

Mathieu Guindon

@IvenBach point is, OP merely needed to paste special / values, remove two columns and save as CSV.... I fail to see where/how an array and writing the file one cell value at a time saves any processing anywhere.

IvenBach

A certain duckling should write an article about using FooRange.Value2 = BarRange.Value2 when you only want the values...

@laptop2d Welcome to the pond.

Transcript for