> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5390?src=pr&el=h1) Report > :exclamation: No coverage uploaded for pull request head (`RemoveProjectSCWFromProjectDeclaration@433a57b`). [Click here to learn what that means](https://docs.codecov.io/docs/error-reference#section-missing-head-commit). > The diff coverage is `n/a`.
if (!(ManagedObj is object[])) { throw new SystemException("ParamArray custom marshaler works only with an array of objects.");
object[] prms = (object[])ManagedObj;
IntPtr[] prmPtrs = Array.ConvertAll(prms, new Converter<object, IntPtr>(GetNativeVariantWrapper));
General VBA question: I've noticed that in some of the code posted on CR, VBA is put into a Class instead of Standard module, even though it's not written as a "class". What is the benefit of doing so?
The strategy pattern is a specific targeted action. Suppose you want a Score(anObject) method to return a Long result of a Score. There are many ways to get it and based on the passed in object may be done very differently. THe only requirement is that it return a Long.
the interface says "here's your grid, here's a ship, tell me where you put that ship" and "here's the enemy grid and everything you know about it, now tell me where you're shooting" - the actual implementation for these methods depends on what strategy is used.
@MathieuGuindon I have leaned a great deal about OOP from studying Battleship. It seems that the Strategy Pattern occurs very frequently. Is that your experience in the development you do?
looking at the "DoFactory" method @SmileyFtW provided , it looks like a "standard" Interface and some Implementations. At least based on my reading through to the Structural code in C# section... Am I missing something that should be obvious?
Different question: When I Ctrl-space in the VBIDE looking for a function name so I can set the return value, Intellisense provides 2 options. 1 is a Function and the other is a Property. I think I understand why:
Within the function itself, I can call the function, assigning its result to a local variable, or I can assign something to the return value property of the function. However, outside the function definition, I can only reference the function, and can choose to store (or otherwise use) the return value of the function, but don't have "internal" access to the function "property"
@SmileyFtW Ctrl-space causes auto-complete of the currently being typed word, or it will show Intellisense if there is more than one option based on what's currently been typed
@this that's what I thought. And, since there's no difference in spelling (or casing - as if VBA cared), it doesn't matter which one I select, correct?
@SmileyFtW <--- logs out. goes home
And, of course, when Ctrl-spaceoutside the procedure, only the procedure name with the green procedure icon appears - there is no 2nd option.
I'm very happy that his ping-name still starts with "Mat", I don't know how many times I've started to write "@Mat'sMug" just to realize that that's no longer his name.
Bang notation is hardly ever more explicit though. Square brackets wouldn't be inside the " double quotes unless they're actually part of the field name. Anyway yes, it looks like OP is treating table columns as TableDef (or whatever MyTempTble is) properties. Most likely the answer boils down to making the LHS actual valid member calls e.g. .Fields("Dangerous Goods").Value = MyRst.Fields("Dangerous Goods").Value, but I'm not posting a blindfolded answer. Maybe the valid member call is .Columns or something, no idea. OP just needs to re-type that . dot and pick an existing member. — Mathieu Guindon1 min ago
> no it's completely different! See Selection is evil in Excel, but something else entirely in Word! Different thing! What do you mean "type library"? Irrelevant details! Different language!
@MathieuGuindon as much as i agree with that, i would rather have each of those tags available to make for easier searching for older questions (i believe that is part of why they havent been removed completely). since we can now have "combo" tag favorites, it's not as important, but it does serve a functionality purpose beyond holding with antiquity
just going into SO's search; if i use [vba]+[exce] i get both tags, etc. searching just "vba" gets everything tagged as vba and some posts that include vba within the text.
when i am marking duplicates, that's generally where i use the SO-search bar, as opposed to google's
which is where i first noticed the [Excel-VBA] versus [Excel]+[VBA] issue
IDK, to me it's a matter of calling a cat a cat. You want VBA posts, look for vba posts. If VBA posts are inconsistently tagged with whoever wants a tag for their host application "VBA flavor" BS, then how it's affecting search is irrelevant: there's a language tag that's fragmented into a bunch of stupid tags that shouldn't exist.
if i have to turn on microsoft scripting runtime and microsoft outlook 16.0 library, from excel, then that limitation helps break immersion for the beginners, which perpetuates the concept of "separate langauges" despite them syntactically being identical
@MathieuGuindon that wasn't tied to the tags, but to answer your question i tag excel-vba and have outlook as an additional tag; iwas additional to the "hopefully not seen as stupid" question i posted a couple lines before that statement
well, i should say "would have"; since the burninate noteice its been excel, vba, and outlook, as 3 tags
i was mostly asking about the references; is it truly that big of a memory allocation to have default references for each host?
as long as there's a vba tag somewhere, other host tags are pretty much irrelevant (as long as OP mentions what host they're in if it's relevant and not obvious)
will pull my question from earlier back down... not tag-related, but perpetuation of "different languages" despite identical syntax: why not leave in the references for each by default *in the IDE*, then, so you can have equivalent use? Is it truly that big of a memory allocation to have default references for each host?
i don't know why i have to select my references for a module to be "microsoft runtime scripting"... does it have some type of memory allocation or what? at the end of the day, the references for microsoft outlook 16.0 library, etc., still exist, and to someone "new" those are not native, ergo are different
what was the purpose of not enabling all of them from the get-go?
@MathieuGuindon yes, the "enable all" is a bit of exaggeration... i am curious about the big 3, word, outlook, and excel, not being default references. i have literally heard people say "you need to turn on the references so the other language can be used."
yes? the scenario that comes to mind, where i had someone verbatim make the quoted statement about it being another language, was for automating an email from VBA. the person had the outlook references dimensioned and coudlnt' figure out why it didn't work. his response, which i overheard, resolved the issue (to turn on the reference), but perpetuated the idea that they are different languages
@MathieuGuindon reminds me of king of the hill: "dad, what do you do if someone asks you to make their steak well done?" "you ask them firmly, but politely, to leave"
whatever. Variant/Empty should have been Variant/Null, but the Excel folks would have been confused. So they made "blank" cells Variant/Empty, but now the Excel folks are still confused, so ...net gain: complexity.
For the reasons why they are mainly Variants is two fold: 1) they need to conform wot Automation which is a strict subset of COM, and one of the rule is that you must use automation-compatible types. Thus, Variant for lot of primitives. 2) it's easy and fun to use when you can assign "1" or 1 or #1899-12-31# and still get the same result.
@IvenBach keep in mind that a Range can refer to not just one, but multiple cells - each with different fonts, interior color, text-wrapping, orientation, etc.
TBH the problem is that Range is literally being too many thing at once, but that's another issue
@Vogel612 but Variant/Error is still distinct from Variant/Empty or Variant/Null, so not seeing why that is a problem. Variant/Empty really should be treated like garbage it is.
If A1.Font.Bold = trueand A2.Font.Bold = False then checking Range("A1:A2").Font.Bold` evaluates to Null. AIUI Variant is required to permit this because it's neither True nor False.
> I confirm the same problem as OP with the VBE shipped with Inventor but I believe it might be because Inventor starts the VBE with a reference to the "Autodesk Inventor Object Library" that Rubberduck does not like. I am on Win10 PC.
I confirm that Rubberduck is working well for me in Office365 Excel 32bit and Excel 64bit (i experimented with installing/uninstalling both just to see).
I confirm that Rubberduck works well for me in Excel **_until_** I add a reference to the "Autodesk I
> I confirm the same problem as OP with the VBE shipped with Inventor but I believe it might be because Inventor starts the VBE with a reference to the "Autodesk Inventor Object Library" that Rubberduck does not like.
I also confirm the same issue is experienced on previous versions of Autodesk Inventor Professional - i installed/uninstalled 2016, 2017 and 2020 - they all reproduce the undesirable behaviour.
I am on Win10 PC.
I confirm that aside from this issue with the Autodesk Inve
@mansellan Correction - it varies depends on the project of the currently selected item e.g. if a code window has focus, the window caption will be for the project of that code window, etc.
VBA Rubberducking
VBA Rubberducking