« first day (1424 days earlier)      last day (1756 days later) » 

Duga
Duga
12:01 AM
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.
 
 
1 hour later…
Duga
Duga
1:12 AM
> 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
 
Mathieu Guindon
Mathieu Guindon
this is glorious
 
Duga
Duga
[rubberduck-vba/Rubberduck] build for commit cddadde8 on unknown branch: AppVeyor build failed
BUILD FAILURE!
 
Mathieu Guindon
Mathieu Guindon
*will be
:)
 
this
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. ;)
 
 
2 hours later…
Tweeting Duck
Tweeting Duck
2:57 AM
#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
Updated page on RD News: "Using Rubberduck"
Tweeted by rubberduckvba on April 30, 2018 at 2:57 AM
 
 
1 hour later…
Tweeting Duck
Tweeting Duck
4:08 AM
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
 
 
2 hours later…
Mathieu Guindon
Mathieu Guindon
5:39 AM
@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
 
 
4 hours later…
QHarr
QHarr
9:26 AM
Anyone home?
 
Inarion
Inarion
Nope - I'm at work.
;)
 
QHarr
QHarr
lol
I will re-phrase! Anyone on here and know anything about vba/typeahead.js ?
 
this
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
QHarr
9:43 AM
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
this
still not understanding what it has to do w/ VBA; nor why one needs a "typeahead.js" to scrape.
 
QHarr
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
this
so, to see - you want to automate this?
by basically injecting text into this so that you can scrape the result somehow?
 
QHarr
QHarr
Yes. I have done all the other steps including entering data into this box but I dont think it is retained
 
this
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
QHarr
9:50 AM
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
this
were I you, I'd buckle down and do it w/ selenium
other methods are too fragile
 
QHarr
QHarr
:sighs:
 
this
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
QHarr
:laughs:
 
this
this
I know. not all comply and they're dumb for it.
 
QHarr
QHarr
9:56 AM
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
Quack Exchange
10:28 AM
-1
Q: Find and Match Values Column b and Column G and Show Result in Column P

Muhammad Hassan Ali 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 ...

vba excel
 
ashleedawg
ashleedawg
10:41 AM
@QHarr you have to match the text from the autocomplete exactly, right before the click will fire, right?
 
