@Hosch250 same as RD; needs a SlimDucky.Connect reg key under HKCU/Software/Microsoft/VBE/6.0/AddIns, and then you run 32-bit regasm.exe against your debug build, with /tlb /codebase switches
```vb Sub foo() Dim bar() As Long Dim dynamicUpperBound dynamicUpperBound = Second(Now()) ReDim bar(0 To dynamicUpperBound) ReDim bar(0 To 20) bar(1) = 5 Debug.Print bar(1) End Sub ```
Will need to look out for the usage of `Preserve` keyword.
Is there a way to get the name of a captured group in C#?
string line = "No.123456789 04/09/2009 999";
Regex regex = new Regex(@"(?<number>[\d]{9}) (?<date>[\d]{2}/[\d]{2}/[\d]{4}) (?<code>.*)");
GroupCollection groups = regex.Match(line).Groups;
foreach (Group group in groups)
{
Conso...
Indeed, no setup and the mock factory returns a null reference. But your test is setting it up to return a mock dialog which is setup to return DialogResult.OK
@Mat'sMug I think you're trying to tell me to pass the execute command the setup mockFolderBrowser... but I can't, ExportAllCommand requires a IFolderBrowserFactory because Ninject
There's a "strict" mode where anything not explicitly set up will throw an exception instead. I prefer it, but I didn't know what I was doing when I wrote that ^
@shadowofsilicon no. you setup your Mock<IFolderBrowserFactory> to return a Mock<IFolderBrowser>, and then you pass that mock factory to your command. Then you can test the command without popping a dialog.
You already had that setup code done when I checked earlier... what happened?
@ThunderFrame I had figured that out just recently... read something in Frech and wondered why they were clearly talking about the United States but were refering to it as E.U.
Don't remember what or where though... I might have been in Canada at the time...
@shadowofsilicon I can't can find the article now, but there was nearly an awkward diplomatic incident a few years ago when diplomats were going to have to sit around a table in alphabetical order. I forget which 2 feuding countries were going to be adjacent to each other, but a quick-thinking host switched the names into French... Crisis averted.
> But an eleventh-hour switch to French in a reworked table plan left the surprised Mr Kuchma seated next to the president of Turkey, seven places away from Tony Blair of "Royaume Unis" and 30 seats away from President George Bush of "Etats Unis".
@Mat'sMug Ok, I got it working this morning. For the .CreateFolderBrowser, I have to use the exact same parameters in the mockFolderBrowserFactory.Setup() that are used in the ExportAllCommand. Can someone explain to me why that is?
Anyone can confirm if 2.1 2020 handles jagged arrays? Can't remember..
Your code is doing too many things. One handler per procedure. You can't handle a new error while handling an error, you need to handle the first error first. On Error is useless inside an error handler, you're already in an error state, what do you expect to happen? FWIW this will soon be a Rubberduck inspection. — Mat's Mug10 secs ago
Have I ever mentioned how much I hate my less-experienced, a few months ago, self?
Sub Macro1()
Dim arrHolder() As Variant
Dim arrLastName() As Variant
Dim arrStudents() As Variant
Dim arrMatches() As Variant
Dim i As Long
Dim j As Long
Dim k As Long
Dim l As Long
Dim match As Integer
l = 1
arrHolder() = ThisWorkbook.Sheets("Default Report").ListObjects(1).ListColumns(2).Range.Value
arrLastName() = ThisWorkbook.Sheets("Default Report").ListObjects(1).ListColumns(3).Range.Value
2
@Mat'sMug I imagine so, assuming that there is an implicit type conversion of True to -1.
FWIW, I told this team I wouldnt keep parsing their data for them if they wouldnt update their survey to give me the thing I actually need. Now they literally have to put in a request for this data (for the next file) and they wont get it without fixing their survey.
And that code is so bad it literally isnt worth refactoring. It asks the user if the match it found is correct every time
@RubberDuck I contributed a couple of little bits. You're officially free to use those.
@Hosch250 I have no clue how the internals work, but would it be possible/reasonable to create/dispose of the WPF components on-demand/as-needed? If your theory is correct, that should minimize the number of windows to close on shutdown.
@Mat'sMug mockFolderBrowserFactory.Setup(m => m.CreateFolderBrowser("Select a directory to Export Project as Source Files...", true, @"C:\")).Returns(mockFolderBrowser.Object);
I think we might not need to do anything to clean up the dockables, VBE does it for us, or at least seems to in SlimDucky. Problem is what's in the dockables; I think we might need to inject factories and make the dockables own their stuff instead of leaving it to Ninject.
@contributors: AppVeyor build releases now include a link to the AppVeyor build. This means your PR descriptions become the "release notes".
@Mat'sMug - it seems that the issue number(s) resolved by a release are usually listed in the PR description. Is it possible to somehow make that a link for a quick & easy trip to see what was closed? Or do I just not know enough about how to use GitHub and it's already there...
if the description included a link, the browser would (might?) render it as a link? Or at least there'd be a quick copy/pasta to the address bar to go directly there.
I am trying to login to this webpage, https://www.fois.indianrail.gov.in/ecustomer/JSP/QryInsight.jsp
using VBA. Debugging shows me that the VBA throws an error 424 object required when username line is active (apparently it is not able to fill the username data).
Here's the code:
Sub Test()
...
@Hosch250 Eyewitness reports on the ground are already incredibly unreliable. Eyewitness reports of stuff moving at high speed thousands of feet up is nearly useless :P
@puzzlepiece87 I know... It makes sense but without proof it can't be much more than conspiracy theory. Sounds like something that would be discussed on the No Agenda Shownoagendashow.com
@Hosch250 Occam's razor: engineering is actually quite difficult and expensive, especially when asked to make an everything plane. Boeing/Lockheed Martin/other national security contractors have almost unlimited job security and contracts set up in a format that are to their extreme benefit. Therefore, they really are just wasting a ton of money on an everything plane.
@shadowofsilicon The US is also the EEUU in Spanish - Estados Unidos, with double letters because it's plural (like how some people use MM for millions)
Public Sub Register(ByVal logger As ILogger)
If Not this.Loggers.Exists(logger.Name) Then
this.Loggers.Add logger.Name, logger
Else
Err.Raise vbObjectError + 1098, "LogManager.Register", "There is already a logger registered with name '" & logger.Name & "'."
End If
End Sub
@Mat'sMug - Do I need to create a Release function to remove from this.Loggers?
@PeterMTaylor I read and enjoyed this article but only partly understand your question? Are you asking if I would enforce that SQL be written a certain way? If so, no, I learned from @Mat'sMug long ago not to try to parse another language (html, SQL, etc.) in VBA. In my mind, enforcing a convention would be too similar to parsing.
@IvenBach Note that I said it was a younger, less experienced me :). I never said I never used HN. Heck, if I never used it I wouldnt know first-hand how much it hurts one's ability to learn and grow!
I just tried to reduce what we are doing on shutdown and got the access violations down to just one. However, that one, which happens in the combase.dll, triggers the restart.
@Mat'sMug Make it so the parse can handle any input and create a valid parse tree down to a couple bad characters, and you'd be surprised at what would break.
I already found out that the SubclassingWindow did not guard against freeing its resouces twice in case Dispose is called multiple times. However, fixing that did not solve the problem.
That's totally dependent on the host application. No VBA host is obligated to even have a concept of an "active document", let alone for that document to have "variables". BTW it's PowerPoint, not PowerPony. — Mat's Mug12 secs ago
Is there a way to get the name of a captured group in C#?
string line = "No.123456789 04/09/2009 999";
Regex regex = new Regex(@"(?<number>[\d]{9}) (?<date>[\d]{2}/[\d]{2}/[\d]{4}) (?<code>.*)");
GroupCollection groups = regex.Match(line).Groups;
foreach (Group group in groups)
{
Conso...
VBA Rubberducking
VBA Rubberducking