VBA Rubberducking

Set-ExecutionPolicy -ExecutionPolicy RemoteSigned
New-Item -Path 'HKCU:\Software\Microsoft\VBA\VBE\6.0\AddIns\Rubberduck.Extension' -Force
New-ItemProperty -Path 'HKCU:\Software\Microsoft\VBA\VBE\6.0\AddIns\Rubberduck.Extension' -Name Description -PropertyType String -Value 'Rubberduck'
New-ItemProperty -Path 'HKCU:\Software\Microsoft\VBA\VBE\6.0\AddIns\Rubberduck.Extension' -Name FriendlyName -PropertyType String -Value 'Rubberduck'
New-ItemProperty -Path 'HKCU:\Software\Microsoft\VBA\VBE\6.0\AddIns\Rubberduck.Extension' -Name LoadBehavior -PropertyType DWord -Value 3

^^ you run a powershell script that creates the registry keys where the VBE will look for addins

the \addins key registers Rubberduck for 32-bit hosts, and the \addins64 key registers it for 64-bit hosts

all VBE hosts look there for add-ins, not just Microsoft Office

Brian

@Mat'sMug Everything seems to have worked.

Mat's Mug

awesome!

Brian

When I executed the first line it gave me a warning saying the execution policy protects me from scripts I don't trust, etc.

Mat's Mug

yeah powershell is like that :)

Brian

1:45 AM

It recommended I say no.

So I did.

Is that a problem?

Mat's Mug

nope

powershell is essentially disabled by default

so you need to explicitly allow it to execute scripts

it's a powerful scripting engine, quite fun to learn :)

you can tap into the whole .net framework

Brian

I'm sure. :) I just wasn't sure if saying no to the first line was the right.

* right thing.

I executed all the other lines and got Rubberduck. So all seems to be working. Thanks very much for helping me. I look forward to learning it and using it.

Mat's Mug

there are a number of "hidden" features... the annotation system isn't very easily discoverable

Brian

How would I find that?

Mat's Mug

by following the wordpress blog lol

hold on

ah got it: rubberduckvba.wordpress.com/2017/03/05/…

Brian

1:53 AM

Cool! Added it to my favorites. With this and MZ-Tools I think I've got a good IDE setup. Thanks again!

Mat's Mug

@Brian make sure you check out vbwatchdog too!

MZ-3 or MZ-8?

Brian

Got it! MZ-8.

Mat's Mug

Wayne (the vbWatchDog guy) is currently helping us work around some serious problems, his add-in is the single add-in I'd openly recommend to anyone; nothing else does what it does, and what it does requires ...black magic.

Dec 19 '17 at 20:38, by WaynePhillipsEA

well I'm honored to hear that :) And FWIW Rubberduck is probably the only addin I would openly recommend to all VBA developers

:)

Brian

I'll definitely look into it! :)

Mat's Mug

I see you're learning C#?

Brian

2:05 AM

I'm trying! But my job is mainly working with VBA. I also write SQL and work with Access and Tableau.

Mat's Mug

barring Access and Tableau, that sounds like me

I do a bit of C# too though

Brian

I really want to learn .NET.

I have Visual Studio at work but use it rarely.

The only thing I could use it for, really, is writing a VSTO addin.

Mat's Mug

get VS 2017 Community at home, it's licensed exactly for working on OSS projects (it's free)

one of the two "founders" of the project wrote their very first lines of C# for it

we welcome people that love and use VBA all the time, and would like to help make the VBE ...suck less

Brian

Interesting. Yeah, when I was really trying to learn it I asked one question on SO for something so basic.

Mat's Mug

@IvenBach is learning .net & C# in this chatroom :)

Brian

2:10 AM

I've gotten about halfway through The C# Player's Guide by RB Whitaker.

It's REALLY easy to read and understand.

How long have you been writing VBA code?

Mat's Mug

hmm, 14 or 15 years

depends... I was writing VB6 code in 2000

or VB5..

Brian

You're really advanced. I've read many of your answers. I usually have to read them several times over again to digest. I've only been doing this for about 3 years.

