VBA Rubberducking

Jelly

16:04

codeproject.com/Articles/363568/…

This is what I need

to hook events to commands

Jelly

16:17

I don't know why this has to be this complicated. You're basically writing more code then if you had written some code in the code behind.

Mat's Mug

hacking it up in code-behind is always an option, I suppose

Jelly

well...

i don't like code-behind because it is so difficult to test :(

solidworks makes it hard to test too

20s min for startup

IvenBach

@FreeMan Mines only 7 and I can't wait for her to move out on her own 11+ years from now.

Jelly

@Mat'sMug: if you model implements property notification, you don't need to rexpose its properties in the modelview?

i think its only needed when you have a dumb model that doesn't implement property notification, right?

Hosch250

@IvenBach She's that horrible?

Duga

16:25

[rubberduck-vba/Rubberduck] retailcoder closed issue #3218: Refactor|Rename only partially deals with labels

[rubberduck-vba/Rubberduck] retailcoder merged pull request #3237: RenameRefactoring of Labels and Enums from BZngr/Rubberduck/3218_RenameLabels into rubberduck-vba/Rubberduck/next

[rubberduck-vba/Rubberduck] retailcoder pushed commit 478dbcd4 to next: 3218 issue modifications for rename of Labels AND Enums (#3237)

puzzlepiece87

@Hosch250 Not necessarily, @IvenBach could be saying he has a strong preference for wink wink nudge nudge activity over having his daughter live at home? :P

Jelly

@puzzlepiece87: my room mates are not here for another week. It feels so nice!

Duga

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

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

[rubberduck-vba/Rubberduck] build for commit 478dbcd4 on next: AppVeyor build succeeded

Mat's Mug

@Jelly correct. just expose the model through a VM property and your view can bind to it

Jelly

ive seen people rexpose their model properties in the viewmodel and add property notification them.

puzzlepiece87

16:30

@Jelly I prefer having someone to say hello to even if we then retreat to our separate rooms :)

Jelly

perhaps the viewmodel should implement propertynotification for the model.

puzzlepiece87

@Jelly But then I always had good roommates.

Jelly

that may be a good thing.

@puzzlepiece87 : sometimes you need some quiet to get some stuff done

puzzlepiece87

@Jelly The only skirmish I ever had with a roommate was a mostly-silent, two day long war over the thermostat that ended with a compromise at 74F.

Jelly

C, man, please. :D

23.3333

boy that's bad.

74F may be nice if the weather is 107F outside

puzzlepiece87

16:33

@Jelly I'm probably unusually lucky (and I'm also partly deaf), but my aforementioned good roommates kept volume activities mostly confined to their spaces except on Thursday, Friday, and Saturday nights when it was welcome :)

Jelly

when wasthis?

puzzlepiece87

@Jelly What's your preferred temperature?

Jelly

26C.

puzzlepiece87

@Jelly We kept it the same temperature all the time.

Jelly

76F

puzzlepiece87

16:34

@Jelly My wife would agree with you :)

Jelly

Well, that's the standard temperature for human comfort.

puzzlepiece87

Also, there's no way 74F is 23.3C and 76F is 26C lol

Jelly

78.8

Sorry.

puzzlepiece87

Just googled it, yeah :)

Jelly

Freaking copy paste.

puzzlepiece87

16:35

You probably have already noticed but humans tend to vary quite a bit hahaha

And guys prefer colder temperatures on average

Jelly

My first roomate in Uni was an asshole, the second was a ghost (always studies never leaves the room) and their guy was a nice.

puzzlepiece87

I'm a massive dude myself, if I was living alone and money was no object I'd keep it at 70F/21C

Jelly

My fourth roomate was my cousin. Mistake of my life to rent with him.

puzzlepiece87

But I'm sure I'm substantially larger than you.

IvenBach

@Hosch250 The opposite. She listens and does what she's told. Puts her toys away, takes her dishes to the sink after eating (usually needs a reminder), folds her own laundry and puts it away, nearly always put her shoes in the rack.

Jelly

16:36

ok

How big are you?

Hosch250

#@&*(% TFS.

puzzlepiece87

193cm/118kg

Hosch250

Won't shelve my work, and won't cancel shelving my work.

Jelly

Jesus and Mohamed. You're big, man.

IvenBach

