@ChrisB hello! I grew tired of the too long feedback loop, so I setup AppVeyor to not only build & run the tests on every PR merge, but now also to package an installer for that build and automatically create a new tag for it.
So yeah, it's not 2.1 "stable", but if you want to help with ironing out the wrinkles (e.g. reporting issues of the current build), now you can, without cloning the project and building it yourself!
@Mat'sMug So, I implemented your advice from yesterday, but the test still isn't working. I think I need to verify that the ExportSourceFiles method triggered inside the project inside the mock VBE, like this:
@shadowofsilicon the string needs to be identical - I'd use a variable here, the same you're setting up the mock folder browser to return with (not a string literal)
I'm now on my fourth contact person for getting SHOWPLAN SSMS permission added so that analysts can use the built-in tools for improving their own queries....
When it's hard to understand just keep smashing your face into the keyboard. Eventually one of the keys will lodge itself into your forehead and you'll have your 'AHA!' moment.
@shadowofsilicon I can understand the L, M, and O keys. They are all on the righthand side. But please inform me how you got the A key included in there?
I'll have to see what your test is doing, the mock setup looks right
you'll want the "act" part of your test to call the command's Execute method (assuming your SUT is the ExportAllCommand itself), and then the "assert" part only needs to verify that project.ExportSourceFiles was called
...if that's what you have, then you need to debug the test and break in the command's Execute method.
I have 2 sheets with the exact format, 5 columns (Category1, Category2, Category3, Month, Amount) - "Temp" and "Source". My goal is to copy the data from "Source" to a new sheet("Combined"), append the data from "Temp" but replace the rows that are matching on column C and D with the new rows fro...
Sub BlackAndWhiteFromIndexTillEnd(ByVal startIndex As Long, ByVal inBlackAndWhite As Boolean)
Dim wsCounter As Long
For wsCounter = startIndex To ThisWorkbook.Worksheets.Count
ThisWorkbook.Worksheets(wsCounter).PageSetup.BlackAndWhite = inBlackAndWhite
Next
End Sub
I'm sorry @Mat'sMug or @Hosch250 but neither of your comments are being helpful at the moment. Intellisense isn't helping me and if I knew how to "set it up like that" I would already be doing it. It seems that is is time I show you everything I got so far:
We will stop accepting contributions to Documentation on August 8
On behalf of everyone who worked on Documentation, I want to thank all 15,451 users who contributed. We particularly want to acknowledge the 294 people who tested the private beta and the 2,361 who pounded on the public beta in ...
_folderBrowser = folderBrowserFactory.CreateFolderBrowser("Select a directory to Export Project as Source Files...", true, @"c:\"); is returning null...
Hm, looking at the output of starting and closing Excel with RD with native debugging it seems that we subclass one more window than we release in the end.
More precisely, I see one subclassing without a trace log being written, which gets released afterwards.
with RekeysAllLevelsDeep as (
select
a.claimid as Rekey
,a.ClaimIDAdjFromOrig as Original
,0 as RekeyLevel
from <base table> (nolock) a
where a.ClaimIDAdjFromOrig is not null
and a.ClaimIDAdjFromOrig <> a.ClaimID
union all
select
a.claimid as Rekey
,a.ClaimIDAdjFromOrig as Original
,RekeyLevel + 1
from RekeysAllLevelsDeep
join <base table> (nolock) a
on RekeysAllLevelsDeep.Original = a.ClaimID
where a.ClaimIDAdjFromOrig is not null
and a.ClaimIDAdjFromOrig <> a.ClaimID
and RekeyLevel <= 2
@Mat'sMug Can you explain to me what the parameter is that is passed to the command when it executes? protected override void OnExecute(object parameter)
@shadowofsilicon depends who's calling Execute and whether they're passing a parameter... if you make the command parameter an IVBProject object, then you need to make sure whoever invokes the command is passing that IVBProject parameter. If nothing passes anything, then write the command ignoring the parameter...
typically a code explorer command would pass something, e.g. the active or selected project
MZ-Tools 8.0.0.168 released introducing collector of ‘ TODO: tasks in code: https://www.mztools.com/blog/mz-tools-8-0-0-168-released-introducing-collector-of-todo-tasks-in-code/
> Description: An exception occurred while processing your request. Additionally, another exception occurred while executing the custom error page for the first exception. The request has been terminated.
MZ-Tools 8.0.0.168 released introducing collector of ‘ TODO: tasks in code: https://www.mztools.com/blog/mz-tools-8-0-0-168-released-introducing-collector-of-todo-tasks-in-code/
Well, it's been a crazy month but July has finally come to a close and with it Stack Overflow's 9th moderator election has also concluded. They said it was impossible, but 30 thousand or so voters were able to pick the best two moderators from among many worthy candidates, namely:
They'll be...
@Mat'sMug what do you mean when "Excel is handling/swallowing it (I hit continue and exit code is 0)"? It sounds like that Excel has something to retain control from your subclass already issued. To my mind sounds like Comintern simply regains an exisiting attention back from what Excel handles.
@IvenBach no. IFoo's public members are members of an interface. Foo's public members are exposed by any object (/instance) of type Foo - they're on that Foo object's interface
I think it was the introductory chapters of GoF's design patterns book that make it "click" for me. well it's nicely explained there anyway.
All objects present an interface, regardless of what interface their class implements
You have to understand the difference between a class and an object
@Mat'sMug Duh check: Since Foo : IFoo anything that Foo publicly exposes becomes part of Foo's interface, regardless of whether it's inhereted from IFoo or not.
@IvenBach I read a few years ago that although the plane is now flying, the main gun isn't ready yet, as there were too many bugs in the over one million lines of code...
@puzzlepiece87 The F35 program was a deliberate program to cover the development of another plane(s) that they didn't want to release to the public yet.
@Mat'sMug recent conversation. "Did you guys write up a card to look into widget's performance?" Me: "No. the bottleneck is downstream. We could make widget as fast as we want and it wouldn't make a difference. We carded up the perf for the fubulator."
There have been several civilian sightings of strange-looking planes in dogfights with US planes near US bases in the western US, GB, Belgium, and a few other countries.
Which is unsurprising because they are always developing new experimental planes.
The problem is, where is the money coming from?
Well, if you have a bunch of money just disappearing, someone is going to figure something out and send a spy in.
Might even be our own people trying to bust a money laundering ring.
@shadowofsilicon It's been going on since well before the Vietnam war, if you go read Kelly Johnson's book. They usually try to find people and tell them to not leak the information.
In .NET, I have a regex that (should) return exactly one named group per match. (?<fooGroup>foo)|(?<barGroup>bar)|(?<otherNonWS>\S+) on text foo the bar in the fizz returns 6 matches. Is there a way that I can get the name of the group, other than by checking if it is "fooGroup", checking if it is "barGroup", and/or checking if it is "otherNonWS"? Or is there some other construct I should be using?
So, you need to have a cover for the money being paid to the company making your planes. What better way than to buy a product for them that the world expects to be expensive and have problems?
@spolsky I guess that means #VBA coders will have to use Rubberduck instead... We've put so much valuable info in t… https://twitter.com/i/web/status/892532249329119234
Well, it's been a crazy month but July has finally come to a close and with it Stack Overflow's 9th moderator election has also concluded. They said it was impossible, but 30 thousand or so voters were able to pick the best two moderators from among many worthy candidates, namely:
They'll be...
VBA Rubberducking
VBA Rubberducking