Mat's Mug

I... hmm, is that good or bad?

Brian

Haha! Good, I think. It just means you're way ahead of me.

Mat's Mug

oh, ok lol

I hope I don't ramble to much.. sometimes I re-read myself and finish a 12-line paragraph realizing there's only a single dot in there.

Brian

2:16 AM

Places that have helped me out most have been Stackoverflow, Chip Pearson, and Profession Excel Development by Green, Bullen, and Bovey.

Oh, and VBA Developer's Handbook.

Mat's Mug

Bullen, and Bovey?

Brian

Yep!

Mat's Mug

these two gave us their VB6 source code for the Smart Indenter add-in

:)

Brian

Nice! How did you manage that?

Mat's Mug

github.com/rubberduck-vba/Rubberduck/tree/next/…

Brian

2:17 AM

Ah!

Mat's Mug

obviously we had to rewrite it

but it started with a C# port of Smart Indenter, to revive the add-in in 64-bit hosts

(VB6 builds 32-bit dlls)

oh, an early follower of the project simply contacted Mr.Bullen by email

Brian

Okay. I see. I've reached out to one of them a time or two.

Mat's Mug

we agreed to license the original VB6 source code under GPLv3, so ..there it is :)

Brian

They're always helpful and reply fast.

Cool!

Mat's Mug

(we fixed a few bugs in the process btw)

Brian

2:21 AM

:-D

Mat's Mug

hmm, turns out that same old follower once contributed a piece of code that's going to be central in what I'm currently working on

Brian

What are you currently working on, if you can say?

Mat's Mug

I'm making Rubberduck's twist on the Add/Remove References dialog

(WIP)

Brian

Ah yes - Tools > References.

Nice!

Mat's Mug

I think I've got the plumbing down

I have a service that fetches the available type libraries from the registry

Brian

2:26 AM

You could do your own version of Declaration comment headers.

e.g. a template for constants, UDT, etc.

Mat's Mug

'@Description("This shows up in RD's toolbar - and eventually in our hijacked intellisense")
Public Sub DoSomething()
End Sub

by v3.x Rubberduck will take complete control over the VBE

Brian

Complete control?

Mat's Mug

people - programmers - will walk by your workstation and ask "huh what IDE is that?" and "wait is that VBA?"

@Brian our next big challenge will be to make our own editor window - "code pane"

Brian

I look forward to seeing that!

Mat's Mug

we want custom syntax highlighting, red squiggles, blue squiggles, dim-gray dead/redundant code, ...

Brian

2:31 AM

Similar to VS IDE, sounds like.

Mat's Mug

yup

Brian

That's really cool!

I hope you make some good progress on that.

Mat's Mug

I dream of killing the inspection results toolwindow

what I want is for inspection results to only show up in the code pane you're editing - in the code pane

and you get a little popup button/menu to apply a quick-fix

hi @PeterMTaylor!

Peter M Taylor

Yo Matt! what's news with gossping? :)

Mat's Mug

I got a UPS for my server today

plugged it in, the server booted straight up

Peter M Taylor

2:35 AM

cool. a personal server for testing?

Mat's Mug

I'll be setting up virtual machines and domains and whatnot... #havingfun

perhaps I could eventually host the project's website right in my garage

can't wait to get my hard drives this coming week

Peter M Taylor

so you bypass stackoverflow or that's too much?!?!?!?!

Mat's Mug

huh lol

Peter M Taylor

:)

got a moment Matt?

Mat's Mug

sure what's up?

Peter M Taylor

2:49 AM

Just asking a SQL Server question for the WIP CodeAudit project

I may have the wrong approach but like to bounce an idea if I on the right track.

Mat's Mug

go on

Peter M Taylor

Where I am at this stage is wanting to work out how common C# keywords are

So I have a zip file of previous releases on my hard disk for research purposes. I got powershell to make a list of files

I need to make C:\RD\Rubberduck-1.0\RetailCoder.VBE\App.cs load into a table and split each back slash into a field

