VBA Rubberducking

ThunderFrame

00:00

but our next census is recording identifiable information with responses, so get ready for some useless statistics

Hosch250

LOL.

@ThunderFrame Sounds dangerous.

Duga

RELOAD!

Hosch250

Maybe not right now, but the instance that information gets into the wrong hands... Good luck!

Duga

[Hosch250/Rubberduck] 21 commits. 6042 additions. 665 deletions.

[rubberduck-vba/Rubberduck] 15 commits. 5 closed issues. 6 issue comments. 3711 additions. 129 deletions.

[Vogel612/TranslationHelper\‌] 6 commits. 548 additions. 228 deletions.

[Zomis/Monopoly] 3 opened issues.

Comintern

Stupid Google connection problem. Using Bing makes me feel dirty.

@Hosch250 Case in point: ibmandtheholocaust.com

ThunderFrame

00:04

It's jarring going from Google to Bing. Not only the layout, but the quality of the results

Hosch250

I like Bing.

Prepares for a battle to the death

Comintern

Ever wonder how they can give out gift cards for their advertisers?

Hosch250

Ads?

Oh, I don't mind ads--I just use adblocker.

And I suppose they are collecting my information anyway.

At least, AFAIK, they weren't stealing my internet connection password and such, like Google.

ThunderFrame

I thought that was standard Windows 10 behavior, Bing or no Bing

theregister.co.uk/2015/06/30/windows_10_wi_fi_sense

Hosch250

Yeah, I always wondered about that.

I always disable that right away.

ThunderFrame

00:10

I forgot my Win7 Admin password for an old box - didn't realize how easy it was to reset the password with only a Win7 DVD.

Comintern

Although in fairness, Bing has the Wikipedia disambiguation page for Amazon on the first page. Google doesn't have it in the first 10 pages.

@ThunderFrame It's easier with a Linux live CD.

ThunderFrame

Now I can start a command prompt by pressing shift 5 times at the login screen

I also misplaced my Visual Studio 6 Key, and found that 111-1111111 works just fine

Comintern

Was that authenticated online? I can't remember.

Hosch250

Bother.

I thought I could maybe inject a refactoring dialog factory into the commands so I could test them.

So, Encapsulate Field does not have an empty ctor--it takes the indenter and the parser state.

I figured I could move the indenter into the model and just pass the model to the view through a property.

Turns out, I can't get the real model assignment to fire when I assign it.

That wouldn't be a problem, except I recalculate some other properties after setting the model.

On the other hand, I could move those properties from the view to the model, and perhaps even save myself some double calculations.

SlowLearner

@ThunderFrame Really? OMG that's so fuggn WRONG >:[

ThunderFrame

00:19

@Comintern - No, VB6 was still before Bill's internet epiphany. The key just needs to have sum of first 3 digits mod 3 = 0, and sum of last 7 digits mod 7 = 0.

Comintern

Wow, that's some hard-core NSA level encryption.

2

ThunderFrame

yeah, not quite this

Comintern

Woah. At least it's easy to remember... Kinda like 911 or 999.

Quack Exchange

0

Q: VBA Function that returns color RBG code of a referenced cell

new to this part of the site so sorry if my formatting is not correct Here's my question - I have this function I'm building to return the RBG code of a cell I input. The code "works" but something funny is going on. If I write multiple functions each referencing different cells, then all the ...

ThunderFrame

Well, Nixon did have that memory problem, right?

3

Hosch250

00:30

Eh, still didn't work. I can't just bind directly to the UI.

That's on my list for 2.1 after the UI's get redone.

I'm out now.

Comintern

00:44

@ThunderFrame - You might want to mention on VBA Function that returns color RBG code of a referenced cell that there's a possible bug - Ranges with multiple cells will return 0/0/0 unless the .Interior.Color of all the cells match.

ThunderFrame

00:55

good spot

Comintern

Comes from getting burned on innumerable occasions.

ThunderFrame

04:07

This is StackExchange, we don't actually write code, we get inspiration from other's... — ThunderFrame 26 mins ago

Comintern

How in the hell did this get approved? stackoverflow.com/documentation/improvement-requests/view/4129/…

ThunderFrame

04:29

deleted for review

Comintern

Approved. The reviewer had a total of 0 activity in any VBA related tag. WTF?

ThunderFrame

The reviewer had a total of 0 competency in any ~~VBA related~~ tag. WTF?

Comintern

LOL! <sarcasm>Good thing the SO staff is on top resolving the permission problems.</sarcasm>

