VBA Rubberducking

Duga

12:00 AM

RELOAD!

[rubberduck-vba/Rubberduck] 2 issue comments.

[Minesweeper] Games Played: 134, Bombs Used: 75, Moves Performed: 17992, New Users: 17

Duga

1:01 AM

[rubberduck-vba/Rubberduck] IvenBach synchronized pull request #5095: Add description filter for Code Inspections

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

BUILD FAILURE!

IvenBach

@Duga Expected. I need to stop opening PR for my half-baked code...

IvenBach

1:55 AM

Bear with me on this DerpCheck. In VS, when using FindAllReferences if a line above a result is pushed down with Enter it still goes to the original line reference. That's because it's going off the token position like RD's parser?

Mathieu Guindon

kinda

IvenBach

I'm fine if it's a close-enough approximation.

Mathieu Guindon

:)

there's cache invalidation involved

IvenBach

Hand wavey gets me comfortable enough to work with it. Experience will help me correct bad assumptions and understandings a time after that.

I've resolved the object.ToArray() issue I was fussing with earlier. Doesn't feel like it is correct, but it works.

:grumble: mumble mumble. VS acting weird. BRB rebooting everything.

Installing Antlr4.CodeGenerator.4.6.4 now appears in the status bar and never successfully installs.

Giving it some time. Walking away for a bit.

IvenBach

3:07 AM

I'm guessing that's not normal.

srsly VS. What do I do that makes you jerk me around like this?

:sigh:

Duga

[rubberduck-vba/Rubberduck] IvenBach synchronized pull request #5095: Add description filter for Code Inspections

Duga

3:22 AM

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

IvenBach

@Duga using object seemed best. I don’t know how best to deal with a change in the type of the results.

Brain tickle says method overloading is something to look into.

IvenBach

5:17 AM

> Error occurred while restoring NuGet packages: The operation failed as details for project Rubberduck.JunkDrawer could not be loaded.

That's a new one.

Got that after nuking my local RD directory and cloning.

IvenBach

5:30 AM

Solution explorer has all Projects with a yellow warning triangle. Going through Tools>Options>NuGet Package Manager>General>Clear All NuGet Cache(s) brings up "Error: Access to the path 'C:\Users\IvenBach\.nuget\packages\easyhook\2.7.6684\content\net40' is denied."

Something's not correct.

@IvenBach Got that cleared with a restart. Getting the 'Rubberduck.JunkDrawer' message again.

Aaaaand consistently locking up VS. My RD dev tonight is sunk. Any other suggestions?

Moving on to Unit Testing book to keep productivity moving.

Vogel612

12:31 PM

@IvenBach nuking .nuget and then manually restoring might help

Quack Exchange

4:49 PM

0

Q: Find list of names in other Sheet and copy them

I’m asking for some advice on what is the best way to tackle this problem. Use any formulas inside excel or seek an alternative version (VBA Module) In sheet1, I have 16 columns and around 200k rows. In Sheet2, I have column 8 or H given with around 500 rows of data. The goal is to look at co...

IvenBach

5:26 PM

@Vogel612 You still there?

Vogel612

somewhat?

IvenBach

By manual restore do you mean just building and letting nuget grab the required dependencies?

I nuked .nuget and was about to build. I've only ever really let nuget do the restore so thought I'd ask.

Vogel612

I thought of the "Restore NuGet Packages" context menu item

though a build will usually also run nuget restore

you could even open the NuGet console and run nuget restore from there

IvenBach

Vogel612

yup

IvenBach

5:30 PM

I generally need kindergarten pictures until I know what stuff is and what it does.

Whereas this is the second option you were suggesting?

@Vogel612 Tried nuget restore and got red errors. I'm misunderstanding you.

Vogel612

no, probably not...

IvenBach

:grumble: Building starts but it never progresses.

Vogel612

you're exactly right, I think you're looking for running just restore, maybe

IvenBach

Cleaning is the same, starts but never progresses or does anything.

Vogel612

after all it's not PS>, but PM>

@IvenBach output window does not give anything up?

IvenBach

5:43 PM

For clean 1>------ Clean started: Project: RubberduckTests, Configuration: Debug Any CPU ------ and never progresses.

Same for build it starts and in the status bar the icons showing components going into the bin displays but output never updates.

Solution>Context Menu>Restore NuGet Packages starts the restore, battery looking icon in status bar starts loading, but no apparent changes. Nothing to output either.

Every project has same warning triangles.

Vogel612

do you have Dotnet core installed?

IvenBach

I'm not sure. Where do I go to check?

Vogel612

it should be possible to build the project through the dotnet-cli application

dunno, for linux I could tell you to run which dotnet ...

IvenBach

If Dotnet core doesn't install w/ RD then I'm confident I don't have it.

Vogel612

okay.

IvenBach

6:04 PM

Tried another #NukeFromOrbit on the RD directory and tried with a fresh clone. Same result. I've thought of a reinstall for VS but don't believe that'll solve it.

Break time lest I get too frustrated and pull a stupid.

Vogel612

you seem to have a knack for killing your build in weird ways

4

IvenBach

I do want to note that it's only the RD directory that has the problem. Other repos I have locally build without issue.

Vogel612

  private BPELPlanHandler buildPlanHandler;
  private BPELPlanHandler bpelProcessHandler;

IvenBach

Computers dislike me and do all they can to screw up when I'm using them.

Vogel612

... why the ... I don't even... WHY DID NOBODY NOTICE THIS SOONER?!

2

Duga

