VBA Rubberducking - 2017-10-18 (page 1 of 2)

« first day (1230 days earlier) ← previous day next day → last day (1950 days later) »

12:01 AM

RELOAD!

[banane-io/PDB] 2 opened issues. 23 issue comments.

[retailcoder/Rubberduck] 6 commits. 267 additions. 138 deletions.

[rubberduck-vba/Rubberduck] 42 commits. 2 closed issues. 11 issue comments. 27827 additions. 14571 deletions.

[Vogel612/TranslationHelper\‌] 2 commits. 1 issue comment. 8 additions. 8 deletions.

[Zomis/vue-game] 2 commits. 158 additions. 9 deletions.

12:12 AM

@Mat'sMug Instead of returning inspection results, we should fire an event or something like "ResultFound" with the result.

Then anyone can listen to it.

@Hosch250 I'd rather annotate the target, and whoever is interested / when they're interested, can pull the results they need to display, where when & how they need

Hmm. And somehow notify those guys to update?

No need, we know it's updated when parser state says it is

Inspections isn't the parser's responsibility.

Heck, the resolver barely is.

But diagnostics are fine in Roslyn?

Along with the semantics?

12:16 AM

They aren't run by the parser.

The parser notifies them they can run, more like we have it now.

Except each one listens individually.

12:33 AM

Looks like more OOM errors to me.

Stopping the tests as soon as they start to error, then running the not-run tests, then the failed tests makes them pass.

Whatever...

GTG.

@Hosch250 again ... it's not OOM errors... the failures persist in x64 architecture and when running only the failing tests. ...

1:05 AM

@Vogel612 It says OOM.

What does the result for your test say?

> Message: Test method RubberduckTests.Inspections.LineLabelNotUsedInspectionTests.LabelNotUsed_EdgeCaseIssue3226 threw exception:
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.

1:58 AM

BTW, @this, you requested to join me on Skype again last night...

I accepted this time since you said it was you, but I don't know what the heck is going on.

Am I in your address book somehow? Is it trying to connect to everyone?

I can block you if you like, and unblock you if ever want to talk (just ping me here, or send me an email, or something).

1 hour later…

3:19 AM

[rubberduck-vba/Rubberduck] INOPIAE synchronized pull request #3478: added new German translations, removed VBEEditorText.sv.resx

[rubberduck-vba/Rubberduck] INOPIAE synchronized pull request #3478: added new German translations, removed VBEEditorText.sv.resx

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

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

2 hours later…

5:47 AM

You available Peter?

Sorry @IvenBach for replying late. Was working

I'm having degrading behavior with RD and apparently Ninject.

What parts made you say it’s degrading

I can't see the RD tab in the IDE.

I'm getting ninject errors on startup.

I've tried pulling a new branch from upstream/next but can't make any progress.

Okay, so at the moment you are not in sync with next right?

5:53 AM

To my knowledge I am.

Do a git status to confirm

up-to-date | nothing to commit, working tree clean

Okay so do we know that your build has compiled successfully in VS?

========== Clean: 9 succeeded, 0 failed, 0 skipped ========== and ========== Build: 9 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========

I assumed your working on the development branch next

5:58 AM

from upstream/next

Okay so your build is working.

It builds, yes.

When I run excel via F5 from VS and load into the IDE I get an error message that resolves down to ninject.

Similar to OOM errors Hoch mentioned earlier?

I don't know if they are related.

I've heard Castle Windsor was to replace Ninject. Don't know if the PR has been completed or not.

as far as I could tell, the pr is made but not merged into next yet

So we are using ninject. Too soon

6:03 AM

github.com/rubberduck-vba/Rubberduck/pull/3471 shows it as merged.

My bad, so we are looking at the test verison of CW now and it’s not perfect

I don't know. Possibly?

I am not at my desk but will see how it looks when I have time later I am on my way home at the moment using my ipad

I really wished I have a windows laptop so I could do some tests