QHarr
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
Peter M Taylor
11:14 AM
@ashleedawg welcoming you too in the pond. Just felt the ripple waves of sorts. :)
 
 
1 hour later…
Mathieu Guindon
Mathieu Guindon
12:18 PM
@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
this
@MathieuGuindon :( That sucks. His website is one of pretty comprehensive site covering VBA.
 
Inarion
Inarion
@MathieuGuindon RIP, Chip :(
4
I certainly had more than one insightful moment reading on his site.
 
this
this
12:36 PM
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
Tweeting Duck
12:49 PM
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
FreeMan
As the father of 2 boys and a girl, I can't even begin to imagine their sorrow.
 
FreeMan
FreeMan
1:03 PM
On a more positive note, this is pretty handy: idownvotedbecau.se
 
 
1 hour later…
Duga
Duga
2:09 PM
> 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.
 
Mathieu Guindon
Mathieu Guindon
@this should I PR my changes then?
 
this
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
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
this
cool
 
Duga
Duga
> This will likely conflict with #3975 a bit.

ref. #3862
 
this
this
2:19 PM
now i'm glad I didn't merge that. 401 files... yikes!
 
Duga
Duga
 
Mathieu Guindon
Mathieu Guindon
@this yeah.. lots of XAML
mostly just using statements added everywhere
 
this
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
Mathieu Guindon
true
I noticed a couple of hard-coded GUIDs, didn't touch them
 
this
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
Mathieu Guindon
2:23 PM
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
this
I think that's what I was seeing and why I changed to SharedResources to avoid that.
 
Mathieu Guindon
Mathieu Guindon
also I'm missing the inspection resources, they're still under Rubberduck.Parsing.Resources
 
this
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
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
this
i did find the images for the original InstallShield installer, so.... yeah.
 
Mathieu Guindon
Mathieu Guindon
2:26 PM
Source="../../../../../Rubberduck/Rubberduck.Resources/Icons/Fugue/cross-script.png"
not sure I like the relative paths either
 
Vogel612
Vogel612
Are the regex-assistant resources also moved?
 
Mathieu Guindon
Mathieu Guindon
missed them as well
 
this
this
Does it really have to be?
Surely you should be able to reference via the project reference, done.
 
Mathieu Guindon
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
this
i mean, if C# can find the assembly without using relative path directly, surely XAML should...
 
Mathieu Guindon
Mathieu Guindon
2:29 PM
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
this
images is kinda of UI....
but, then again, if you could, why not just do it properly with Rubberduck.Resources.Images
 
Mathieu Guindon
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
Duga
[rubberduck-vba/Rubberduck] build for commit a916f44c on unknown branch: AppVeyor build succeeded
 
Tweeting Duck
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
Duga
> Missing Rubberduck.Parsing.Inspections resources. Also, should feature-specific resources be moved there as well? e.g. @Vogel612's Regex assistant tool?
 
IvenBach
IvenBach
3:32 PM
@TweetingDuck Did not know about this.
 
Vityata
Vityata
3:48 PM
@TweetingDuck RIP :(
 
Hosch250
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
IvenBach
4:00 PM
I have learned from and greatly appreciated all the information he has on his site.
 
Hosch250
Hosch250
Only thing we can do now is pass it on--and make sure the site stays up.
 
IvenBach
IvenBach
... 404 trying to access his site.
 
Hosch250
Hosch250
Already took it down?
That was fast...
@IvenBach What's the URL?
 
IvenBach
IvenBach
Any and all links to it are 404.
 
Mathieu Guindon
Mathieu Guindon
half of SO's external VBA links have gone dead
 
Hosch250
Hosch250
4:03 PM
Yep. They took it down.
They still own the domain.
 
IvenBach
IvenBach
A severe disturbance in the force has just happened. I've felt thousands of Excel users die just a little bit inside...
 
Hosch250
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
Vogel612
check whether the waybackmachine has something
 
Hosch250
Hosch250
@Vogel612 April 8th is the last snapshot.
 
Vogel612
Vogel612
that seems pretty up-to-date
 
this
this
4:05 PM
I don't think Chip was updating his site for a good while.
 
IvenBach
IvenBach
^
If he was they must've been very minor edits.
 
this
this
In spite of that, it was still high on your typical trawling for anything VBA.
 
Hosch250
Hosch250
The accident happened early April.
 
this
this
yeah apparently he was hospitialized for a good while but just didn't make it. :\
 
Hosch250
Hosch250
If someone can download that, I can take the next steps to getting it up and hosted, I guess.
 
this
this
4:07 PM
that just.... sucks.
esp for his poor parents.
 
Hosch250
Hosch250
New design to emphasize it isn't him anymore, but proper citation?
Or just dump it the way it was?
 
this
this
could be sticky.
 
Hosch250
Hosch250
Yeah, especially the legal issues.
 
this
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
Mathieu Guindon
@Hosch250 not without contacting the family
 
Hosch250
Hosch250
4:08 PM
First step is to download it so it doesn't get 100% lost.
Right.
 
this
this
and I have to be willing that it might be a good while before they are willing to talk.
 
Hosch250
Hosch250
@MathieuGuindon OK.
 
this
this
Can't have strangers pounding on the door asking for a website they might not even know about.
 
Hosch250
Hosch250
But really, download it quick before it goes down if you have access to a personal machine. I'm at work.
 
Mathieu Guindon
Mathieu Guindon
@this might have been a timing coincidence, but I doubt the domain simply expired...
 
Hosch250
Hosch250
4:09 PM
@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
IvenBach
@Hosch250 How/Where do you go to check for site expiration?
 
Hosch250
Hosch250
@IvenBach Whois.
 
Mathieu Guindon
Mathieu Guindon
so they took it down while they sort things out. let the dust settle, see what happens.
 
this
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
Hosch250
@this If it were me, I'd email his contact on the website and hope they see it.
 
this
this
4:11 PM
that could work.
 
Hosch250
Hosch250
Also, tweet at his account, if he has one.
 
Mathieu Guindon
Mathieu Guindon
Roger Govier just emailed the Excel DL
 
IvenBach
IvenBach
Hope he had something in a Will & Trust stating his wishes for the site.
 
this
this
^ @MathieuGuindon ^
 
IvenBach
IvenBach
I joke about the bus factor but there is truth to it.
 
Hosch250
Hosch250
4:17 PM
@IvenBach Like the time the Google bus ran over an MS employee?
 
IvenBach
IvenBach
Ooof... Irony.
Didn't hear about that one.
 
Duga
Duga
 
IvenBach
IvenBach
@Duga @Vogel612 Got your edits.
 
Vogel612
Vogel612
nice :)
Any questions about how PRs work?
 
IvenBach
IvenBach
I'll count Monday morning as weekend.
 
Hosch250
Hosch250
4:22 PM
@Vogel612 He's made a few before.
 
IvenBach
IvenBach
Not pulling stuff into my repo though.
 
Vogel612
Vogel612
but not received them to his repo
 
IvenBach
IvenBach
^
 
Hosch250
Hosch250
Oh, I see.
We are just finalizing teaching people about outgoing PRs now.
 
IvenBach
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
Vogel612
4:24 PM
:+1:
 
IvenBach
IvenBach
I need to get back to my Ribbon modification examples. Still stoked I'm understanding the basics. Long ways to go still.
 
Vogel612
Vogel612
that's what we're here for. That said, I gotta go grab groceries for surprise visitors
Toodles! :)
 
Hosch250
Hosch250
@Vogel612 Gotta hate surprise visitors :P
 
Vogel612
Vogel612
I invited them, but we originally planned to meet at an outside venue
now they're coming here, somewhat unexpectedly
 
Hosch250
Hosch250
Oh, that's a little better.
 
Duga
Duga
4:35 PM
[rubberduck-vba/Rubberduck] build for commit 47455db0 on unknown branch: AppVeyor build succeeded
> # [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
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
this
IMO, it's a crappy name
 
IvenBach
IvenBach
I get the idea of caching information. That way you avoid repeated calls to get information.
 
this
this
think of it more like Redraw
or Repaint
 
IvenBach
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
this
4:41 PM
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
IvenBach
That invalidates whatever is cached, IE it goes out and acquires whatever the valid information ought to be.
 
this
this
which implies you must have set the information before you invalidate
if you remember that ribbon largely operate on callbacks
 
Mathieu Guindon
Mathieu Guindon
take VBA out or the Replace statement: Workbooks(Replace(tBurdenMaster, theFilePath, "")) — Zac 12 mins ago
 
this
this
invalidating will most likely cause the callback to be callbacked again
@MathieuGuindon no entiendo
 
Mathieu Guindon
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
this
4:45 PM
that's common - "this looks unfamiliar, so it must be bad"
 
Mathieu Guindon
Mathieu Guindon
has no effect whatsoever on the problem at hand
 
IvenBach
IvenBach
Leaving the comfort zone is scary enough that most people try not to.
 
Hosch250
Hosch250
Panera or Jimmy Johns for lunch?
 
Mathieu Guindon
Mathieu Guindon
McDonald's
 
Hosch250
Hosch250
Gross.
 
IvenBach
IvenBach
4:47 PM
Hatam
 
Hosch250
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
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
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
IvenBach
5:00 PM
Deck check: A callback is just a specific word for "Do this instruction" at the appropriate time.
 
Mathieu Guindon
Mathieu Guindon
> I'll be back
 
IvenBach
IvenBach
Depending on the language it can be passed as a delegate, or in VBA a string for the method's name.
 
Mathieu Guindon
Mathieu Guindon
mostly correct, yes
 
this
this
pssssttttt....... what is an event?
 
IvenBach
IvenBach
@this Something I use but don't yet have a full understanding of how it works.
 
this
this
5:04 PM
what does an event do?
 
Mathieu Guindon
Mathieu Guindon
fancypants bells & whistles for a templated method :)
 