@puzzlepiece87 I've been married nearly 10 years and after that time all I'm left with are blue balls. So I take them outside and play with them at the part. Disclaimer: I juggle as a hobby and do have a blue set just so I can make that joke.

Hosch250

16:38

Same as my brother-in-law.

Jelly

I'm 180cm/95kg.

Hosch250

I'm stuck at 5'8, 5'9.

174cm.

Jelly

We have a shorty in the house.

lol

puzzlepiece87

@Jelly You're tall also :)

@Hosch250 is average lol, or at least for white American males

Hosch250

And I can't close VS because the dialog is open.

IvenBach

16:39

@Jelly BMI around 29?

Hosch250

Actually, I'm a little shorter than average.

Jelly

Yes.

puzzlepiece87

Sorry @Hosch250 :(

Jelly

That's overweight, right @IvenBach

@puzzlepiece87: do you play basketball?

puzzlepiece87

@Hosch250 Average white American height is estimated to be 5'9 last time I checked.

Jelly

16:40

193 is stupid tall here.

IvenBach

@puzzlepiece87 Something like that.

puzzlepiece87

@Jelly For fun, yes.

Hosch250

@puzzlepiece87 Average white male is 5'10, I think.

Jelly

That's cool.

I don't know basketball.

puzzlepiece87

@Hosch250 You are exactly right. en.wikipedia.org/wiki/List_of_average_human_height_worldwide

Jelly

16:41

You're a little shorter than Dennis Rodman

puzzlepiece87

@Jelly I'm slightly familiar with rugby and cricket.

Jelly

I don't know neither.

LOL

You thought I were English?

puzzlepiece87

@Hosch250 You are shorter than average, good call.

IvenBach

@Jelly I'm 182cm and 75kg. Last I recall that ammounted to BMI of 25 which is in the center of 'ideal' or 'optimal'.

Jelly

Haha

@puzzlepiece87: now I know you're American.

puzzlepiece87

16:44

@Jelly I was guessing Australian :)

IvenBach

@Jelly google.com/search?q=bmi puts you in the 'overweight' classification.

Jelly

@IvenBach: So I'm right.

IvenBach

Those scales are pretty on some levels...

Jelly

@puzzlepiece87: Man, I am myself. I should start a country.

Call it JellyLand

Motto: This place has nothing to do with "Jelly"

IvenBach

Can you lift your own weight IE pullup/pushup? If so don't worry about it.

Jelly

16:46

I think I can do a pushup.

I should do one now.

That was hard.

wow

IvenBach

List of average human height worldwide

Below are average adult human heights by country or geographical region. The original studies and sources should be consulted for details on methodology and the exact populations measured, surveyed, or considered. As with any statistical data, the accuracy of such data may be questionable for various reasons: Some studies may allow subjects to self-report values. Generally speaking, self-reported height tends to be taller than its measured height, although the overestimation of height depends on the reporting subject's height, age, gender and region. Test subjects may have been invited instead...

Hosch250

Last I tried, I could do 10 in a row. I'm losing a lot of strength since I started working.

My brother can do 200.

I've never been into pushups, and he does them every day.

I like biking/walking better.

IvenBach

@Hosch250 In a row? Without a break?

@Hosch250 I'm a big advocate of biking and swimming as excersize.

Hosch250

I think he takes a 15 minute break somewhere in there.

Used to ride my bike several hundred miles each summer.

And walk a mile and a half every day.

Jelly

I should go to the gym.

Prolly get a rottweiler too

Call it T.

Hosch250

16:51

I have a ~~shark~~ wild German Shepherd.

I like it because I'm a bit wild too, but my family thinks she has problems.

Well, they think I have problems too.

IvenBach

@puzzlepiece87 That's more than just a wee bit of human right there.

Everyone's got their own problems. So long as they don't adversely affect others its ok.

Jelly

German Shepherds are very skittish. Not a good dog to have around little children.

IvenBach

Back to C# In Depth for me

puzzlepiece87

Hosch250

@Jelly No they aren't.

Most of them are quite stable. It depends on the breeder, though.

Jelly

17:03

Maybe the wild ones are not.

But they're known for being skittish.

@puzzlepiece87 is that you?

Hosch250

Well, most of them are calm.

It's just that mine is kind of hyper and bouncy.

Mat's Mug

17:34