ThunderFrame

04:51

@Comintern augmented your $ functions

also found this books.google.com.au/…

> Authors Leonhard and Chen found these [72 undocumented Word Basic] commands the way much of the book was discovered: They actually tested every possible use of every command and noted the results.

Comintern

Wow - 1993.

I had actually no idea the RightB and LeftB even existed until fairly recently.

ThunderFrame

I had no idea I could still use Word Basic in Office 2013

Comintern

And... they're missing in the RD inspection.

ThunderFrame

CreateObject("Word.Basic")

Comintern

No shit?

ThunderFrame

05:01

If I could find the library and early-bind it I might remember some of the commands

Comintern

Mind. Blown.

ThunderFrame

gotta give points to MS for backward compatability

This post, somewhere deep-down, uses Excel4 macros to store a pointer to the Ribbon so that VBA survives a reset and can regain a handle to the ribbon

Comintern

WTH did the list of functions for the ImplicitVariantReturnTypeInspection go? I know I've run across it before...

Quack Exchange

09:22

2

Q: Excel VBA used to fetch Access Data, slow

I am using the following VBA to fetch data from an Access database. The query works but there is a lot of information in the database and the response time is very slow, about 30 seconds. Is there any part of the code that I could optimise or write differently? Sub test() Dim strsql1, tr As St...

vba excel ms-access

Duga

12:39

[rubberduck-vba/Rubberduck] ThunderFrame commented on issue #2147: Excel hard crash

> I've just rebuilt my PC. installed Office 2013 32-bit, then VS 2013, then pulled from next and built (including registry and regasm).

When opening Excel's VBE, I get a hard crash every time. When I look in the Rubberduck directory I see there are logs, but **there isn't a config file**.

I can open Word's VBE with only a soft-crash (the VBE is still usable even though Windows said it crashed), and I can open the settings Window, which I reset, navigate around without changing anything and

Duga

12:52

[rubberduck-vba/Rubberduck] ThunderFrame opened issue #2155: Indenter sample in settings should have height scale with window.

> Look at the default Settings window size on a 1080p monitor
![settings1](https://cloud.githubusercontent.com/assets/16574009/17212955/56fc1838-5515-11e6-96c7-5318ecf61c7d.png)

Look at the same window expanded in height to nearly 1080px. Notice the indenter sample procedure text is not scaling, and not relative to the setting-controls at the top.
![settings2](https://cloud.githubusercontent.com/assets/16574009/17212959/5abbc59a-5515-11e6-9d28-4e3dc6042cea.png)

ThunderFrame

woot! - I have a working rubberducky again.

Comintern

13:04

@ThunderFrame - It shouldn't strictly need a config file unless there were settings added that didn't get initialized in the defaults. Can you post the log from windows error reporting?

Duga

13:15

[rubberduck-vba/Rubberduck] ThunderFrame commented on issue #2147: Excel hard crash

> Application: EXCEL.EXE
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.NullReferenceException
at Rubberduck.Inspections.UseMeaningfulNameInspection.GetInspectionResults()
at DynamicClass.(System.Object, System.Object[])
at Ninject.Extensions.Interception.Injection.Dynamic.DynamicMethodInjector.Invoke(System.Object, System.Object[])
at Ninject.Extensions.Interception.Invocation.Invocation.CallTargetMe

[rubberduck-vba/Rubberduck] retailcoder commented on issue #2155: Indenter sample in settings should have height scale with window.

> Hmm you're supposed to drag the splitter up to make the indenter preview box taller... I guess it could be automated somehow with some anchoring.

Mat's Mug

@Comintern it's in your original issue.. search for "Mid$" in the repo/issues, there's not many hits ;-)

> Unlike other functions, Now, Date, and Time don't require any parentheses.

...maybe that's because they're not functions.......

Comintern

13:34

@Mat'sMug - Thanks - got it. Just wanted to check to make sure LeftB and RightB were in there. They aren't triggering the inspection.

ThunderFrame

ahem, @Mat'sMug, I just edited your edit of fixed length strings

Quack Exchange

1

Q: Validating FileSystem Structure

I have a File System. It is *supposed* to be laid out / used / added to in certain ways. This is a program to report on the *actual* state of the file system versus what it's supposed to be. In particular, pick out unexpected folders and (eventually) validate that Client Folder Names follow a ...

vba file-system file-structure

Duga

[rubberduck-vba/Rubberduck] ThunderFrame commented on issue #2147: Excel hard crash

> FWIW, I wonder if the different behavior in Word is because there is always a template plus the host document, so there are 2 projects for RD to parse. Or maybe Word is just more resilient?

Mat's Mug

@ThunderFrame perhaps the example would be better if it showed a UDT being written to a binary file

Comintern

@Duga Word is more resilient than Excel?

Mat's Mug

13:44

@ThunderFrame gah, mine and MacroMan's got intertwined somehow

Comintern

myNow sees like an odd variable name...

Mat's Mug

sees, and looks too

and seems as well ;-)