IvenBach
IvenBach
I'm pretty sure you're alluding to the fact that an event is basically a callback in an of itself.
 
Mathieu Guindon
Mathieu Guindon
@IvenBach the handler is
 
Duga
Duga
> # [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
Mathieu Guindon
    protected abstract void DoStuff();

    private void DoSomething()
    {
        // stuff...
        DoStuff();
        // more stuff...
    }
 
IvenBach
IvenBach
5:06 PM
I don't understand the difference between the event and the handler.
 
this
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
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
IvenBach
And the event occurs, in this example, when the user edits a cell.
 
Mathieu Guindon
Mathieu Guindon
public event EventHandler<CellEditEventArgs> Editing;
^ the class that defines the event knows when to raise that event
 
this
this
and when the user edits a cell, Excel's internal code is doing something similar to the DoSomething that Mat illustrated
 
Mathieu Guindon
Mathieu Guindon
5:09 PM
it doesn't know or care whether something will handle the event
 
IvenBach
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
Mathieu Guindon
@IvenBach yeah but I might have taken a too-complicated route to explain.. ignore me :)
 
IvenBach
IvenBach
You tend to greatly overestimate my ability to comprehend...
 
Mathieu Guindon
Mathieu Guindon
Editing?.Invoke(this, new CellEditEventArgs(oldContent, newContent));
^ this would invoke the Editing event
 
FreeMan
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
Hosch250
5:14 PM
@FreeMan Coast?
 
Mathieu Guindon
Mathieu Guindon
@FreeMan north coast? lol
 
Hosch250
Hosch250
Not in Alaska yet.
 
FreeMan
FreeMan
5:27 PM
@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.
:)
 
IvenBach
IvenBach
Mug mayn't like his country being referred to as a hat.
 