Let the framework do the hard work. Name your resources Foobar.resx for default, Foobar.en.resx for English, Foobar.en-UK.resx if you need "Color" and "Armor" to look like they have a typo, have Foobar.fr.resx for French translations, etc. Then you just set the resources' Culture as appropriate (you'll need to make a CultureInfo instance from the selected string), and re-assign the .Text values. You never really need to fetch a specific language from resources - the framework does it for you. — Mat's Mug 28 secs ago

Hosch250

@Mat'sMug en-US.

Mat's Mug

US spelling isn't "colour"/"armour"

AFAIK

and having file.en.resx will match en-AU and en-CA

Hosch250

@Mat'sMug No, en-US is the default English.

I don't think .en.resx will work.

Mat's Mug

that depends on whether AssemblyInfo.cs says that

Hosch250

Oh. Hmm.

@Mat'sMug So, which will it use if there is a conflict?

Mat's Mug

17:42

there is no conflict

Hosch250

Oh, right. I'm getting muddled.

Mat's Mug

oh, you mean if default is en-US and there's an en-US resource file and a default one?

I'd guess the most explicit culture takes precedence

so if culture is en-US, I presume foo.en-US.resx, then foo.en.resx, then foo.resx

Hosch250

Probably.

Mat's Mug

so a key could be missing from foo.en-US.resx but still end up being found in foo.resx

Brandon Barney

17:58

I think I just discovered my favorite PivotTable property...PivotTable.MDX.

puzzlepiece87

18:11

@Jelly That's Gulliver, technically ;)

Mat's Mug

Dim iRng As Range
Dim Rng1 As Range
Dim Rng2 As Range
Dim Rng3 As Range
Dim NewRng1 As Range

shudders

IvenBach

^ That deserves a virtual star

Where'd you see that?

Mat's Mug

0

Q: Find Furthest Number from 0 within Dynamic Ranges VBA

I have an excel workbook where there is a maximum of 6 data sets but the length or amount of data within the data set is variable/dynamic. I want to be able to find the furthest value from 0 within all of the A-Axis_Disp Columns (see image below). I think I am on the right track with my code but ...

Dim val As Variant

quite a gem

Duga

18:43

[rubberduck-vba/Rubberduck] BZngr opened issue #3238: Parser does not find hidden EnumerationMember references

> When the declaration of EnumerationMember `[_Last]` is selected (e.g., to rename), the usage/reference in `MsgBox CStr(FruitType.[_Last])` is not discovered/listed as a reference.

```
Option Explicit

Public Enum FruitType
[_First] = 1
Apple = 1
Orange = 2
Plum = 3
[_Last] = 3
End Enum

Sub DoSomething()
MsgBox CStr(FruitType.[_Last])
End Sub
```

Mat's Mug

@Duga I presume [_Last] gets parsed as a bracketed identifier

shadowofsilicon

@Hosch250 I have a Labrador / German Shepherd mix. Awesome dog, just gets super-excited when you mention “walk."

Mat's Mug

ugh, the context selection bar is borked

and now I realize how much I've come to rely on it

Hosch250

So does mine. She runs in circles and screams.

And she gives me a kiss when I leave in the morning and a hug when I get home.

shadowofsilicon

Mine sits on my bed all day then races down the stairs when it hears the door open when I get home.

If he knows I’m going to work he’ll be chill in the morning… but if I don’t put a work shirt on before I start putting shoes on, he’ll get super excited because he thinks he might get a ride in the truck.

Hosch250

19:14

I had mine for about 5.5 years before I started going to work, so she doesn't understand why I leave her all the time now.

She sits at the top of the stairs and watches me get ready.

shadowofsilicon