When I initially load RD in the output window I get Cannot find or open the PDB file. from 39 lines.

I think but not sure 🤔 PDB file is a file that needs to be registered

So I assumed you are running with Admin access

6:10 AM

'EXCEL.EXE' (CLR v4.0.30319: DefaultDomain): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_64\mscorlib\v4.0_4.0.0.0__b77a5c561934e089\mscorlib.dll'. Cannot find or open the PDB file.
'EXCEL.EXE' (CLR v4.0.30319: DefaultDomain): Loaded 'C:\Users\CODI\Documents\Visual Studio 2015\Projects\RubberduckVBA\RetailCoder.VBE\bin\x64\Debug\Rubberduck.dll'. Symbols loaded.
'EXCEL.EXE' (CLR v4.0.30319: DefaultDomain): Loaded 'C:\Users\CODI\Documents\Visual Studio 2015\Projects\RubberduckVBA\RetailCoder.VBE\bin\x64\Debug\NLog.dll'. Cannot find or open the PDB file.

Is the full output and I get The thread 0xea8 has exited with code 0 (0x0). periodically being appended to the bottom if I leave the IDE open.

I've gotta get some sleep. #TomorrowIt'llWork

You appear not to have symbols loaded. I think there is an option in the vs

Night sweet dreams. someone could follow on what I assumed later

And I will have a go to confirm

1 hour later…

7:43 AM

@IvenBach can you do a git fetch upstream? You shouldn't be getting any Ninject messages anymore

8:09 AM

@IvenBach You are running VS with as admin when you are building RD, right?

2 hours later…

10:18 AM

@Hosch250 Ok that's worrying me. I definitely didn't request to connect on Skype; heck I wasn't even on the computer all the evening yesterday! Going to find out if I have something nasty that's making my Skype a zombie or something.... :\ Thanks for letting me know.

10:38 AM

@Hosch250 One more thing - I don't even see you in the contact list, either; at least nothing that matches your real name or the avatar here.

1 hour later…

12:04 PM

[rubberduck-vba/Rubberduck] retailcoder closed issue #3473: Not everything is a "code quality issue"

1 hour later…

1:10 PM

@PeterMTaylor I can sign one-handed or two-handed; ambidextrious, so depending what is in either hand I can muster alright. I will say that my finger-spelling is much cleaner on my left than my right

1 hour later…

2:11 PM

@Vogel612 have done both a fetch and pull from upstream

@M.Doerner any time I'm running VS I do it as admin

@IvenBach can you do a git log --oneline --decorate --graph --all?

2:34 PM

it's showing all the branches

which part did you need?

@this Are you using Skype for Business?

for my work, yes - i also have skype personal

I'm getting requests from Skype for Business.

@IvenBach the one where we can spot a discrepancy between local and remote

especially possibly between upstream and local ...

@Hosch250 and that's scaring me, to be frank. Earlier I deleted all contacts that were "pending" I don't see any other unusual / unfamiliar contacts. What did the request say?

was it a stanard message "pls add me as contact" or something else?

2:39 PM

Yeah, just the standard.

I can post a screenshot tonight.

Please. Still no reports from the AV/Malware detection; I plan to reinstall the SFB. I definitely do not like it when software do stuff without me knowing.

Am I maybe in your addressbook?

It might be trying to connect with people in your address book.

AFAICS, no. No match for "hosch" in my Outlook's address book or any contacts (and that's where the SFB is supposed to get it from, AIUI)

[rubberduck-vba/Rubberduck] retailcoder commented on issue #3453: Rubberduck doesn't see anything yet and submenus are disabled

> Ça ressemble à un problème avec les *Primary Interop Assemblies* de Office. J'ai trouvé [ceci sur Stack Overflow](https://stackoverflow.com/a/28067357/1188513), qui pourrait fort bien être à la source du problème.