Duga

14:08

[rubberduck-vba/Rubberduck] daFreeMan commented on issue #2135: Hot keys on all RD UI

> Great, thanks @Hosch250!

FreeMan

I just installed 2.0.7 on the new machine. Opening Excel VBE, I get:

Comintern

#2147?

FreeMan

I have .NET 4.5.2 (~~I believe~~ confirmed) installed, but no other versions of .NET. Is that the issue?

Mat's Mug

stackoverflow.com/documentation/proposed/changes/…

^^ worth rejecting? doesn't say much imo

FreeMan

Doesn't say much about why you'd want a class vs procedure module

Comintern

14:22

Yeah, I think so.

Can one of you approve (or both of you reject) stackoverflow.com/documentation/proposed/changes/64152? I made enough changes that I'm getting scripting lockups and errors when I try to edit more of it.

Only got about half way through though.

FreeMan

Oddly enough, after hitting OK on the error above, RD does load, and I get this:

with space for the RD menu item, and the RD tool bar, but no actual RD menu item

Comintern

WTF?

FreeMan

@Comintern, @me?

Comintern

At your screenshot.

FreeMan

Yeah, that's what I thought.

Comintern

14:29

The error dialog you get is a COM Interop error - My guess is that RD either tried to load the menu before Excel was ready or Excel was doing something that blocked the COM call.

FreeMan

But wait, there's more!

all the menu items with submenus are blank, yet functional!

Comintern

@FreeMan Shhh... those are the secret menu items.

FreeMan

d'oh!

Mat's Mug

What's your locale?

FreeMan

Indiana.

:) should be EN-US

Comintern

14:35

You don't get a your own locale because of the daylight savings time thing? Like EN-IN?

Mat's Mug

Something broke in ParentMenuItem

lol

FreeMan

actually, they're not so functional. :( selecting Rename doesn't do anything...

@Comintern we used to, and (EST - Indiana) is still in most products, but we finally decided to join the early 20th century about 7-8 years ago, and now switch between ST & DT like most of the rest of the world.

I usually pick US-NY or US-ET, and leave the IN out of it.

which got me thinking - machine was freshly imaged, what did they select?

Yup, (UTC-05:00) Eastern Time (US & Canadeh)

Comintern

I didn't realize that - haven't been to IN in years. I guess it's down to just Arizona now.

FreeMan