Be happy that you’re not leaving for week(s) at a time. Only downside to my traveling job. I’ve left him with a friend a few times who says he just mopes the entire time I’m gone. :(

Hosch250

Take him with.

Remoting into work is not fun. Next week, I'm going to bring my laptop home.

shadowofsilicon

Fly him across the country to leave him locked in a hotel room while I go into a snack food plant for 12 hours? Not an option.

Hosch250

19:55

My brain is falling apart.

I've not been sleeping the greatest, so the not-so-hot JS I'm working with is making my head spin.

Will somebody please abduct our idiot Schnauzer? I hate his guts. He screams all day long.

puzzlepiece87

20:08

Sedatives in his food :P

Hosch250

I don't feed them.

I'm ready to wring his neck.

Oh my gosh. Assigning a variable to itself...

puzzlepiece87

RIP Hosch's Schnauzer

He was a Good Boy

Hosch250

Definitely not. He is a BAD boy.

Jelly

sup

Hosch250

Just thinking about UI design.

Some people like to disable elements, but leave them visible so users know they can use them.

I like to only display what is currently available.

It keeps the UI a little cleaner to have less on it at a time.

Jelly

20:19

what u designing?

Hosch250

Nothing. I'm refining a sort of thing for my business.

Jelly

U got a business going on!

Hosch250

My employer.

I'm not the owner.

Jelly

why would you hide ui elements if disabling them is enough?

Hosch250

It makes the UI cleaner.

Jelly

20:25

hm

is it mvvm?

Hosch250

Instead of 5 things to distract the user, you get 3 or 4.

No, ASP.NET.

Although it is being written like plain HTML/JS/CSS...

Jelly

you still do mvvm there right?

Mat's Mug

more likely MVC

Hosch250

You can, yes.

We are using KnockoutJS, which lets us do MVVM in JS...

Jelly

thats out of my league for the moment have at hoss

after xaml mvvvm im moving into the world of aspnet

Hosch250

20:27

C'est horrible.

Jelly

been long overdue

Oh. I don't speak French, Sorry.

I only speak Québécois.

what don't you like? the loose typing ?

Mat's Mug

@Jelly bwahaha, right ;-)

Jelly

Je te jure.

Je ne parlerai au futur que Québécois.

shadowofsilicon

I like the idea of keeping the UI cleaner, but more importantly, consider the end user of the program and the context in which the disabling takes place. If the reasonable possibility exists that the user might be looking for that item even though it is disabled, consider not hiding it.

Jelly

Le français de la france a plien d'anglicisme.

Mat's Mug

20:31

fr-QC is loaded with them too

Jelly

Ya une certaine authenticité que le francais québecois a su préserver.

Mat's Mug

there's no "grille-pain" in fr-QC. we only have "toasters"

Jelly

Well, that's daily jargon.

I mean formel.

You can't write an essay and say "J'ai achéte un toster pour noel"

Mat's Mug

oh, the "international French" is utter BS - only people on TV speak it!

Jelly

And the workplace?

Mat's Mug

20:33

Frenglish

Jelly

jesus

that'll do my head in

Trudeau speaks the formel i assume?

Mat's Mug

I suppose

Hosch250

The loose typing is horrid, but the syntax HTML side gets icky pretty quick too.

Jelly

what i don't abt aspnet

is the mixing between cs and html

can't they just invent a layer over html that is pure cs

Mat's Mug

the job of the cs server code is ultimately to generate HTML..

Jelly

20:39

but those view or partial views

are in html and cs

in mvc

Mat's Mug

hmm, is RAZR only for MVC?

I don't do web much

and when I do, I do MVC

WebForms has been obsolete since ASP.NET MVC came along

Jelly

ive watched a couple of courses

i don't know abt razor being only for mvc

Mat's Mug

it's a view engine.. I think it's MVC-land

Jelly

91

Q: Is it possible to use Razor View Engine outside asp.net

If I look at the Razor View Engine, then I see a very nice and concise syntax that is not particularly tied to generating html. So I wonder, how easy would it be to use the engine outside asp.net in a "normal" .net environment for example to generate text, code,... Any pointer, example, comment...

asp.net asp.net-mvc code-generation templating razor

its possible to used outside the app domain but it looks like a crazy hack

Mat's Mug

MVC is built on top of ASP.NET, so it makes sense that there's a way to hack it up

puzzlepiece87

20:44

FileSystemObject is changing my life right now. I've been manually finding paths, directories, file names, and extensions for years and I feel like a huge fool.

Mat's Mug

@puzzlepiece87 happened to all of us at one point or another ;-)

Jelly

FileSystemObject is wayyyyyyyyyyy better between that Dir

Mat's Mug

"way better than"

Jelly

sorry

My fingers are slower than my brain

i do hope that i m being understood

puzzlepiece87

You are :)

Jelly

20:48

hold

ill put a cent in the grammar jar for every mistake

i'll make

soon enough, your gofundme campaign, will fully funded.

Ugh

Mat's Mug

it's pretty much stalling ATM

Jelly

that's one cent.