so C:, Rubberduck1-.0, RetailCoder.VBE, App.cs are in seprate fields

Mat's Mug

that doesn't feel right

Peter M Taylor

oh ok.

Mat's Mug

if I think in SQL I'd want the subfolders to each have an ID

then each file has a FolderId or something

that way more folders means more records, not more columns

Peter M Taylor

2:54 AM

yes I had considered that as a next step assuming SQL Server can autogenerate the id

Mat's Mug

yup

or autonumber in Access

Id int identity(1,1)

Peter M Taylor

sorry no access with my Student version installation of Office 2010. So I had installed the latest version of SQL Service recently upgrade last night to 17.4

Mat's Mug

nice

Peter M Taylor

there is an import/export feature with SQL Server and I couldn't ask that to recognise backslash as a delimited. so I playing around a way to express it as seprate fields

it would work within excel. I may end up doing this in VBA as a last resort

Mat's Mug

create table dbo.Folder (
     Id int identity(1,1)
    ,ParentId int identity(1,1)
    ,Name nvarchar(255)
);

I think I'd do something like that

and use VBA code to normalize the data

normalized data will be much easier to analyze

Peter M Taylor

3:00 AM

yeah and power pivot (to build on my soft skills. )

Mat's Mug

probably (I need to get/try that)

Peter M Taylor

:) which bitness Matt? there is 32bit or 64 bit. If you have Excel 2016 it has that feature included.

Mat's Mug

ha nice

Peter M Taylor

Here is the link for Excel 2010. msdn.microsoft.com/en-us/library/…

Mat's Mug

thanks!

Peter M Taylor

3:05 AM

No problem. Cool, thanks for the technical advice, so I'll expand where I going Matt, I'll make sure I recognise sub folders in my equation and save into a spreadsheet table. SQL Server eats spreadsheets tables for breakfast as per red-gate.com/simple-talk/sql/ssis/…

Mat's Mug

openhub.net/p/Rubberduck_VBA/factoids

Peter M Taylor

yeah just read this, are we figurately speaking doing better for not using comments since mentioning we are "This lack of comments puts Rubberduck VBA among the lowest one-third of all C# projects on Open Hub"?

Mat's Mug

I personally disagree with the assessment/significance of comments

Few comments can also be an indicator of a well-written, self-documenting code base

Peter M Taylor

fair enough.

Mat's Mug

We do need more summary xml-doc though

Peter M Taylor

3:18 AM

agreed, some signposts are better to navigate a well built codebase

Mat's Mug

39

A: Guessing a number, but comments concerning

So you want to write good comments. Good comments... ...say why, not what. ...don't state the obvious or rephrase what the code is already saying. ...don't turn into lies if the code changes. Let's see... import java.util.*; //so I can use scanner The problem is that you're importing an...

Peter M Taylor

so the documentation literally becomes like the Object Browser form?

Mat's Mug

Oops meant to copy this one

135

A: Guessing a number, but comments concerning

Welcome to the hell of comments, and personal taste. There are multiple answers to your core question that may be right: you have not commented enough you have commented all the wrong things you have commented too much. your comments are in the wrong format you are missing the formal comments. ...

@PeterMTaylor with enough xml doc we could build a msdn-like site out of it

Peter M Taylor

How much is enough xml? we currently have I guess about 8 main features, most code changes each have a number of getters/setters or class/methods something like 8^?? something?

Mat's Mug

inspections in particular need thorough xml-doc :)

Peter M Taylor

3:22 AM

yeah definitely so we can attach some counter-examples confidently from either Github Issues or Stackoverflow examples with their URLs?

Mat's Mug

I was thinking of building the "inspections" part of the website with it

Peter M Taylor

so it's growing in some order of magnitude but agreed got to start somewhere and its helpful to make our own "Duckybot" to keep our documentation current.

Peter M Taylor

3:39 AM

cool. Have a good evening / early morning Matt, take care. catch ya soon.

Mat's Mug

later!

Nelson Vides

7:11 AM

@Mat'sMug Not only @IvenBach :D

