> Thanks for the help, but those two lines are useless--I'd need the full stack trace (or at least the first two lines would be better than the last two lines). At this point, I have no idea what is going on with any of this...
> @retailcoder extra-long weekends are great. I highly recommend requesting an extra day off far in advance. ;)
@Hosch250 that's too bad, sorry about that. I was being lazy and not logging in to github on the windows machine and typing instead. I won't have access to a windows comp until Monday so I'll take a screenshot then.
Good Day! I just to ask if there is any alternative way to make my macro work fast? I only use Record Macro. what my macro do is Find The Word "JOBSPECIALTYCODE" in the sheet then select and delete. then move to next sheet. just like the image a provided PLEASE CLICK
Sub aHaveProgess()
'
'
'
'
...
>   
Installed newest version of Rubberduck Open excel Open VBA editor close vba editor from red x close excel from red x crash...
Im came here to seek some help with my Execel Formula. Please Check this Image for more details PLEASE CLICK
In my Document i state the number of report that i have and the time i recieved it and the deadline. just to monitor how many days and hour to finish that. i make some file like this. I u...
> @Hosch250 that's the failing Debug.Assert call in the sink handler for project removed; Debug calls don't get compiled into a release build. How about we replace it with a conditional early return?
In WPF, how would I apply multiple styles to a FrameworkElement? For instance, I have a control which already has a style. I also have a separate style which I would like to add to it without blowing away the first one. The styles have different TargetTypes, so I can't just extend one with the...
> Ah! See, by avoiding both whenever possible, I've not learned the finer distinctions.
It would still be a nifty feature to find all `Workbook` variables in scope and present them as Quick Fix options. Just not under `Quick Fix All`, since that would likely create chaos...
@Hosch250 if that Debug.Assert call sporadically fails in debug, then its condition will sporadically fail in release. I can't reliably repro either, but when that assertion fails, it would let the exception they're getting be thrown. Let's just exit the sink handler then, and remove that debug call
> Locally-scoped variables (i.e. "locals") can only be declared with `Dim`; module-scoped private variables (i.e. "fields") can be declared with both `Dim` and `Private`.
`Private` makes a field's scope explicit, but `Dim` not so much. *Public* fields can only be declared with the `Public` keyword (in a class module - in a standard code module, `Global` can be used with the same meaning as `Public`, but we already have an inspection for that), which makes `Private` the go-to keyword for decla
abstract would be annoying IMO. it can be implemented as an auto-property in all implementations.
removing virtual is a breaking change (but then, there are no overrides so we're fine)
might have been made virtual just because abstract would have been annoying, and virtual leaves the flexibility for derived types to override it if they ever need to
Yes, and that's a fine reason to leave it just that way
just because resharper says it doesn't have to, doesn't mean the abstract-ness of the commandBase can't be expressed by way of the virtual-ness of that property
aye, user needs a message, the exception needs to be logged, and forbidden to bubble further up the stack and bring down everything before the user can do anything.
2016-06-30 10:11:45.2615;DEBUG;Rubberduck.UI.Command.MenuItems.ParentMenus.ParentMenuItemBase;(46415386) Executing click handler for menu item '&Code Explorer', hash code 9624530;
2016-06-30 10:11:48.6571;FATAL;Rubberduck.UI.Command.CommandBase;System.InvalidOperationException: I can't crash RD anymore :(
at Rubberduck.UI.Command.CodeExplorerCommand.ExecuteImpl(Object parameter) in C:\Users\hosch\Documents\Visual Studio 2015\Projects\Rubberduck\RetailCoder.VBE\UI\Command\CodeExplorerCommand.cs:line 27
> There's something not right with having both Execute and ExecuteImpl public, it makes the interface ambiguous. I'd like to see public abstract Execute and private ExecuteInternal, but I can't think of a way of making it work ATM.
> Currently, the only quick-fix we offer when a `ByVal` parameter is assigned, is to pass the parameter `ByRef`. It being the only fix available, it's also the default fix for that inspection, and applying it changes the semantics of the code and can introduce bugs.
The default fix should be **Introduce a local variable**, that turns this:
Public Sub DoSomething(ByVal foo As Integer) 'some code foo = 42 End Sub
the settings, the parser state/tree/whatever, static arrays of specific keywords/tokens/types, all these would be part of the "ambient context" I'd say. And once that's done, then it can stop being injected everywhere, it's "ambient". and we can still control it in tests.
actually.. disposable stuff can't go on there
@DmitryGolubets: If you think logging is an essential aspect of your class make that obvious and inject it using constructor injection. If its for tracing input values and logging exceptions (I treat logging and tracing as fundamentally different things!) use decorators or interceptors. But never hide a dependency! That will bite you rather sooner than later. Always. — Sebastian WeberMay 21 '12 at 12:49
I need to re-read the chapter about ambient context to better weight the pros and cons before I make a decision
and when you start qualifying fields in one place, you kinda have to do it everywhere, and then yuo start having redundant this qualifiers everywhere, and it gets annoying and then I refactor/rename all the fields
@skiwi it's not intFoo, it's _foo. the underscore says "I'm a field" just like camelCase says "I'm a local" and PascalCase says "I'm a public interface member"
if Hungarian, then it's Hungarian done right
at the end of the day it's just a naming convention
IsEnabled is Hungarian, IDisposable is Hungarian. Not all Hungarian is evil.
VBA Rubberducking
VBA Rubberducking