FreeMan
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
IvenBach
Were there RD hats?
 
Hosch250
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
IvenBach
I really want a RD hat. I hate branding logos vehemently but I'll proudly wear one for RD.
 
Hosch250
Hosch250
5:39 PM
Shouldn't be too hard to print baseball hats.
 
IvenBach
IvenBach
6:15 PM
:blub blub: I'm drowning in browser tabs. @skiwi how do you manage so many?
 
Mathieu Guindon
Mathieu Guindon
hint: he doesn't ;-)
(at least, I don't think he does - or, he's a robot)
 
Hosch250
Hosch250
@IvenBach He just lets them build up, then closes them all at once.
 
skiwi
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
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
Hosch250
@IvenBach Ah, you are at that stage. You'll advance quickly now.
 
IvenBach
IvenBach
6:24 PM
They're more troublesome than tribbles.
 
Hosch250
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
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
Hosch250
Give it another couple months.
 
IvenBach
IvenBach
That's why I've been so thankful to the others at this pond.
 
skiwi
skiwi
I've only got 348 tabs though, that's not a lot at all
In this window, at least
 
IvenBach
IvenBach
6:27 PM
Alone I couldn't figure out how to crack open the black box of learning.
@skiwi Making progress it seems.
 
skiwi
skiwi
There's been times I've been at 2000+
And then it crashed
 
Hosch250
Hosch250
@skiwi Serves you right.
 
IvenBach
IvenBach
The first step is admitting you have a problem.
 
skiwi
skiwi
I don't have a problem, my browser has one
 
Mathieu Guindon
Mathieu Guindon
browser's problem is 18 inches away from the monitor?
3
;-)
 
Hosch250
Hosch250
6:35 PM
@skiwi owes Mozilla something for every tab he doesn't remember he has open :P
 
skiwi
skiwi
I believe Firefox add some point released an update that improved performance with lots of tabs open
 
IvenBach
IvenBach
:click: There goes another bit of knowledge into the correct spot.
 
Mathieu Guindon
Mathieu Guindon
@Dai hehe.. that's precisely why I do Rubberduck ...wanna help? — Mathieu Guindon 9 secs ago
^ former Microsoft employee
 
Hosch250
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
IvenBach
6:55 PM
Oh dear...
 
Duga
Duga
> 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
Duga
7:06 PM
> @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?
 
 
1 hour later…
IvenBach
IvenBach
8:20 PM
@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
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
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
Hosch250
@IvenBach Every day.
SQL Server stores true/false as 1/0.
 
IvenBach
IvenBach
:+1: Now I won't have an episode of WTF when I encounter it. At least I'm aware its an option.
 
IvenBach
IvenBach
8:44 PM
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
Hosch250
I usually do.
 
Mathieu Guindon
Mathieu Guindon
#MeToo
 
IvenBach
IvenBach
Why? That's what I'm wondering.
 
Mathieu Guindon
Mathieu Guindon
because semantics
 
Hosch250
Hosch250
@IvenBach It helps my eye see that it isn't just a closing >.
With the whitespace, my eye catches the /> easily.
 
Mathieu Guindon
Mathieu Guindon
8:45 PM
^
mark the date, I just agreed with @Hosch250 on something!
 
Hosch250
Hosch250
Without it, I often just see > and go "why the heck didn't they indent their code?"
 
Mathieu Guindon
Mathieu Guindon
(kidding)
 
IvenBach
IvenBach
:+1:
 
Hosch250
Hosch250
@MathieuGuindon We fight that often?
 
Mathieu Guindon
Mathieu Guindon
lol nah
 
IvenBach
IvenBach
8:46 PM
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
Hosch250
@IvenBach Hmm?
 
Mathieu Guindon
Mathieu Guindon
well, a word for that would be "maintenance"
and it's a totally legit thing to worry about
 
IvenBach
IvenBach
Future-Me will be glad I ask all these duckheaded questions. :wink:
 
IvenBach
IvenBach
9:09 PM
Duck check: For XML any value of an attribute will always be enclosed within doublequotes?
 
Duga
Duga
9:33 PM
> 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
> 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
> 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)
> Seems updating the CommandBar button's caption (to reflect parser state) is throwing a COM exception again.
> 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
Duga
9:51 PM
> 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
Mathieu Guindon
@Duga is there not a way to avoid this stupid mess?
 
Mathieu Guindon
Mathieu Guindon
10:03 PM
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
Duga
10:18 PM
> 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
Duga
10:31 PM
> 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
Mathieu Guindon
10:50 PM
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
Hosch250
@MathieuGuindon You got the check regardless.
 
IvenBach
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
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
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.
 

« first day (1424 days earlier)      last day (1756 days later) »