> With my fork in sync with https://github.com/rubberduck-vba/Rubberduck/commit/f0f830bbd2d2e96cf0a7de95332dfe9ebe84db20. I too got the open excel -> load rubberduck -> Close excel -> Exception. ``` Exception thrown: 'System.Runtime.InteropServices.ExternalException' in System.Windows.Forms.dll Exception thrown: 'System.Runtime.InteropServices.ExternalException' in System.Windows.Forms.dll Exception thrown: 'System.Runtime.InteropServices.ExternalException' in System.Windows.Forms.dll Exce
since '92 with my diploma. All I learnt COBOL and worked with a telecommunication industry for a while switching between mainframes and Microsoft 2007 products, then I was outsourced twice before moving onto another industry after my late mother passed away.
so now settled very happly in the healthcare industry which is flexible in my time for myself and the family.
> The VBE doesn't load addins on command-line, the registry value `CommandLineSafe` has no effect whatsoever as far as I understand, for VBA IDE addins. Therefore, no command can be sent to Rubberduck to instruct it to run the tests.
But, the test methods themselves can be executed, and the assert calls will be made... but the logic that evaluates assert results to determine whether a test passed or not, won't.
I cannot think of any way to make this work ATM, if anyone does, feel free to s
I thought I'd give a shot at creating my own version of dealing 5-card hands to n players in VBA, printing them to columns and coloring hearts and diamonds red.
I felt I might have been a little repetitive and I had to jump through some hoops to avoid ByRef. Anyhow, what can I improve?
Option E...
> Sorry, @Hosch250, I am still getting the error. I'm attaching a workbook where it happens. [RD Issue 1846.zip](https://github.com/rubberduck-vba/Rubberduck/files/330210/RD.Issue.1846.zip) 
> Sorry, @Hosch250, I am still getting the error. I'm attaching a workbook where it happens. [RD Issue 1846.zip](https://github.com/rubberduck-vba/Rubberduck/files/330210/RD.Issue.1846.zip) 
funny you mention, I was running inspections against the above "Dealing Poker Hands", and noticed the UntypedFunctionUsageInspection wasn't firing up results as I expected, ..so there's another one that's broken ;-)
ParentScoping (?) isn't necessarily the direct parent. The distinction is useful for Enum and Type members; their ParentDeclaration will be the Enum or Type declaration, but their ParentScoping will be the module's.
in other news, I'm back to 51,000... took me almost a whole week to recover all that lost rep from last Friday.
I've not answered many questions since WinterBash.
I've pretty much left SE, other than chat.
The big thing for me is that people are, for the most part, making more nitpicks about my code, instead of the huge, comprehensive answers I used to get.
Dim TheWB As Workbook
Set TheWB = ActiveWorkbook
Dim SourceSheet As Worksheet
Set SourceSheet = TheWB.ActiveSheet
Dim RuleSheetName As String
RuleSheetName = SourceSheet.Name & RuleSheetNameSuffix
On Error Resume Next 'if the rule sheet doesn't exist it will error, we don't care, just move on
Application.DisplayAlerts = False
TheWB.Worksheets(RuleSheetName).Delete
Hey guys, just a quick stop in today to let you know that the IDE hijacking focus when a new workbook is opened in Excel seems to be back.
i.e. I've got a workbook open with the IDE open. I open another Workbook & start scrolling through it. suddenly, I'm scrolling through code in the IDE while the throbber spins as it's parsing.
@ThunderFrame What's this doing in AddTestModuleCommand?
public override bool CanExecute(object parameter)
{
var app = _vbe.HostApplication();
if (app == null || _state.Status != ParserState.Ready)
{
return false;
}
// Outlook requires test methods to be located in [ThisOutlookSession] class.
//return app.ApplicationName != "Outlook";
return true;
}
That can be removed, right?
We don't need a Ready state to add a module, nor do we need to check the host anymore, right?
@Hosch250 IIRC, I only commented out the return app.ApplicationName != "Outlook"; but left it there as a reminder of Outlook's awkwardness. The Outlook lines can be removed.
furious, repetitive refreshes tends to fix it for me.
yep, ghost projects are caused by referencecounts not being 0, IIUC. Rubberduck isn't the only addin that can cause this. IIRC, Power Query addin causes similar issues.
> Interop Forms Toolkit 2.0 is a new bridging tool allowing developers to use .NET Forms and .NET UserControls in VB6. This tutorial demonstrates how to add webservices, multithreading, and XAML to VB6 projects.
yep, that's excellent. to me "stable" means we no longer get new issues about a crashing host app, that the resolver works as it should in all known cases, inspections yield zero false positives caused by bugs, quickfixes work as intended, refactorings work as intended, SC works as intended, ...basically all features work as intended
> I can verify that. It goes through parsing, and starts resolving (uses a lot of CPU for some time while doing this) thereafter it just stays in resolving at 0% cpu. I am using latest 2.0.2b.
> true, it should not.. I do not have a newer version here at the moment, but can try in a day or two to see if there is any difference and will report back.
I thought I'd give a shot at creating my own version of dealing 5-card hands to n players in VBA, printing them to columns and coloring hearts and diamonds red.
I felt I might have been a little repetitive and I had to jump through some hoops to avoid ByRef. Anyhow, what can I improve?
Option E...
VBA Rubberducking
VBA Rubberducking