- Ouvrir REGEDIT.EXE (privilèges administrateur local requis)
- Trouver et ouvrir la clé `Ordinateur\HKEY_CLASSES_ROOT\TypeLib\{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}`
- Vérifier les sous-clés pour les versions enregistrées:

![Regedit showing Office 14.0 PIA registration](h

user image

@Vogel612 That's what I have at the very top of it.

Heading to work. Wont be able to check anything till I get home.

2:49 PM

@IvenBach Another stupid question: you have (re-)built the entire solution, not only the main project and its dependencies?

soo ... git excluded...

3:08 PM

@M.Doerner as in clean and rebuild? Yes I've tried that several times.

@IvenBach you can "clean+rebuild" a project too - we're asking if you're doing it on the solution

@Vogel612 ?

i.e. git looks clean?

3:22 PM

yeap

@IvenBach Did you choose Build-->Rebuild solution/Build-->Build solution (F6) or Build-->Rebuild Rubberduck/Build-->Build Rubberduck?

TBH that's not surprising. I'm seeing the same issues, and my git looks clean to me, too...

Did maybe something go wrong with the registration either of the COM library or the addin in the registry?

Another suspect: does wiping the setings file help?

~~also: is the power cord plugged in?~~

@M.Doerner As I can remember I did the build that's right under clean.

Would I need to clean each individual project separately?

3:36 PM

no; as long as you used the root/solution node all is good

@Mat'sMug I'm almost offended. Given some of my questions I understand why you'd ask.

For my education the *** mean a commit?

sorry, didn't mean to offend.. was just throwing in the typical help desk reply for fun

I'm not actually offended. <joking> tag should have been used.

duly noted :)

It takes a bit to ruffle my feathers.

3:39 PM

fails to come up with a witty wordplay involving a byte

You seek to instruct with frankness, and I appreciate it.

@Mat'sMug You bit the bait.

I'm almost tempted to say nuke your local clone and try starting one from scratch

I've contemplated that a few times.

I'm tempted to say nuke your fork, if you don't have pending changes, and restart.

3:41 PM

So just delete the RD folder in the 'projects' folder?

I'm wondering - does RD even run, too?

@IvenBach Yeah.

It did... Now it doesn't.

pull the handle.

I've been having degrading performance/failing tests.

3:42 PM

yeah, I was thinking that if RD ran, it would at least suggest that the problem exists in the test project only

is there a Rubberduck in add/remove programs?

Any changes I have aren't that ballbreakingly difficult to redo.

sound like it's not confined to that.

@Mat'sMug There is.

remove it

3:43 PM

I tried uninstalling and reinstalling.

wait, no,

you wanna uninstall only

no reinstall

no, you can't have both the installed and the dev build on one machine

^

This could be the issue then.

<thinks>Did I do a RD install while I had a dev build</thinks>. I fairly certain that's not the case but I'll remove and test tonight.

I may be that I have 2 power cables plugged in simultaneously.

Remember the ~~good~~ bad old days when you had DLL Hell? Yeah, COM's the why.

3:46 PM

^ Nope. Never dealt with that. DLL Hell and COM is still a fuzzy concept.

ooooh, so we got ourselves a young insolent whippersnapper here....

install Windows 95. Try to install few programs. See how it goes. :p

I've not claimed otherwise.

I remember Win95. BSOD was quite frequent.

Just for the record, first Windows computer I used was Windows 8.

Later, I used the library's XP (after the expiration date to boot).

^ That makes me feel old.

We had a Mac in the Vista days.

Oh, we had a Windows 98 that I got to use like once or twice.

Playing the fish-catching game.

We got rid of it, though, because it crashed.

I totally need to find an Oregon Trail clone one of these days.

Never got to play that one; my dad did.

And he almost always crashed the computer, which pissed my mom off.

3:51 PM

Make sure you play as the farmer, buy no supplies, ford every river, eat nothing but bare meals, and set a grueling pace.

That's how you test if you're hardcore or not.

i'd imagine everyone in the party'd die.

@IvenBach that's called artificial difficulty