You need to advertise it on SO.

Mat's Mug

I'm not doing that

I won't spam SO with gofundme links

and won't beg RD users to donate either

Jelly

Hm.

I'm not sure you're going to be "spamming".

Mat's Mug

I can put a link in the RD about box though

Jelly

20:54

It's an advert that you pay for.

Not sure how you consider that to be spam?

Mat's Mug

I'm not paying for anything RD other than the web hosting + domains

Jelly

OK, man. I was just making a suggestion.

shadowofsilicon

Is / will there be a link on the RD website?

Mat's Mug

RD-Web needs to be updated.. and yeah that would be a good place to have it :)

puzzlepiece87

Also, it is rare for donations to work

Mat's Mug

20:58

heck, I emailed a link to the swag form to the donors that spent $100+, and got 0 returned so far

puzzlepiece87

I didn't fill mine out on purpose

shadowofsilicon

A little “Thank our contributors” blurb that shows when RD is downloaded… then release RD 2.1 - the donations will come in.

puzzlepiece87

I felt like we should wait and see how we did

I didn't need any swag, and I wanted you to have enough money for everything :)

Mat's Mug

=)

Duga

[rubberduck-vba/Rubberduck] web-flow pushed commit 596677f5 to next

Update README.md

added GoFundMe link

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

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

[rubberduck-vba/Rubberduck] build for commit 596677f5 on next: AppVeyor build succeeded

[rubberduck-vba/Rubberduck] retailcoder deleted tag Rubberduck-v2.1.2036

Jelly

21:17

bye

Mat's Mug

later!

shadowofsilicon

@Mat’sMug I could use a little help… is it possible to get a CodeExplorerProjectViewModel in a unit test?

Duga

[rubberduck-vba/Rubberduck] retailcoder opened issue #3239: We need a "Contributing.md" file

> The wiki is a good starting point, but an actual `Contributing.md` file would be ideal:

https://opensource.guide/starting-a-project/#writing-your-contributing-guidelines

[rubberduck-vba/Rubberduck] retailcoder added label meta to issue #3239: We need a "Contributing.md" file

Mat's Mug

@shadowofsilicon I would think so...

@Hosch250 did that whole part though

Hosch250

Yup.

See the code explorer tests.

shadowofsilicon

21:26

After a quick glance, I don’t see that it makes a new Project VM anywhere in CodeExplorerTests.cs

Mat's Mug

wouldn't creating the CodeExplorerVM do it?

shadowofsilicon

It might.

It should. I might have it figured out

IvenBach

@puzzlepiece87 msdn.microsoft.com/en-us/vba/excel-vba/articles/… was one that made me very glad to understand how to use properly.

shadowofsilicon

In my head, that is...

Tobi

What FPS do you get > pucky.herokuapp.com

shadowofsilicon

21:35

Yes, yes…. oh duh, I see how it works now...

Mat's Mug

hi @Tobi, welcome to Rubberduck's war room. just FYI, popping in here and dropping a random link out of nowhere isn't very... what's the word... appropriate?

Tobi

oh just asking

what did you get, mug?

Mat's Mug

I'm at work, I'm not clicking random links :)

IvenBach

@Tobi This is the war-pond of RD. If you need any help with it we're glad to assist.

@Mat'sMug forums.manning.com/posts/list/31746.page

Mat's Mug

2 mins ago, by Mat's Mug

I'm at work, I'm not clicking random links :)

IvenBach

21:40

Seems someone's a bit enamoured with Skeet.

Tobi

whats warpondRD?

IvenBach

RD = rubberduck addin

Mat's Mug

@Tobi github.com/rubberduck-vba/Rubberduck

Tobi

i think i should leave

Mat's Mug

an open-source project we're building

IvenBach

21:42

war-pond is a duck themed edit to this being our war room. Top right ^>

Tobi

i cant tell if this is legit or not

Mat's Mug

what do you mean?

anyway, TTQW

puzzlepiece87

22:15

@IvenBach Seems similar to the Application.GetOpenFileName I use already but with a few additional advantages, thanks!

ThunderFrame

@Jelly I'm 6'6"/199cm and 98Kg/216lbs - We have a tally in the house.

@IvenBach I had a workbook the other day that used a FileDialog control on a worksheet, which must have been from Excel 97 or something. It was just about impossible to delete the control and remove the TLB reference. I don't even know what I did to finally remove it, but all the random crashes have gone away.