Quack Exchange

11:17 AM

0

Q: Excel VBA Filtering: AODB vs Autofilter vs SQLite

I have an Excel sheet with data in about 100,000 rows, 16 columns. I have to extract data (one value from the 1 row I find) from this table a few thousand times. I have been using Autofilter to extract this value, but have also tried AODB/SQL statements to see if I can improve the speed of the qu...

Duga

1:25 PM

[rubberduck-vba/Rubberduck] WaynePhillipsEA synchronized pull request #3716: TypeLibsAPI (WIP)

[rubberduck-vba/Rubberduck] WaynePhillipsEA commented on pull request #3716: TypeLibsAPI (WIP)

> most of what discussed yesterday now implemented. comments/XML doc still to do, plus the member enumerators still to do, plus a few FIXMEs.

[rubberduck-vba/Rubberduck] WaynePhillipsEA commented on pull request #3716: TypeLibsAPI (WIP)

> most of what was discussed yesterday now implemented. comments/XML doc still to do, plus the member enumerators still to do, plus a few FIXMEs.

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

Duga

4:11 PM

[rubberduck-vba/Rubberduck] bclothier commented on Rubberduck.VBEEditor/ComManagement/TypeLibs.cs of pull request #3716: TypeLibsAPI (WIP)

[rubberduck-vba/Rubberduck] bclothier commented on Rubberduck.VBEEditor/ComManagement/TypeLibsAPI.cs of pull request #3716: TypeLibsAPI (WIP)

[rubberduck-vba/Rubberduck] bclothier commented on Rubberduck.VBEEditor/ComManagement/TypeLibs.cs of pull request #3716: TypeLibsAPI (WIP)

[rubberduck-vba/Rubberduck] bclothier commented on Rubberduck.VBEEditor/ComManagement/TypeLibsAPI.cs of pull request #3716: TypeLibsAPI (WIP)

[rubberduck-vba/Rubberduck] bclothier commented on Rubberduck.VBEEditor/ComManagement/TypeLibs.cs of pull request #3716: TypeLibsAPI (WIP)

[rubberduck-vba/Rubberduck] WaynePhillipsEA commented on Rubberduck.VBEEditor/ComManagement/TypeLibs.cs of pull request #3716: TypeLibsAPI (WIP)

[rubberduck-vba/Rubberduck] WaynePhillipsEA commented on Rubberduck.VBEEditor/ComManagement/TypeLibsAPI.cs of pull request #3716: TypeLibsAPI (WIP)

this

@Mat'sMug, I think you'll like this one; RD gets to see everything about a locked project. :)

Duga

4:27 PM

[rubberduck-vba/Rubberduck] WaynePhillipsEA commented on Rubberduck.VBEEditor/ComManagement/TypeLibsAPI.cs of pull request #3716: TypeLibsAPI (WIP)

[rubberduck-vba/Rubberduck] WaynePhillipsEA commented on Rubberduck.VBEEditor/ComManagement/TypeLibs.cs of pull request #3716: TypeLibsAPI (WIP)

Mat's Mug

4:44 PM

@this hmm, that'll be critical for RD-IntelliSense

this

and don't we have inspections that would benefit from it?

Mat's Mug

The resolver altogether yeah

this