@this IIRC both Hosch and I are younger than Ivern

so, three whippersnappers. One of you'll have to be the popper, then.

:p

It's equivalent to being Dumb, Poor, and Slothful. AKA Like on 'Brutal' difficulty.

I'm only 31 so don't judge me too harshly.

meh. Anyone below 55 is automatically a whippersnapper. ;)

3:56 PM

<~ whippersnapper

then we're in good company, I guess

Seems like this is an octogenarian.

<~ calling the kettle black

not even that old.

lol

@IvenBach I'm barely 22 :P

3:59 PM

<~ 35

<~ 31

<~ <snark>Likes long walks on the beach, eating stews at home, and getting help with his RD problems</snark>

4:17 PM

@IvenBach You like stew?!

Correct. I make a very tasty pork stew.

I don't care too much for stews and soups. Too watery.

Stew generally aren't supposed to be watery. Otherwise it's a soup

@IvenBach which pork?

Stews ought to stick to what you put in them: bread, spoon, finger.

Pork shoulder.

my favorite

4:19 PM

They do, but they are still too watery.

I like sandwiches.

And pizza.

Throw the whole thing, bone and all, in an 18qt roaster and cook for 6-7 hours.

yeah, that's the best thing about stews. so easy to make and filling.

Add whatever accouterments (onions, garlic, peas, carrots, spuds, celery, etc...)

I'm more of a frying pan person ...

We eat it with homemade potato bread.

4:21 PM

but I can get behind stews in the winter.

^ This is why winter is my favorite time of the year.

Hosch, I like me some sand witches, too. Gonna get them fresh, though. Halloween should be a good hunting season for those.

Sounds good.

@this Do you hunt them with Jorge Spraave's witch hunting tools?

He has a witch-beheader, and another one that sprays them with gasoline and shoots flaming arrows.

And one that shoots a broom into them quite hard.

@this I'd suggest marinating it with lemon juice for 30 mins while you first put it into the pan. I did that a few times back and it was superbly glorious.

why not smoke them?

4:23 PM

Don't have any room for a smoker.

gotta be careful though. some of them have a tendency to self-ignite...

My old man's got 3 small ones. Been forever since we used them. Last time was smoked barracuda.

Being a octogenerarian wanna-be, I usually opt for old skool Van Helsing approach.

Impaling with ash?

Real men shoot their hams from a cannon to cook/smoke them in one blow :P

Bonus points if they shoot it right into their mouths :P

4:30 PM

The Simpsons - When Pigs Fly

4:59 PM

Company meeting/barbecue in a couple minutes.

5:56 PM

0

Q: Filtering by pivot items in a pivot table taking way too long

I'm using the following code to filter out "affiliate" or "affiliates" from pivot tables, but it takes so long to run that it's almost not even worth it - I can accomplish the same much faster manually by searching in the filter and in one click, removing all of the pivot items. Is there some dif...

6:47 PM

This is bizarre behavior... I have:

  If Prompt <> vbNullString Then
    ThisWorkbook.Names(Location).RefersToRange = InputBox(Prompt:=Prompt, Default:=ThisWorkbook.Names(Location).RefersToRange)
  End If

Prompt is decidedly not vbNullString, the debugger steps into the the True condition, executes the line of code, but does not display the InputBox.

pull it into its own instruction

and use Application.InputBox instead and specify a Type parameter to validate that you're getting an actual Range

changed to Application.InputBox - no noticeable behavior change. Added Type:=8 to indicate a Range object - the input box popped up, but demanded that I enter a range (not what I wanted).

Changed to Type:=2 to indicate Text (a string) and it's hunky dory now.

weird because this function was working in other calls...

ah

thanks for the tip,

sorry I misunderstood the intent here

6:57 PM

no worries.

it works, but, annoyingly, I don't know why.

of course, it worked elsewhere, too, and I don't know why it broke here...

It happens to behave that way on Wednesdays.