shadowofsilicon

Question: Can a VB project exist that is empty of any VBComponents?

puzzlepiece87

@ThunderFrame Do you run for exercise?

Or maybe swim?

Running and swimming are the only exercise regimens I know to be in as good of shape as you are, you're like Jim Comey lite lol

Duga

22:32

[rubberduck-vba/Rubberduck] Vogel612 assigned Vogel612 to issue #3239: We need a "Contributing.md" file

IvenBach

@ThunderFrame Indeed has a thunderous frame of a body...

puzzlepiece87

I'm not sure I'd describe a reed as thunderous.

But it's good for his health, which is better :P

Duga

[rubberduck-vba/Rubberduck] Vogel612 commented on issue #3239: We need a "Contributing.md" file

> I'll drop a first draft of a CONTRIBUTING.md into the war room after this weekend. If anybody wants a quicker first draft, they're welcome to join,

I'll follow along [this "tutorial"](https://mozillascience.github.io/working-open-workshop/contributing/) linked from retailcoder's reference

IvenBach

Either way he's much larger than I am.

I got lucky since my dads barely 5'6" and shrinking. I'm a head taller than everyone in my family and they all have to look up to me.

ThunderFrame

@IvenBach I have some colleagues to whom I look down at, even when I'm sitting and physically looking up at them ;-P

IvenBach

22:45

That is a good use of wordage right there.

ThunderFrame

@puzzlepiece87 What is this "exercise" of which you speak?

IvenBach

I don't think he know you only get so meany heartbeats and exercising uses them up needlessly.

Duga

[rubberduck-vba/Rubberduck] ThunderFrame commented on issue #3238: Parser does not find hidden EnumerationMember references