and, Excel crashed. :(

I think HI doesn't switch, either. but they tend to get a lot of sunshine in both those states anyway.

Comintern

@Mat'sMug ...and approved.

FreeMan

14:40

do I need an older version of .NET? (or newer?)

Comintern

@FreeMan I don't think it's a .NET version problem. IIR, that's how my VM is set up.

FreeMan

OK, just my first thought.

uninstalled 2.0.7 & reinstalled. Same issue.

Made a couple of changes to the indenter settings and lookie!

Also, RD is not launching a parse when I first open the VBE - I have to manually kick it off.

Guess I should be documenting all this in an issue, eh?

9 mins ago, by FreeMan

and, Excel crashed. :(

Duga

15:00

[rubberduck-vba/Rubberduck] daFreeMan opened issue #2156: COM Interop error on VBE launch

> After a fresh rebuild of my machine (using the corporate image of Win7x64), I'm getting a COM Interop error when launching the VBE from Excel:
![rd](https://cloud.githubusercontent.com/assets/11889733/17217093/2b1fc426-54b1-11e6-84b2-81c159c06ee9.PNG)
After clicking the `OK` button, the VBE does launch, and I get this:
![rd1](https://cloud.githubusercontent.com/assets/11889733/17217171/69ebd8c0-54b1-11e6-8441-959cfce62dde.PNG)
Note that the RD menu is missing, and that RD has _not_ launche

Duga

16:08

[Hosch250/Rubberduck] Hosch250 created branch settingsBug

[Hosch250/Rubberduck] Hosch250 pushed commit d931a6dd to settingsBug: Fix a couple settings UI bugs

Hosch250

Thanks, @Mat'sMug!

Duga

[Hosch250/Rubberduck] build for commit d931a6dd on settingsBug: AppVeyor build succeeded

Mat's Mug

@Hosch250 np. I had to show up at work with the kids lol

Hosch250

What'd they think?

Quack Exchange

1

Q: Converting a range in excel to a single column with excel vba

I am very new to coding and know only the basics. The first part of this code is running fine. It converts a range of values to a single column. However, with my data set the rows of data step down, as shown in the sample data set below, so that when they are converted to a single column there...

performance vba excel

Duga

16:21

[rubberduck-vba/Rubberduck] Hosch250 created pull request #2157: Fix a couple settings UI bugs to merge Hosch250/Rubberduck/settingsBug into rubberduck-vba/Rubberduck/next

Hosch250

@Mat'sMug Got anything in particular you'd like done today/tomorrow?

Mat's Mug

@Hosch250 eh, 80% of the staff is off, the rest were all "aaaaaw they're so cuuuuuuute!!"

Hosch250

Nice.

How old are they now?

Mat's Mug

4

Hosch250

I thought so, because you were talking about your three year old twins last year.

How's the one's crossed eyes doing?

Duga

16:23

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

Mat's Mug

Huh?

Hosch250

(I saw your comment/answer on Parenting.se.)

Mat's Mug

Ah, lol.. forgot about that haha

Hosch250

You said that one of them had to wear glasses because one of their eyes was weaker than the other and had a potential to go cross eyed, or something.

Mat's Mug

Now they both wear glasses hehe

Hosch250

16:24

Don't worry, I wasn't stalking you; I just happened on it.

Mat's Mug

@Hosch250 ideally I'd like next release to not..well, crash and burn :-)

Hosch250

Me too.

I'm not reproducing the access violation exception, so...

Duga

[rubberduck-vba/Rubberduck] Hosch250 merged pull request #2157: Fix a couple settings UI bugs from Hosch250/Rubberduck/settingsBug into rubberduck-vba/Rubberduck/next

[rubberduck-vba/Rubberduck] Hosch250 pushed commit d931a6dd to next: Fix a couple settings UI bugs

[rubberduck-vba/Rubberduck] web-flow pushed commit 21fbaecb to next

Merge pull request #2157 from Hosch250/settingsBug

Fix a couple settings UI bugs

Mat's Mug

Cool. I'm taking the kids back home, ttyl

Hosch250

Have fun.

Duga

16:27

[rubberduck-vba/Rubberduck] build for commit 21fbaecb on next: AppVeyor build succeeded

Duga

16:57

[rubberduck-vba/Rubberduck] Hosch250 commented on issue #2156: COM Interop error on VBE launch

> This is a failed launch, and if @retailcoder reviews and approves one of my PR's, RD will unload itself when catches the exception causing this.

[rubberduck-vba/Rubberduck] Hosch250 commented on issue #2130: 2.0.7 - Key not found in dictionary, RD error

> I reproduced this! We were attempting to remove a component from the cache that wasn't in the cache.

[rubberduck-vba/Rubberduck] Hosch250 added label bug to issue #2130: 2.0.7 - Key not found in dictionary, RD error

[rubberduck-vba/Rubberduck] Hosch250 assigned Hosch250 to issue #2130: 2.0.7 - Key not found in dictionary, RD error

[Hosch250/Rubberduck] Hosch250 created branch Issue2130

[Hosch250/Rubberduck] web-flow pushed commit 21fbaecb to Issue2130

Merge pull request #2157 from Hosch250/settingsBug

Fix a couple settings UI bugs

[Hosch250/Rubberduck] Hosch250 pushed commit 12878c3c to Issue2130: Close #2130

[rubberduck-vba/Rubberduck] Hosch250 created pull request #2158: Fix cache bug causing KeyNotFoundInDictionary exception to merge Hosch250/Rubberduck/Issue2130 into rubberduck-vba/Rubberduck/next

> Close #2130

Hosch250

@FreeMan That might help some of the crashes.

Duga

[Hosch250/Rubberduck] build for commit 12878c3c on Issue2130: AppVeyor build succeeded

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

[rubberduck-vba/Rubberduck] Hosch250 closed issue #2130: 2.0.7 - Key not found in dictionary, RD error

[rubberduck-vba/Rubberduck] Hosch250 merged pull request #2158: Fix cache bug causing KeyNotFoundInDictionary exception from Hosch250/Rubberduck/Issue2130 into rubberduck-vba/Rubberduck/next

[rubberduck-vba/Rubberduck] Hosch250 pushed commit 12878c3c to next: Close #2130

[rubberduck-vba/Rubberduck] web-flow pushed commit 9340a52c to next

Merge pull request #2158 from Hosch250/Issue2130

Fix cache bug causing KeyNotFoundInDictionary exception

FreeMan

17:14

@Duga Yay!!!

Duga

[rubberduck-vba/Rubberduck] build for commit 9340a52c on next: AppVeyor build succeeded

FreeMan

@Hosch250 I'm running Windoz Update right now - there were 15 updates for .NET. That may have something to do with 2156. I'll test it out again after the updates are complete and update the issue

Hosch250

Although. TBH, that didn't actually crash on me--it juts popped the errors.

No, that shouldn't matter at all.

FreeMan

Yeah - that wasn't related to the crash in particular, as far as I could tell. Just the error message.

Hosch250

Well, it might help, and it is one bug fixed, anyway.

Duga

17:20

[rubberduck-vba/Rubberduck] daFreeMan commented on issue #2147: Excel hard crash

> My machine was freshly imaged yesterday (Win7 x64), and I'm still getting the crash.

Here are the details from the 2 events that were recorded
~~~
Application: EXCEL.EXE
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: Rubberduck.Root.InterceptedException
Stack:
at System.Runtime.CompilerServices.AsyncMethodBuilderCore.<ThrowAsync>b__5(System.Object)
at System.Threading.QueueUserWorkItemCallback.WaitCallback_

FreeMan

I'll take all the might I can get at the moment!

Duga

[rubberduck-vba/Rubberduck] Hosch250 commented on issue #2147: Excel hard crash

> I don't suppose you could share the workbook at this point.

Duga

17:44

[rubberduck-vba/Rubberduck] daFreeMan commented on issue #2147: Excel hard crash

> Sadly, I'm no further along than I was on Tuesday evening - I spent all day yesterday waiting on the machine to be repaired...

Mat's Mug

Guys, can anyone verify this?

Const foo = "bar"

Now refer to foo in a procedure, place the cursor on foo and hit ctrl+i

Does the vbe deem it a string?

stackoverflow.com/documentation/proposed/changes/…

If not ^^^ then this edit is incorrect

Comintern

See my comment. I just approved it.

stackoverflow.com/documentation/proposed/changes/…

Hosch250

@Mat'sMug It just says 'foo = "bar"'

Mat's Mug

@Comintern TIL

Comintern

Makes 2 of us.

@Mat'sMug Are there any RD inspections I should test, or does RD always treat constants as literals?

FreeMan

17:59

well, the .NET updates didn't have an impact on #2156. There are several other fixes that need to be installed, we'll see if any of those take care of it.

This did only start today, and there are all sorts of changes on my machine, so my main thought is that something's borked at my end...

Comintern

Yup. RD reports that "Const 'Foo' is implicitly Variant"

Mat's Mug

@Comintern hmm they're constant expressions IIRC

@Comintern I feel like leaving it that way ;-)

Comintern

I like the implicit declaration warning, but how about changing Const's to say "Const 'Foo' is implicitly declared'

Or is there enough information at that point to distinguish Const's?

Hosch250

@Comintern Yes, there is.

var issues = from item in UserDeclarations
             where (item.DeclarationType == DeclarationType.Variable
                || item.DeclarationType == DeclarationType.Constant
                || (item.DeclarationType == DeclarationType.Parameter && !item.IsArray))
             && !item.IsTypeSpecified
             select new VariableTypeNotDeclaredInspectionResult(this, item);

Comintern

Yeah, I just looked at it. Doesn't look like a difficult change to make if we want to be pedantically correct.

Hosch250

18:06

Oh boy, these could get so much cleaner with C# 7's local functions.

@Comintern If you do it, just be sure to delete the German/French values to ensure they get updated too.

Comintern

OK.

Hosch250

@Comintern I don't get why you rejected this: stackoverflow.com/documentation/proposed/changes/64551

The original version said "Failing to declare a variable with the Dim keyword will result in a compile error"

His version says "Failing to declare a variable, e.g. with the Dim keyword, will result in a compile error".

Comintern

I had a moment of color blindness and mis-read the edit. I couldn't retract it.

Hosch250

Oh, OK.

Comintern

I thought he was removing what he was adding.

Hosch250

18:14

I approved it without realizing it was rejected already, and now I don't know what the status is.

Looks like it is approved.

Comintern

Yep. Approvals simply over-ride rejections.

Hosch250

Docs is thoroughly horribly implemented.

Comintern

I'm trying to think of any instances where the DeclareExplicitVariant quick fix would cause code to break by changing the type of a Const.

Hosch250

What about passing a variant to a string?

Suppose some function called another function that expected a string param and passed the const as the param?

Comintern

That should just cause an implicit cast internally. If it was an API call, it would get marshaled to a string pointer regardless.

Hosch250

18:21

OK.

Comintern

Const Foo = 1.2 is a Double by default so no problem there...

AFAICT it looks like the compiler assigns type based on the same rule it uses for assignment of a literal to a Variant - shouldn't be any quick-fix problems.

Quack Exchange

1

Q: Take all underlined words, put in Excel column

I have a 100+ page Word document, that I would like to extract all of the underlined words from. I am very familiar with VBA and Excel, but relatively new to Word. I was wondering if this is the best way to do what I'm trying. I will run this from my Word document: Sub extractUnderlinedWords()...

vba excel time-limit-exceeded ms-word

FreeMan

@QuackExchange Looks like that's still SO material since it locks up on him.

Hosch250

18:36

@Mat'sMug You know the Parameter On Multiple Lines inspection?

We should expand that to variables/fields in 2.1.

Comintern

OK, the spelling edits between EN-UK and EN-US are starting to get annoying.

Hosch250

@Comintern I can believe it.

EN-us is cleaner, in my not-so-humble opinion.

Comintern

Although it is reminding me that I've never fixed my browser's spell-check locale at home. System locale is US, spellcheck locale is UK. Drives me nuts.

Duga

[rubberduck-vba/RubberduckWeb] Hosch250 created pull request #16: Here come more adjustments for the inspection runner to merge Hosch250/RubberduckWeb/master into rubberduck-vba/RubberduckWeb/master

[rubberduck-vba/Rubberduck] daFreeMan commented on issue #2155: Indenter sample in settings should have height scale with window.

> TBH, the splitter isn't really that obvious.

Comintern

You know, to an outsider it might look like I'm milking the Date Time Manipulation topic for +2s. They really need to fix the script freezing issue when making substantial edits. They can keep the stupid +2s.

Hosch250

18:50

I wish they'd remove all rep from it.

Comintern

That makes hundreds of us.

Hosch250

That rep is going to be the ruin of it.

Comintern

More people are complaining about the rep, but what will really be the ruin of it is the review process.

Hosch250

That too.

You know, they should really give people positive rep for approving and negative rep for rejecting. It's all part of the "feel good and be nice" they want.

FreeMan

@Hosch250 except nobody would want to reject because we've all been conditioned to go after our little treats.

Comintern

18:59

Does CDate("September 11, 2001 15:45") work outside of locales where month 9 isn't "September"? I know MonthName does depend on locale.

Hosch250

@FreeMan I typically don't reject because I don't know enough.

Then, when I do try to reject, I have to write an explanation most of the time, so I just don't. They need an "actively makes it worse" option.

Which, BTW, why in the world is C# 7 on all these? stackoverflow.com/documentation/c%23/topics

FreeMan

I'm with ya - I don't reject too many. But then, I don't approve to many, either

Comintern

They should make approval require a vote of +3, and then give negative rep for the users on the wrong side.

Hosch250

It was already rejected at least once. C# 7 isn't out yet, and as far as I know, it has another couple years to go.

Comintern

0

Q: Best practices for being a StackOverflow jerk?

I'm new to StackOverflow and have been told by my colleagues that the users of this site are "mean" and "jerks", especially to new users. Since I would like to properly integrate myself into this community, what are some good practices to correctly be a jerk on StackOverflow?

discussion new-users etiquette rules

Hosch250

19:03

Wow, lol.

Comintern

19:16

I'm surprised it took that long to delete.

Hosch250

@FreeMan Me either. Only Mat's, Comintern's, and ThunderFrame's, and a few others.

DustinF

Man I was wanting to see the comments on that one...

FreeMan

@Comintern @all - OK, where the heck do I get the waffle maker from the 404 page????

Hosch250

I feel like I could throw up. I don't deal with stress very well.

What the heck am I suppose to say in my reflective report?

DustinF

19:34

Freeman, I was wondering the same think... I want keyboard waffles too

kickstarter.com/projects/1304060422/the-keyboard-waffle-iron

Ahh... Kickstarter

Hosch250

Hi, @DustinF.

DustinF

Hi Sorry.. I am new here... I like VBA, so I am hanging out with you guys. :-)

Hosch250

Nice.

DustinF

At some point I'll have to try this Rubberducking as well... sounds cool

Hosch250

Boy, I wish I didn't feel so sick. It's hard enough to write without feeling sick from stress.

ThunderFrame

19:40

stressed about internship ending? Has @Mat'sMug told you about the 200% pay increase in the Rubberduck graduate program?

DustinF

Usually stress will make you even more sick you know. :-)

Hosch250

No, I'm stressed about getting everything in to my professor by August 1st.

@DustinF That's what I'm feeling sick from. As far as I know, I've nothing else wrong with me.

@ThunderFrame I highly doubt he's heard of it himself.

Comintern

Wow. I committed my Docs edit heard all the PC fans spin down. That should not be burning so many processor cycles. No wonder it's hot in here...

DustinF

I have been there. I worked 40+ hours while getting my bachelors and masters, and running my offshore team during the night while doing homework....

FreeMan

@ThunderFrame 200% of 0...

;)