6:12 PM

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/CodeExplorer/Commands/OpenCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/CodeExplorer/Commands/CodeExplorerCommandBase.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/Command/ComCommands/ExportAllCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/CodeExplorer/Commands/IndentCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/Command/ComCommands/IndentCurrentProcedureCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/CodeExplorer/Commands/CodeExplorerFindAllReferencesCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/Command/ComCommands/FindAllImplementationsCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/CodeExplorer/Commands/ImportCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/Command/ComCommands/FindSymbolCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/Command/ComCommands/InspectionResultsCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/Command/ComCommands/IndentCurrentModuleCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/CodeExplorer/Commands/SetAsStartupProjectCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/Command/ComCommands/NoIndentAnnotationCommand.cs of pull request #4833: Introduce ComCommand classes

M.Doerner

Sorry, that will go on for a while.

Duga

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/CodeExplorer/Commands/RemoveCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/Command/ComCommands/FindAllReferencesCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/Command/ComCommands/IndentCurrentProjectCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/Command/CommandBase.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/CodeExplorer/Commands/AddTestComponentCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/CodeExplorer/Commands/PrintCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/CodeExplorer/Commands/AddTemplateCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/Command/ComCommands/SyncCodeExplorerCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/Command/CommandBase.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/Command/FormDesignerFindAllReferencesCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/UnitTesting/ComCommands/AddTestMethodCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/UnitTesting/ComCommands/AddTestModuleCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/UnitTesting/ComCommands/AddTestModuleWithStubsCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/CodeExplorer/Commands/CodeExplorerFindAllImplementationsCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/CodeExplorer/Commands/DeleteCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/Command/ComCommands/ReparseCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/CodeExplorer/Commands/OpenProjectPropertiesCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/CodeExplorer/Commands/OpenDesignerCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/CodeExplorer/Commands/RenameCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/UnitTesting/ComCommands/AddTestMethodExpectedErrorCommand.cs of pull request #4833: Introduce ComCommand classes

[rubberduck-vba/Rubberduck] MDoerner commented on Rubberduck.Core/UI/Command/ComCommands/ShowParserErrorsCommand.cs of pull request #4833: Introduce ComCommand classes

IvenBach

6:32 PM

On a lark I tried a fresh clone to desktop and still same issue.

:sigh:

Vogel612

poke @this suggestions?

this

11:27 PM

@IvenBach just to rule out the obvious, did you have any projects showing as unavailable or unloaded? if so, did you reload those?

IvenBach

@this I don't believe so. But explicitly hand-hold me through it #JustInCase I don't understand.

this

in the solution explorer you should see all 18 projects loaded. if they aren’t they will show up as such

IvenBach

All are there. Checked context for each one to verify they all say Unload Project, ensuring they are loaded.

this

ok. close solution. open the rubberduckmeta.sln solution

are they all loaded?

IvenBach

Yes.

this

11:32 PM

can you build the meta solution? notebthat you may need to restart vs if you already built rubberduck in same vs session

IvenBach

Meta solution?

this

did you open the rubberduckmeta.sln?

IvenBach

this

that is rubberduck.sn

IvenBach

~~Those are~~ :derp: you asked me to open 'rubberduckmeta.sln'. Trying that.

Yeah #ImAnIdiot and can't read properly.

rubberduckmeta.sln builds without issue.

this

11:37 PM

good. now close, go back to rubberduck.sln

can you build junkdraweer only?

IvenBach

Doesn't look like it.

this

first error from output please.

IvenBach

Wouldn't that be nice?

Yeah... about that. No output shows.

this

don’t bother with error list. read the output

wtf

nothing at all?

IvenBach

this

11:41 PM

why are there two vs!

?

IvenBach

My unit test book.

Working through examples.

When I stop the build by trying to close VS I get output.

this

let’s rule out. close and amke sure there is only one devenv in taskmgr

IvenBach

1>------ Build started: Project: Rubberduck.JunkDrawer, Configuration: Debug Any CPU ------
1>C:\Users\IvenBach\source\repos\Rubberduck\RubberduckBaseProject.csproj : warning MSB4011: "C:\Users\IvenBach\.nuget\packages\sunburst.net.sdk.wpf\1.0.47\Sdk\Sdk.props" cannot be imported again. It was already imported at "C:\Users\IvenBach\source\repos\Rubberduck\Rubberduck.JunkDrawer\Rubberduck.JunkDrawer.csproj". This is most likely a build authoring error. This subsequent import will be ignored.
1>C:\Users\IvenBach\source\repos\Rubberduck\Rubberduck.JunkDrawer\Rubberduck.JunkDrawer.csproj : warn…

this

ok. build all

did u have two vs open last night?

IvenBach

No.

this

11:44 PM

ok. let’s see what happens

IvenBach

In the status bar it shows 'Synchronizing FooBar ...` runs through each of the projects and then shows 'Ready' in bottom left without showing any output.

this

is foobar changing or filling up?

IvenBach

Yes. It runs through them all too fast for me to read each individually.

this

k. clean and rebuild

IvenBach

Clean starts and no output is shown, other than:

1>------ Clean started: Project: RubberduckTests, Configuration: Debug Any CPU ------

this

11:48 PM

i think your msbuild is borked.

close all devenv and kill mabuild via task mgr

IvenBach

this

there may be multiple instances of msbuild,exe. kill them all

IvenBach

Those two icons usually stay showing and indicating they are building. As an FYI.

Killed the singular devenv that was open.

Don't see any msbuild.

this

ok. restart vs and try build

IvenBach

Still same outcome. 'Build started...' in bottom left of status bar, icons showing it's compiling in the middle, yet no output.

this

11:56 PM

do u see any msbuild in task mgr?

IvenBach

Yes. 6 of them.

this

hm. that is a lot....

usually i only see one orbtwo

how many cores so u have

Transcript for