Anyone using Office 2019? The number of times it crashed with RD installed is unbelievable. Just yesterday like 3-times per hour. Office 2016 without a problem. And there's the problem with Backspace within Property text fields of VBE Ide... 2019 only.
I have an excel sheet that I want to clean by removing some rows from it based on criteria. If a cell in a specific column on the list contains a value from a set of values, the row with this cell should be deleted from the list.
The data table on the sheet has a header with column names.
So f...
Sigh... Ran my report in May and found the survey response rate was 20-something %. Ran the report for June and it shows the May response rate to be 11-something %.
Spent the morning trying to figure out why. I've identified that there are about twice as many possibilities now as there were then, but I have no idea why.
he's the one that took my original Peter-the-Painter resolver and turned it into the foundation of what it is today
he also essentially rewrote the entire grammar
Max basically picked up right where autoboosh left off, and took it to the next level. I'm thoroughly impressed with @M.Doerner's ability to just jump head-first into that code and start hacking away and enhancing things.
meanwhile I have a draft PR with one single resolver tweak.. and 370 failing tests
so many questions on the reddit vba thing where people are using explicit sheets for the ranges, but then using the implicit cells to define those explicit ranges
> Hi. sorry I have missed the question. Attached the logfile at error level. After checking->Ready the Indent menus are all greyed out.
`2019-07-16 22:23:44.2982;ERROR-2.4.1.4796;Rubberduck.Common.LogLevelHelper; Rubberduck version 2.4.1.4796 loading: Operating System: Microsoft Windows NT 10.0.17763.0 x64 Host Product: Microsoft Outlook x86 Host Version: 16.0.11328.20368 Host Executable: OUTLOOK.EXE; 2019-07-16 22:24:09.6584;ERROR-2.4.1.4796;Rubberduck.UI.UnitTesting.Commands.Add
> Hi. sorry I have missed the question. Attached the logfile at error level. After checking->Ready the Indent menus are all greyed out.
``` 2019-07-16 22:23:44.2982;ERROR-2.4.1.4796;Rubberduck.Common.LogLevelHelper; Rubberduck version 2.4.1.4796 loading: Operating System: Microsoft Windows NT 10.0.17763.0 x64 Host Product: Microsoft Outlook x86 Host Version: 16.0.11328.20368 Host Executable: OUTLOOK.EXE; 2019-07-16 22:24:09.6584;ERROR-2.4.1.4796;Rubberduck.UI.UnitTesting.Commands
> @tdalon this seems to be related to the old COM shims discussion. [See this comment by MZ-Tools author Carlos Quintero](https://github.com/rubberduck-vba/Rubberduck/issues/3837#issuecomment-493695190).
In other cases, repairing a corrupt Office install has been seen to fix this problem. Would you happen to be running multiple versions of Office side-by-side?
@IvenBach The background turns black when InitializeCommand() in run before InitializeComponent() because the Window.Background property is null. That's apparently the default value. Confirmed by explicitly setting Background = null;. As to why when Component is before Command it doesn't work? Still figuring that out.
If your control needs, say, a static collection to be initialized before the bindings get triggered that for some reason can't be in the VM, you can do that first.
I mean, you're probably doing things wrong or inheriting bad code, but...
@Hosch250 AFAIK it creates all the design-time objects; not too sure what that means for compiled xaml, but if it sets up bindings then it's literally creating everything the xaml is declaring - running any code before it would be rather iffy IMO. Could be wrong.
I find most tooling is ....toys. I like how MZ can locate variable refs in comments, but its static code analysis is otherwise way too basic for my taste.
That said we do need a "reorder module members" tool (and a "move member" refactoring)
But RD isn't getting a msgbox assistant tool as long as I live
Or a line numbering tool
Or a tool that adds obnoxious 20-liner comment headings everywhere
@IvenBach Congrats on getting it to work properly. At least based on my recent testing. Now the hard part starts. Understanding why it's working instead of blindly moving on.
I have an excel sheet that I want to clean by removing some rows from it based on criteria. If a cell in a specific column on the list contains a value from a set of values, the row with this cell should be deleted from the list.
The data table on the sheet has a header with column names.
So f...
VBA Rubberducking
VBA Rubberducking