Hosch250

19:52

I feel sorry for you.

At least I don't have to work in addition to doing school, which is probably one of the main reasons I'm doing as well as I have.

DustinF

Glad its over. :-) Yes, I wish I could have just studied, but that wasn't possible...

But the good thing was I had my foot in the door... we had college interns coming in the same age I did, and I had two years of experience already

Hosch250

I've had about 1.33 years or so of experience with RD.

DustinF

Ahh.. Cool!!

FreeMan

about 1.25 of those years have been in the last 90 days, right @Hosch250? :)

Hosch250

I'm sure I'm not as good as I think I am, but I think I'm not too bad a candidate for a job. By next summer, when I graduate, I'll have some commits with Roslyn/VS, a fair with with VSDiagnostics, and two years with Rubberduck.

@FreeMan Nah, I started on RD last summer around when college ended.

DustinF

19:56

School is worth it though once its over. I forgot while getting my master's that my father died, and my wife lost a baby... Talk about some stress while going to school... LOL

FreeMan

So it only feels like a year over the last 90 days? Seriously, with the number of commits, comments here, etc. it seems like you've done a year's worth of work. It's greatly appreciated!

DustinF

That's great. You'll be doing fine then. I wish when I started that open source and freelancing would have been so accessible back then. Sounds like you are doing great!