ThisWorkbook.Names(Location).RefersToRange = InputBox(Prompt:=Prompt, Default:=ThisWorkbook.Names(Location).RefersToRange)

that's dereferencing ThisWorkbook.Names(Location).RefersToRange twice

and will probably blow up if the InputBox is cancelled, or if the user enters "blah"

always. have. user. input. validated.

4

@Mat'sMug That's one of the things that was hammered into my skull by Bjarne Stroustrup.

it's common sense :)

@Mat'sMug Would it also be beneficial to store it in its own variable to have it dereferenced once?

7:00 PM

with enough debugging experience, it gets into your skull anyway

@IvenBach yes

@FreeMan ^

makes the instruction much shorter too

@Mat'sMug You might be surprised.

:+1:

cognitiveLoad--;

7:01 PM

^

I've learned a thing or 2 from hanging around this pond.

so I've heard :)

Lurnin alls ya'lss fansee wurds do did make me comprehendin ya'lss ezyur.

I try and show appreciation where it's due.

Curse you, TFS, and your disappearing take on commits.

Duck check: Can an integral variable be used with composite formatting be used as part of a width? Must it be a static number?

Console.WriteLine("{0, width} has been visited: {1}", state++, visited); where width is of type int

I just came in here real quick to say I finally understand why Rubberducking

I love the concept 8) and am going to start using it

of using a rubber duck i mean

7:07 PM

My ducky is above my coding monitor. She hears from me more than she wants to.

haha awesome. people at work are going to think i'm a weirdo, but hey... they probably already do

anyways, sorry to disrupt. was jsut excited when i found out

He's weird, always asking that duck questions. Don't talk to him.

3

Win-Win because 1) Better code 2) Less distractions.

now there's some thinking :D

they'll just e-mail me instead lol

from one cubicle away

[rubberduck-vba/Rubberduck] qin-yin opened issue #3479: Fakes Verifier invocation count logic seems to be backwards