(i'm thinking about false positives for undeclared variables or something like that? where it comes from a locked project?)

Duga

[rubberduck-vba/Rubberduck] bclothier commented on Rubberduck.VBEEditor/ComManagement/TypeLibsAPI.cs of pull request #3716: TypeLibsAPI (WIP)

[rubberduck-vba/Rubberduck] WaynePhillipsEA commented on Rubberduck.VBEEditor/ComManagement/TypeLibsAPI.cs of pull request #3716: TypeLibsAPI (WIP)

[rubberduck-vba/Rubberduck] bclothier commented on Rubberduck.VBEEditor/ComManagement/TypeLibsAPI.cs of pull request #3716: TypeLibsAPI (WIP)

Tweeting Duck

6:08 PM

“If you can get today’s work done today, but you do it in such a way that you can’t possibly get tomorrow’s work done tomorrow, then you lose.” - Martin Fowler, Refactoring: Improving the Design of Existing Code

Tweeted by CodeWisdom on January 20, 2018 at 11:57 PM

Duga

7:50 PM

[rubberduck-vba/Rubberduck] AnnaVel created pull request #3717: Step one inspection to merge AnnaVel/Rubberduck/step-one-inspection into rubberduck-vba/Rubberduck/next

[rubberduck-vba/Rubberduck] AnnaVel edited pull request #3717: Step one inspection

[rubberduck-vba/Rubberduck] build for commit e25d5369 on unknown branch: AppVeyor build failed

BUILD FAILURE!

[rubberduck-vba/Rubberduck] retailcoder commented on pull request #3717: Step one inspection

> Nice! Seems there was a problem with merging upstream though.

[rubberduck-vba/Rubberduck] AnnaVel commented on pull request #3717: Step one inspection

> That's my obviously unsuccessful attempt to update my branch from the original branch. Git and I don't get along so well.

[rubberduck-vba/Rubberduck] WaynePhillipsEA commented on Rubberduck.VBEEditor/ComManagement/TypeLibs.cs of pull request #3716: TypeLibsAPI (WIP)

Mat's Mug

hey @AnnaVel!

Duga

[rubberduck-vba/Rubberduck] Vogel612 commented on Rubberduck.Inspections/Concrete/StepIsNotSpecifiedInspection.cs of pull request #3717: Step one inspection

AnnaVel

Hi

Duga

[rubberduck-vba/Rubberduck] Vogel612 commented on Rubberduck.Parsing/Grammar/VBAParser.g4 of pull request #3717: Step one inspection

AnnaVel

I am sorry if I messed something up with that pull request

Duga

7:59 PM

[rubberduck-vba/Rubberduck] retailcoder commented on Rubberduck.Inspections/Concrete/StepIsNotSpecifiedInspection.cs of pull request #3717: Step one inspection

AnnaVel

I actually made the fix two months ago, but I've been putting off making the pull request because git is so mean to me

Vogel612

@AnnaVel not at all.

Mat's Mug

nothing messed up, PR looks good - but the InspectionBase class was modified a little while back - we managed to kill the need for that annoying Type member

AnnaVel

Yes, I guess I should have actually built it before trying to push something that is two-months-old

Vogel612

urk... see I was sure there was something about those ...

Mat's Mug

8:02 PM

:)

@AnnaVel it's a good sign - means we're still pretty active =)

Vogel612

git is pretty approachable once you get through it's thorny eldritch rune-littered shell

you should be able to rebase to upstream/next without too much blowing up.

AnnaVel

It is indeed thorny :)

Mat's Mug

I was going to say I wasn't sure adding a stepStmt rule was needed, but I see why you did it - I approve. Makes it much easier to get the step expression.

AnnaVel

I am glad

Mat's Mug

is one of the two inspections defaulting to DoNotShow? I'll have to check the default severities for some other "conflicting inspections" ...are we leaving it up to the user to decide which one they want to ignore?

Duga

8:08 PM

[rubberduck-vba/Rubberduck] WaynePhillipsEA commented on Rubberduck.VBEEditor/ComManagement/TypeLibs.cs of pull request #3716: TypeLibsAPI (WIP)

[rubberduck-vba/Rubberduck] bclothier commented on Rubberduck.VBEEditor/ComManagement/TypeLibs.cs of pull request #3716: TypeLibsAPI (WIP)

Mat's Mug

ah, found it. RedundantByRefModifier inspection is defaulting to DoNotShow

while ImplicitByRefModifier inspection is defaulting to Hint

so let's have one of the two default to DoNotShow, and the other one to Hint

AnnaVel

Goodness, I am sorry

I had actually set StepNotSpecified to DoNotSHow

Mat's Mug

lol, no problem at all

AnnaVel

And I must have forgotten to put it back after testing

Vogel612

no worries there :)