Also seems like you have a good support group as well. :-)

Hosch250

LOL, I've basically been the lead dev on RD since about the middle of May.

DustinF

LOL nice!

Hosch250

It was sometimes.

Sometimes, I would have been glad to have more help with things.

I'm sure there is some pretty rotten code in there.

ThunderFrame

20:02

I think it's been over a week since we had a grammar bug!

DustinF

Off topic, but when I worked at Sprint. I spent 8 hours of paperwork through the "Change management Process" to fix a mis-spelling

Comintern

Can somebody approve stackoverflow.com/documentation/proposed/changes/65091 for me? My browser can't handle it anymore and I still need to finish cleaning it up.

Hosch250

I haven't fixed any grammar bugs for the past three weeks or so.

@DustinF Wow.

@Comintern Done.

DustinF

Big companies are messed up

Comintern

@DustinF I was on a six-sigma team at a nameless former employer for 2 months before they kicked me off it. I was being "uncooperative" at my task telling them how many bugs we didn't know about.

DustinF

20:05

LOL... that's awesome!

Comintern

They wanted to know the ratio of found bugs to unfound bugs before they would commit resources.

4

DustinF

hahahah

Hosch250

What?

LOL, by definition, you don't know that....

ThunderFrame

The Rumsfeldian methodology? I didn't know I didn't know about that.

