that would be more readable and you still get strong typed. You just lose out the convenience of having one method to do both single add and several adds.
sure, if you'd rather have a single method & a runtime check
"let's not worry about types and just pretend the noobs know what they want and if they give us wrong types, we'll just pull our best guess out of our posterior! What could possibly go wrong?"
@theVBE-it'srightforme Builder isn't a very common or particularly useful pattern - it does make pretty cool, fluent code. The trick is that all builder methods except Build (it returns your IThing) return this (C#) / Me (VB*)
i meant i didnt get it when i saw it mentioned other places
like once you introduced the concept of design patterns i looked them up
or tried to at least
@this that must be what im noticing when i try to actually implement
anyways back to the param array thing i tried having it marshal explicitly as a ByValArray with the element type of variant but that did not work because it only applies to fields
i imagine VBA is throwing a fit because one little thing is off but i really have no way of knowing easily what it is :/
i wish there was another VBA library written in C# that had a paramarray method somewhere to make it easy
i get structurally how to use a custom marshaller now but i have no idea what that custom marshaller would need to do to make it work
@MathieuGuindon the weird thing is that I didn't find any documentation and kind of half-expected that param object[] wouldn't work across COM but to my surprise, it does.
(at least as reported by @theVBE-it'srightforme, anyway)
That said, VBA/VB6 never had strong-typed ParamArray, so that would be a new feature in C#/VB.NET and thus not directly translatable.
Maybe one can write it as public Add([MarShalAs(UnManagedTypes.SafeArray, typeof(object))] params int[] Items) but that'd just mean you get a Add([Items() As Variant]) in VBA/VB6 -- no compile-time validation.
I've found this explanation on Wiki on how to validate an IBAN.. Since the number generated from the transformation can cause overflow with all data type available in vba I've worked with string and I'd like to have someone else review.. Thanks in advance!
From Wiki:
Check that the total IBAN l...
> I kind of like this idea very much, but the multiple-cells address string makes me wonder.. I think we'll need a regex that can find cell addresses in a string literal. How thorough do we want this to be? What if `D$27` is used as an argument to some worksheet function or UDF? Are we only looking at string literal arguments passed to `Worksheet.Range`, or anything that could possibly *contain* cell references? Should we also validate the value argument to a `Range.Formula` assignment?
Normally I would use vbNullString for ZLS. However I Have a lame API where I must pass in a ""
and I thought to make it a variable... I don't think I even can make it a constant since that might just end up being like vbNullString (e.g. a null pointer, which will _not_work. The lame API wants a initialized pointer to a zero-length string)
the Properties is grayed out for a const in OB, so most likely VBA doesn't allow annotations but then again, it doesn't allow few features so who knows....
pseudo-HN just saved my sanity lol... set setupHourRange = .columns(3) set sampleHourRange = .columns(4) setupHours = .Index(setupHourRange,matchedRow) sampleHours = .Index(setupHourRange,matchedRow)
hindsight, had i grouped those more appropriately for the range then the value, it would have been just as apparent
in the case of relative "types" or "usage" i believe that falls into the HN-realm
copy; was going with "pseudo" as i didn't know the "app" convention was the appropriate name... had only typically seen discussions on the Type, e.g., rA As Range, sA As String
I try to properly qualify "Hungarian Notation" with "Apps" or "Systems" whenever I use it in my writing ...please don't hesitate to let me know if I leave "Hungarian Notation" unqualified anywhere.
When I change the logic to get the document name by first looking at the file name and using the caption as a fallback, should I add a new property DocumentName or simply change the implementation of ProjectDisplayName?
@M.Doerner are you using the BuildFileName method on the VBProject?
Given the volatile nature of caption, I'm indicated to keep them separate so we have more control over whether we want to take the caption which may contain garbage or truncations.
Well, the MoveToFolderRefactotingAction supports it now. That does not mean that a full implementation of the refactoring will not reject it in the validation step.
@MathieuGuindon in regard to your blog/writing, have you ever given a thought about having guest writers and doing a layman, intermediate, and expert, format for a topic?
my wife has been really tuning into the "explain science" or something on youtube, which has been trending quite a bit. they have a low level explanation, an intermediate explanation, and an expert explanation, of the same topic.
i'd think that just about any of us would be willing to help if you're looking to go that route, mat (given the near immediate feedback). just let us know topics and we could trial a shot
Trying to add intellisense to a function... changing the member properties doesn't appear to save. any immediate thoughts? process->find member, right click, select properties, type into the prompt, hit OK.
vbaproject is locked (i've currently got it unlocked)
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5387?src=pr&el=h1) Report > Merging [#5387](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5387?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/dc732efef8fb3a7ced16e4af16e3257ed10fea11?src=pr&el=desc) will **increase** coverage by `0.17%`. > The diff coverage is `86.6%`.
I've found this explanation on Wiki on how to validate an IBAN.. Since the number generated from the transformation can cause overflow with all data type available in vba I've worked with string and I'd like to have someone else review.. Thanks in advance!
From Wiki:
Check that the total IBAN l...
VBA Rubberducking
VBA Rubberducking