unrelated: Wayne is a literal magician

and I have no clue what he and this are talking about.

AnnaVel

8:13 PM

Should I make the change and commit it as well? Or you have some magic way to make the fixes you consider right before merging?

Vogel612

yes, please.

there is a way to "magically make fixes", but it's not pretty and it's requires dark magic incantations and GitHub won't automagically realize that the PR is merged, soo...

Duga

[rubberduck-vba/Rubberduck] WaynePhillipsEA commented on Rubberduck.VBEEditor/ComManagement/TypeLibs.cs of pull request #3716: TypeLibsAPI (WIP)

AnnaVel

Do you have any idea how I fix this build error: Invalid option '7.2' for /langversion; must be ISO-1, ISO-2, Default, Latest or a valid version in range 1 to 7.1.

Vogel612

Which version of VS are you running?

AnnaVel

I have a vague memory of fixing this before but I can't remember

Vogel612

8:16 PM

I shouldn't have read Questionable Content. ... my limit for acceptable sarcasm and banter is really whacky now

AnnaVel

VS Professional 2017 version 15.3.5

Vogel612

that shouldn't make any problems.

AnnaVel

Questionable Content is still updated? Damn, what year is it? :D

Vogel612

2018 ...

this

@Vogel612 Don't mistake my questions for actually knowing what I'm doing. I only know enough to be dangerous and blow things up. The rest, I get from MSDN documentation.

Vogel612

8:18 PM

I read all 3660 comics in one night.

this

FWIW, it's updated 5 days pretty darned consistently

which is lot more than I can say for most of webcomics out there

Mat's Mug

@Vogel612 saw that tweet, spilled my coffee lol

Vogel612

@Mat'sMug I must admit to making a small shower and coffee break ;)

AnnaVel

I probably need to reinstall something compile-related.

this

@AnnaVel gonna to have VS 2017 for C# 7.2</tortoise>

Vogel612

8:20 PM

@this read up 😉 you're too late there

this

T, FTFY.

AnnaVel

The funny thing is, last time it was lang 7.1 and it complained that it should be max 7 and now you've updated to 7.2 and it is complaining that it should be 7.1

I should really start working on not forgetting how I fix things

Vogel612

for all we know it might be disgruntled about that upstream merge that took all projects to 7.2 except Rubberduck.Inspections

AnnaVel

It claims that Inspections is also 7.2?

Vogel612

well it was a shot in the dark

Mat's Mug

8:26 PM

FWIW I'm having a hard time compiling my branch too

let's stick with 7.2 for a while ok

Vogel612

hmm ... somebody shot my VS a sideways glance again ... I'm up to 76 test failures for now ...

AnnaVel

:D

Vogel612

I was so sure it was only 18 last time I worked on the ANTLR upgrade :/

AnnaVel

:/

Mat's Mug

huh apparently we don't resolve the AsTypeDeclaration for functions???

Duga

8:55 PM

[rubberduck-vba/Rubberduck] WaynePhillipsEA synchronized pull request #3716: TypeLibsAPI (WIP)

[rubberduck-vba/Rubberduck] WaynePhillipsEA commented on pull request #3716: TypeLibsAPI (WIP)

> ^ still to do: comments/XML doc, plus the member enumerators, plus a few FIXMEs, plus DoesImplement() array support

AnnaVel

Apparently updating Visual Studio solves that

So, we are using NUnit now too

Vogel612

who's we? Yes we moved to NUnit. Also gives us CodeCoverage to fawn over

grr ...

I think I somehow broke the Parser..

And I have no clue how ...

Duga

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

Mat's Mug

System.IO.DirectoryNotFoundException : Could not find a part of the path 'C:\Users\Mathieu\AppData\Local\JetBrains\Installations\ReSharperPlatformVs15_ff‌b976d7\Testfiles\Resolver\Excel.1.8.xml'.

wtf

how did any of these tests ever passed...

Vogel612

well VS is cranky for all of us '^.^

Mat's Mug

9:11 PM

ugh.. every single test that's loading .xml serialized declarations is failing with the same stupid exception