DustinF

Corporations are nuts... Sprint also had blue project money type stuff... so my boss would come tell me to add hours to some project I never heard of, because the numbers were too high on the one I was currently charging my hours to.. Neither were anything that I was working on

Hosch250

20:08

*.*

DustinF

Just stick to programming @Hosch250. :-)

Comintern

20:19

@FreeMan Gimme a sec on Date Time Manipulation.

@FreeMan - I'm done, but you might want to approve before you submit your draft so it doesn't merge conflict.

FreeMan

@Comintern Done.

Comintern

All yours. I'll be a bit more hesitant to take the approve and edit approach in the future. That took way too long.

Duga

20:40

[rubberduck-vba/Rubberduck] Hosch250 synchronized pull request #2151: Ninject memory leaks

[Hosch250/Rubberduck] Hosch250 pushed 6 commits to ninjectMemoryLeaks

[Hosch250/Rubberduck] web-flow pushed commit 9340a52c to ninjectMemoryLeaks

FreeMan

for your reviewing pleasure:

Duga

Merge pull request #2158 from Hosch250/Issue2130

Fix cache bug causing KeyNotFoundInDictionary exception

FreeMan

stackoverflow.com/documentation/proposed/changes/65215

Duga

[Hosch250/Rubberduck] web-flow pushed commit f81dd869 to ninjectMemoryLeaks: Merge branch 'next' into ninjectMemoryLeaks