> I'm working on the most recent version of Rubberduck (`Rubberduck v2.1.1.2404-pre`) and I think I found an error in how `Verifier` checks the number of times a `Fake` was called. As an example, testing the two functions below:
```
Function AddExcitementWithInputBox() As String
AddExcitementWithInputBox = InputBox("Enter string to add excitement:") & "!!!"
End Function

Function AddExcitementWithoutInputBox(ByVal s As String) As String
AddExcitementWithoutInputBox = s & "!!!"

7:34 PM

[rubberduck-vba/Rubberduck] Hosch250 commented on issue #3479: Fakes Verifier invocation count logic seems to be backwards

> Looks like you are correct; copy/pasta programming at its finest :smile:

~.~ has Microsoft intentionally broken all their old links to make us use the new .NET API Browser...

@Duga wah, someone's using the fakes framework!

[rubberduck-vba/Rubberduck] retailcoder commented on issue #3479: Fakes Verifier invocation count logic seems to be backwards

> All pull requests welcome!

[rubberduck-vba/Rubberduck] retailcoder added label bug to issue #3479: Fakes Verifier invocation count logic seems to be backwards

[rubberduck-vba/Rubberduck] retailcoder added label up-for-grabs to issue #3479: Fakes Verifier invocation count logic seems to be backwards

[rubberduck-vba/Rubberduck] retailcoder added label good first issue to issue #3479: Fakes Verifier invocation count logic seems to be backwards

[rubberduck-vba/Rubberduck] retailcoder added label hacktoberfest to issue #3479: Fakes Verifier invocation count logic seems to be backwards

[rubberduck-vba/Rubberduck] retailcoder added label difficulty-01-duckling to issue #3479: Fakes Verifier invocation count logic seems to be backwards

[rubberduck-vba/Rubberduck] retailcoder added label feature-unit-testing to issue #3479: Fakes Verifier invocation count logic seems to be backwards

hmm, you think they noticed the easter eggs?

Which ones?

7:46 PM

those in the fakes framework

What are they?

IVerify, too, for one

there are others

mostly involving hackish attempts to mock the mocking

wow ... I think I even got the gist of the french troubleshooting ...

TFS is slower than snails.

@Vogel612 TL;DR: their Office install seems to be borked

7:57 PM

yup. I gathered as much.

and you were wondering how RD even managed to register and bind menus

correct

Like I said, reinstall Windows :P

that might actually fix it lol

8:16 PM

[rubberduck-vba/Rubberduck] qin-yin created pull request #3480: Fix Verifier Logic to merge qin-yin/Rubberduck/Fix-Verifier-Logic into rubberduck-vba/Rubberduck/next

> Closes #3479

well that was fast :)

        private bool IsEasterEgg(object value)
        {
            if (value.GetType() == typeof(AssertClass))
            {
                AssertHandler.OnAssertInconclusive(RubberduckUI.Assert_EasterEggAssertClassPassed);
                Asserted = true;
                return true;
            }

            if (value.GetType() == typeof(IVerify))
            {
                AssertHandler.OnAssertInconclusive(RubberduckUI.Assert_EasterEggIVerifyPassed);
                Asserted = true;
                return true;

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

[rubberduck-vba/Rubberduck] Hosch250 closed issue #3479: Fakes Verifier invocation count logic seems to be backwards

[rubberduck-vba/Rubberduck] Hosch250 merged pull request #3480: Fix Verifier Logic from qin-yin/Rubberduck/Fix-Verifier-Logic into rubberduck-vba/Rubberduck/next

[rubberduck-vba/Rubberduck] qin-yin pushed commit d3b24281 to next: Fix Verifier Logic

[rubberduck-vba/Rubberduck] retailcoder published prerelease Rubberduck-v2.1.1.2409

[rubberduck-vba/Rubberduck] retailcoder created tag Rubberduck-v2.1.1.2409

[rubberduck-vba/Rubberduck] build for commit 893470fa on next: AppVeyor build succeeded

8:39 PM

[rubberduck-vba/Rubberduck] retailcoder commented on pull request #3480: Fix Verifier Logic

> @qin-yin note that the AppVeyor build created a pre-release tag for it. Thanks a bunch!

@Duga @Mat'sMug He's probably running latest Next.

yeah

but he might not have known that his work/contribution is already released

OBTW, did you delete the tags for the preview releases with the "stable" release?

nope

would be pretty easy to script...

want me to?

do note that this makes the artifacts inaccessible..

8:49 PM

which tag(s) are we talking about?

GitHub release

@Vogel612 No big deal. If we need to, we can get that commit and build from there.

yeah I got that part. except "the tags for the preview releases with the "stable" release" doesn't parse.

Oh, when you released the stable.

why would I want to delete that tag?

oh

not the stable tag, but all the Rubberduck-v2.0.{...]-pre tags

8:53 PM

ah, yeah... maybe.... IDK, should we?

Housekeeping, I guess?

I suppose

it's not like we would encourage anyone to use these releases, given that 2.1.0 is out

true

go ahead then :)

[rubberduck-vba/Rubberduck] JlucBb commented on issue #3453: Rubberduck doesn't see anything yet and submenus are disabled

> Bonjour Mathieu,
je n'ai pas l'entrée que tu cites mais j(ai l'entrée 00020813-0000-0000-C000-000000000046 citée sur Stack Oferflow avec à la fois 1.7 et 1.8 (Office 2016 !) dans le registre. Je suis absent du travail jusqu'à Lundi. Je ferais le test en supprimant 1.8
Cdt

« first day (1230 days earlier) ← previous day next day → last day (1950 days later) »

Transcript for

Oct '1718

VBA Rubberducking

This chat has moved to Discord: discord.gg/MYX9RECenJ

antlr com-interop parsing rubberduck vb6 vba whiskey-tango-foxtrot

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC

site design / logo © 2024 Stack Exchange Inc; legal

mobile