Vogel612

> mismatched input 'B' expecting {RESTRICTED_LETTER, A}

that's a real nice pair you got there ANTLR .... RESTRICTED_LETTER is A-Z

Mat's Mug

whiskey-tango-foxtrot

this

@Mat'sMug, whiskey is easy to do. Tango is doable, provided you can get a dance partner. However to see a fox trotting, might take some effort given their endangered status. A trip to zoo may be in order.

Mat's Mug

I'll just stick to whiskey :)

Vogel612

actually foxtrot is also rather doable, given a suitable dance partner and knowledge of the steps

this

9:17 PM

Oh there's a dance by that name? #TIL

Mat's Mug

lol

this

so really a trip to a dancing joint'd suffice then.

Peter M Taylor

@Vogel612 offer VS some green tea and it might work next time around

Vogel612

<insert-faye-like-comment-here />

bla bloo violence beep boop

Duga

[rubberduck-vba/Rubberduck] bclothier commented on Rubberduck.VBEEditor/ComManagement/TypeLibsAPI.cs of pull request #3716: TypeLibsAPI (WIP)

Vogel612

9:21 PM

okay so I think we're down to 8 failing tests

apparently one of these two suggestions worked

Mat's Mug

It's great how DeploymentItem gives you no notice when it is unable to copy the single file you've provided it. — user74754 Feb 28 '13 at 0:27

and we don't have a Local.TestSettings file in solution items

so wtf

Vogel612

if it's any consolation: it doesn't need to be

solution items is an imperfect mirror of the actual folder structure

which is one of the things that pisses me off about csproj ... but eh

Mat's Mug

> System.IO.DirectoryNotFoundException : Could not find a part of the path 'C:\Users\Mathieu\AppData\Local\JetBrains\Installations\ReSharperPlatformVs15_ff‌b976d7\Testfiles\Resolver\Excel.1.8.xml'

why the hell is it looking under JetBrains installations then

Vogel612

you're having Resharper run the tests?

might be setting an inappropriate working directory

Mat's Mug

at least the R# runner is telling me about an IO exception

VS runner just says expected 1 / actual 0

Vogel612

9:32 PM

for what it's worth, an assertion failure is probably closer to a green test than an exception

Mat's Mug

except the assert fail is caused by the missing declarations that the test is supposed to load from xml

at least I think so

Vogel612

hmm ... that would make sense ...

Mat's Mug

oh wow

Vogel612

then again I do get VS Runner telling me about IOExceptions too, if they occur

Mat's Mug

breakpoint to AddTestLibrary isn't getting hit at all

ffs...

Vogel612

9:34 PM

hmm ... expecting the MockParser to do things for you?

Mat's Mug

it's parsing and resolving before it adds the library

lol

yeah

ah, the setup code is calling CreateAndParse

which isn't appropriate for tests that need to resolve types defined in .xml files

Vogel612

okay... two fingers of cognac and 8 failing unit-tests ...

~cracks knuckles

Mat's Mug

hmm test is suddenly taking much longer to complete

Vogel612

I'm almost sure that this is a good sign

Mat's Mug

yup

okay, I can't wait to get my hard drives and setup my server

pretty sure running VS on a VM with 4 times the processing power and RAM is going to help

Vogel612

9:50 PM

[21.01.2018 22:47:53 Warning] line 1:8 mismatched input 'B-C' expecting RESTRICTED_LETTER
[21.01.2018 22:47:53 Warning] line 1:8 mismatched input 'B-C' expecting RESTRICTED_LETTER
[21.01.2018 22:47:53 Warning] line 1:8 mismatched input 'B' expecting RESTRICTED_LETTER
[21.01.2018 22:47:53 Warning] line 1:8 mismatched input 'B' expecting RESTRICTED_LETTER

Mat's Mug

needs more alcohol

Vogel612

actually I'm making pretty good progress, all things considered

Mat's Mug

maybe there's a typo?

somehow I can't seem to be able to bring up the exception settings window anymore

Transcript for