« first day (1828 days earlier)      last day (1352 days later) » 

12:01 AM
RELOAD!
[banane-io/PDB] 1 commit. 19 additions.
[rubberduck-vba/Rubberduck] 5 opened issues. 2 closed issues. 13 issue comments.
[Minesweeper] Games Played: 104, Bombs Used: 78, Moves Performed: 14293, New Users: 21
 
This is a wonderfully simple and elegant SQL Server execution plan:
and it went from 15 seconds of churning to ~1 second. Not a bad way to end a day.
3
 
 
7 hours later…
7:22 AM
> Perhaps this is an opportunity to revise the ToDO explorer.

Adding 'Description" to the todo explorer will pull up all lines containing the term 'Description'

e.g.
'@Description()
'@Description("")
'@Discription("Wibble wibble")

but also unfortunately

Err.Description

The todo explorer will not detect the terms
@Description
Description()
Description("")


So it would seem to me there are possibly three useful enhancements that could be introduced to the todo explorer.
 
7:33 AM
> Thinking further, if annotations are an important part of RubberDuck, perhaps it is time to introduce an AnnotationExplorer?
 
 
2 hours later…
9:40 AM
@this I have the same shift hotkey problem at work. I have a makro that is supposed to open three workbooks based on some input if they are not open already.
Via the hotkey, it only ever opens one; via a button, it opens all of them.
I guess, I will have to live with hitting it three times sine I want a hotkey combination I can do easily with the left hand only.
 
 
5 hours later…
3:11 PM
 
 
5 hours later…
8:27 PM
> `the passing tests indicate that it's basically issuing results for exactly the opposite of when it should be doing that`

Huh? Are you sure? 😮
Here's an example test case:

```
[Test]
[Category("Inspections")]
public void SheetAccessedUsingString_ReturnsResult_AccessingUsingApplicationModule()
{
const string inputCode =
@"Public Sub Foo()
Application.Worksheets(""Sheet1"").Range(""A1"") = ""Foo""
Application.Sheets(""Sheet1"").Range(""A1"") = ""Foo""
End Sub";
> > the passing tests indicate that it's basically issuing results for exactly the opposite of when it should be doing that

Huh? Are you sure? 😮
Here's an example test case:

```
[Test]
[Category("Inspections")]
public void SheetAccessedUsingString_ReturnsResult_AccessingUsingApplicationModule()
{
const string inputCode =
@"Public Sub Foo()
Application.Worksheets(""Sheet1"").Range(""A1"") = ""Foo""
Application.Sheets(""Sheet1"").Range(""A1"") = ""Foo""
End Sub";
 
 
2 hours later…
10:46 PM
> This test case seems to test the wrong thing, indeed.

`Application.Worksheets` basically resolves to `Application.ActiveWorkbook.Worksheets`, which is not the same as `ThisWorkbook.Worksheets`, in general. Using the the code name yields the same result as the latter. The active workbook might be an entirely different workbook to which there is no reference on compile time.
 
11:12 PM
@Duga The difference being Application.Worksheets() has access to all worksheets if any workbook that just happens to be open vs just the worksheets of the add-in to which it belongs?
:derp: missed the Activeworkbook
 

« first day (1828 days earlier)      last day (1352 days later) »