> Indeed, using an enum member in an expression, results in the member being identified as a runtime expression, or unrecognized. There's also a resolver bug with naming conflicts, and it's impossible to rename an enum member and retain the leading underscore (I'll raise separate issues):

```vb
Public Enum FoodType
Apple = 4
Orange = 5
Plum = 3
End Enum

Public Enum FruitType
[_First] = 1
Apple = 1
Orange = 2
Plum = [FoodType].[Plum] 'These are identified as Enum and

ThunderFrame

Gym? What's a Gym?

►

IvenBach

oh a Gym

puzzlepiece87

22:52

@ThunderFrame Man, you must have the world's greatest metabolism. I'm jealous :)

ThunderFrame

@puzzlepiece87 3 racks of pork ribs and fries for dinner. Life is good.

Duga

23:12

[rubberduck-vba/Rubberduck] retailcoder added label parse-tree-processing to issue #3238: Parser does not find hidden EnumerationMember references

[rubberduck-vba/Rubberduck] retailcoder added label bug to issue #3238: Parser does not find hidden EnumerationMember references

[rubberduck-vba/Rubberduck] retailcoder commented on issue #3238: Parser does not find hidden EnumerationMember references

> @ThunderFrame unrecognized tokens, as in unresolved?

[rubberduck-vba/Rubberduck] ThunderFrame commented on issue #3238: Parser does not find hidden EnumerationMember references

> yep - as in RD toolbar doesn't know what to make of them.

Mat's Mug

@Duga RD toolbar doesn't do shit ATM

Duga

[rubberduck-vba/Rubberduck] ThunderFrame added label bug to issue #3240: enum expressions that refer to enum members with naming conflicts, are incorrectly resolved

[rubberduck-vba/Rubberduck] ThunderFrame added label parse-tree-processing to issue #3240: enum expressions that refer to enum members with naming conflicts, are incorrectly resolved

ThunderFrame

@Mat'sMug Does for me - I pulled yesterday, IIRC

Duga

[rubberduck-vba/Rubberduck] ThunderFrame opened issue #3240: enum expressions that refer to enum members with naming conflicts, are incorrectly resolved

> In the code below, `Apple` and `Orange` are defined in 2 different enums, and the second enum uses `Apple` and `Orange` in expressions. Rubberduck incorrectly resolves `Apple` and `Orange` as being members of `FoorType`, whereas VBA treats them as members of `FrutitType`...

```
Public Enum FoodType
Apple = 4
Orange = 5
Plum = 3
End Enum

Public Enum FruitType
[_First] = 1
Apple = 1
Orange = 2
Applorange = Apple Or Orange 'VBA's resolved value is 3, but in RD, Apple

Mat's Mug

@Duga ha, that's a nice one.

although, same-name enum memberd in different enum types should probably be an inspection result

shadowofsilicon

23:22

@Mat’sMug Do you know if, in the world of VBA, can a VBProject be empty with no VBComponents inside it?

Duga

[rubberduck-vba/Rubberduck] ThunderFrame edited issue #3240: enum expressions that refer to enum members with naming conflicts, are incorrectly resolved

[rubberduck-vba/Rubberduck] NDeLancie opened issue #3241: Parse Error (System.OutOfMemoryException) in RD 2.1.0.29597

> I've just installed RD 2.1.0.29597 on a Windows 7 Enterprise x64 with Office 2010 Professional Plus x86 (no complaints on installation), and am working in Word's VBA IDE. Word has multiple projects installed (most of which are not mine and locked to me).

Parsing often takes a seemingly endless amount of time, often resulting in both Word and the VBA IDE windows going white, or only showing frame outlines with no contents, or alternating between the two, and "(Not Responding)", and sometime

Mat's Mug

@shadowofsilicon assume it can. IIRC PowerPoint projects don't have document modules and an empty project wouldn't have a module

If not VBA, a VB6 project could.

Duga

[rubberduck-vba/Rubberduck] ThunderFrame added label bug to issue #3242: RD won't allow a rename of an enum member with otherwise illegal characters.

[rubberduck-vba/Rubberduck] ThunderFrame added label feature-refactorings to issue #3242: RD won't allow a rename of an enum member with otherwise illegal characters.

[rubberduck-vba/Rubberduck] ThunderFrame opened issue #3242: RD won't allow a rename of an enum member with otherwise illegal characters.

> Standard naming rules don't apply to enum members (or enums themselves), this code is perfectly legal (but might be worthy of an inspection). At the very least, a leading underscore should be permitted in order to take advantage of the hidden enum member feature.

```vb
Enum Foo
Apple = 1
[_Min] = 1
[`~!@#$%^&*()-_+=[']\/?{}|<>,.;:"] = 3
End Enum
```

A more difficult issue relates to the name of an enum, as per #2568, where special characters are also allowed, but the VBE pret

ThunderFrame

@shadowofsilicon PowerPoint, by default, doesn't have any vbComponents.

same with Access

shadowofsilicon

@ThunderFrame What does the CodeExplorer do in PowerPoint or Access with a empty project? Does it not show a Project object? Cause that’s what it looks like to me by working on these unit tests

I build a mock VBE with a empty project in it, but the CodeExplorerViewModel returns 0 for CodeExplorerViewModel.Projects.Count

wtf, Code Explorer in PowerPoint shows an empty VBAProject

ThunderFrame

23:40

@shadowofsilicon hmm, I can't get RD off pending with an empty PPT project

oh wait, I'm using 2.0.13 at work

SlowLearner

@FreeMan LOL - helps tremendously, that's going to keep me going all day!

shadowofsilicon

Oh, now I see wtf is going on. Grr...

Duga

[rubberduck-vba/Rubberduck] Vogel612 commented on issue #3242: RD won't allow a rename of an enum member with otherwise illegal characters.

> We really need a "WTF VBA?" tag

3

[rubberduck-vba/Rubberduck] Vogel612 added label parse-tree-processing to issue #3241: Parse Error (System.OutOfMemoryException) in RD 2.1.0.29597

[rubberduck-vba/Rubberduck] Vogel612 added label support to issue #3241: Parse Error (System.OutOfMemoryException) in RD 2.1.0.29597

[rubberduck-vba/Rubberduck] Vogel612 commented on issue #3241: Parse Error (System.OutOfMemoryException) in RD 2.1.0.29597

> Would you mind sharing your system specs? Specifically RAM and CPU data would be something that might get us started. How much code are you attempting to parse with Rubberduck?

Do note that there might be no really nice way to resolve this. In general programs are a tradeoff between speed and memory. Rubberduck extensively uses Optimizations that cost memory. As such parsing large projects with little RAM is difficult, if not outright impossible for Rubberduck right now...

SlowLearner

@ThunderFrame RD falsely accused, turned out to be fat fingers... omg x6 - hangs head in shame

Transcript for