FreeMan

TTGH, TTFN

Duga

20:42

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

[Hosch250/Rubberduck] build for commit f81dd869 on ninjectMemoryLeaks: AppVeyor build succeeded

[rubberduck-vba/Rubberduck] Hosch250 merged pull request #2151: Ninject memory leaks from Hosch250/Rubberduck/ninjectMemoryLeaks into rubberduck-vba/Rubberduck/next

[rubberduck-vba/Rubberduck] Hosch250 pushed commit 2d01027f to next: Clean up memory leaks from the dockable presenters

[rubberduck-vba/Rubberduck] Hosch250 pushed commit 64117cdf to next: Fix messed-up config.

[rubberduck-vba/Rubberduck] Hosch250 pushed commit 0b99ef92 to next: Fix more memory leaks.

Hosch250

@FreeMan That last example makes me ill.

Duga

[rubberduck-vba/Rubberduck] Hosch250 pushed commit 968632dc to next: Make EmptyNamespace and OutputXmlSettings static

[rubberduck-vba/Rubberduck] web-flow pushed commit c1bbbe2b to next: Merge branch 'next' into ninjectMemoryLeaks

[rubberduck-vba/Rubberduck] web-flow pushed commit 458ec20a to next: Merge branch 'next' into ninjectMemoryLeaks

[rubberduck-vba/Rubberduck] Hosch250 pushed commit e30c9940 to next: Dispose of RubberduckParserState in App

[rubberduck-vba/Rubberduck] Hosch250 pushed commit 4ccf9ccb to next: Merge branch 'ninjectMemoryLeaks' of github.com/Hosch250/Rubberduck

[rubberduck-vba/Rubberduck] web-flow pushed commit f81dd869 to next: Merge branch 'next' into ninjectMemoryLeaks

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

Merge pull request #2151 from Hosch250/ninjectMemoryLeaks

Ninject memory leaks

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

Comintern

@Hosch250 There's a reason behind it - The built in DateAdd function is horrendous overkill for most simple date handling. More often than not, I'll just leave everything as a Long until I'm done messing with it (unless I need the time component of course) to make sure that rounding errors don't creep in. It also monumentally faster to process them in Longs and just use the math operators.

Hosch250

21:21

@Comintern I mean, the way it doesn't have any input handling.

Comintern

Where the hell did that link take me before? O_o

FreeMan

22:10

@Hosch250 You're welcome! :)

I figure documentation like this is for the beginner as well as the advanced student - might as well head off questions as early as possible.

Hosch250

I'd agree.

FreeMan

now, time to upgrade(?) a couple of Win7 boxen to Win10 before they cut off the freebee

Hosch250

I want SO Docs to be good enough for a beginner, but also discuss advanced issues, like Jon Skeet's book.

Comintern

@FreeMan At www.thekeyboardwaffleiron.com of course.

FreeMan

LOL

I'm with ya', @Hosch250

On the upgrade note, is it odd that I've never gotten and upgrade notification on any of my 4 PCs?

ThunderFrame

22:32

Windows Update last checked for updates in 2011?

Comintern

That seems a bit premature.

FreeMan

@ThunderFrame Is that when you switched to Linux?

ThunderFrame

22:57

LOL - I switched to a laptop as my primary PC in about 2012. The desktop has been gathering dust in the garage ever since. I turned it on to get the Windows 10 upgrade license, and after 3 days of failed updates, I gave up and burned a DVD only to find the PC doesn't support all of the chip instructions required for Windows 10.

Not that I paid retail, but the PC was an HP XW8200 Workstation with dual XEONs, which when new, sold for US$10K

Hosch250

10K?

That must be an old computer.

Transcript for