> Might be I'm blind, but I don't see the problem with the snippet there. Did you mean to make a Property Let accessor call? Please clarify what we're looking for here.
> I have just checked this against next and This didn't show up for me. Additionally the Code Quality Issues Inspections include "Object variable assignment requires 'Set' keyword" on my end, which don't show up here. Then again the order seems kind of messed up, because the other items don't show in that order for me ...
> The missing caption is "Public field breaks encapsulation", and the blank tooltip should be:
> **Public field breaks encapsulation** > Consider exposing a property instead.
@Vogel612 indeed, the sorting order appears to be different - I believe there is no sorting defined, the order they show up is determined by the order the types are reflected from the compiled assembly by the .net runtime... which is another issue, pointed out in #2193.
This could make the expression builder much easier, because at that point you can drag & drop tree nodes into the expression tree and generate your Regex out of that
@Mat'sMug I didn't override ToString anywhere. Haskell kinda made me lazy with it working just fine when you say deriving (Show) ... not that I'm doing much haskell
anyways. hitting the feathers
or to keep your rusty German in shape: "Ich hau mich aufs Ohr"
argumentExpression :
(BYVAL whiteSpace)? expression
| (LPAREN byvalExpression RPAREN | LPAREN argumentExpression RPAREN) # byvalExpression
| addressOfExpression
// Special case for redim statements. The resolver doesn't have to deal with this because it is "picked apart" in the redim statement.
| lowerBoundArgumentExpression whiteSpace TO whiteSpace upperBoundArgumentExpression
;
> The grid in the *Todo Settings* tab seems to resize correctly, but if the list contains more items than can fit in the height of the dialog, there's no scrollbar to access the overflowing ones:
I needed to convert some Ascii text to binary in Hex format 0x00FF....
I've written an EncodeHex and a DecodeHex function to do the conversion.
I've avoided using concatenation in favour of performance.
I'm assuming that assigning the results of CByte("&h80") to a byte array, and then using St...
Dear Mat's Mug, thank you for your detailed answer, you made me learning a huge amount of new vba features, and programming in general :) Unfortunatly, however, the code doesn't run because of this error : "user-defined type not defined", that is apparently related to this Public Sub AddValidationRule(ByVal rule As IRangeValidationRule) rules.Add rule End Sub....any idea? — Lollo1 hour ago
Hello! I've been developing a dll with .net and I am succesfully using it on excel VBA. But I still need each user to add the TLB manually to use the class. Is there anyway to have a .bat do this automatically?
That part is done. Your tweet helped me with that ;) And I tried copying your powershell. But it seems that it is intended for Add Ins rather than references. If that makes any sense.
Additionally this is the reason I need to register the TLB http://stackoverflow.com/questions/39372179/excel-vba-late-bound-net-com-class-object-reference-not-set-to-an-instance-of
There's a bug that only appears if the class is late bound and no tlb is referenced.
it gets annoying when your OSS project needs to start using code from other OSS projects with different licenses
like, very annoying
project A is under license XYZ which isn't compatible with license WXY used by project B, and so you're stuck either relicensing your own project, but then you were given piece of code ABC under the agreement that your project was under license JKL
that doesnt make any sense, the host document is already the variable "excelFile", with that piece of code I believe, you are trying to search a module with the name "ThisWorkbook" — Innat359 mins ago
@Comintern I'll read the whole thing when I get some time. Could it still be relevant considering The bug dissapears when late bound but the tlb is referenced?
@TomasZubiri Yes. If there isn't tlb information associated with the object, VBA has to use its IUnknown interfaces. If it does have tlb information it uses its IDispatch interfaces.
Yes - something like Application.VBE.ActiveVBProject.References.AddFromFile foo.tlb. You'd need programmatic access to the VBA extensibility objects though. Also, I'm pretty sure that you would need to exit completely afterward to force a recompile. Even if you didn't, I wouldn't try using a programmatically added reference without recompiling. That seems like a good way to crash the host application.
@Comintern RD adds (ensures there is, actually) a reference to the Rubberduck TLB and then immediately calls Application.Run to launch unit tests.. not sure a recompile is required - but then again, it's a VBIDE add-in, not the workbook itself
Dropping vba in favour of VB.net gives us access to visual studio, which in turn gives us access to: Unit testing Tools Performance Profiling Tools Official Selenium Wider Library Community Wider and better stackoverflow community + documentation Better Code sharing Ability to run on server Source Control
And the language itself gives us Better error handling Better OOP support Better native error messages
Hmmm... So the late-bound just changes it to Private Assert As New Rubberduck.AssertClass and adds the reference. Is it actually executing the empty tests when you do that?
Then there would be a recompile forced by adding the reference. I was referring to something more like adding the reference, creating an object from it, and using it in one code run.
A Worksheet is a specific interface. That means a caller has to have information about the interface in order to use it (i.e. a reference to a tlb). If you pass an object and let the caller query for the interface, you're all good. It's basically the reason for COM and the answer to "how can we change interfaces without creating a dll hell?"
http://stackoverflow.com/questions/39372179/excel-vba-late-bound-net-com-class-object-reference-not-set-to-an-instance-of Added class code which I believe is the cause of the problem.
@Mat'sMug I attempted to answer this question, but I'm not sure I got it right, I only know what I've learned from you. You can probably knock this question out of the park - superuser.com/questions/1121971/…
> This is proving to be much harder than I anticipated.
I have a failing test using this code:
Sub Test() DoSomething (foo), (bar) End Sub
From the failing test's stack trace, the parser correctly identifies a `callStmt`, then an `expression`, and then a `lExpression`, and parsing fails at the comma.
The `lExpresion` rule has higher precedence than the `parenthesizedExpr` that it should be matching, however moving `lExpr` anywhere below `parenthesizedExpr` completel
@TomasZubiri It's calling the CostInfo property of Part that causes the error. If you can post the stubbed out class code, I can take a look at it after work.
The MSDN documentation for Worksheet.Paste method states, regarding the optional Destination parameter:
A Range object that specifies where the Clipboard contents should be pasted. If this argument is omitted, the current selection is used.
Since the current selection is on another workshee...
I needed to convert some Ascii text to binary in Hex format 0x00FF....
I've written an EncodeHex and a DecodeHex function to do the conversion.
I've avoided using concatenation in favour of performance.
I'm assuming that assigning the results of CByte("&h80") to a byte array, and then using St...
The MSDN documentation for Worksheet.Paste method states, regarding the optional Destination parameter:
A Range object that specifies where the Clipboard contents should be pasted. If this argument is omitted, the current selection is used.
Since the current selection is on another workshee...
VBA Rubberducking
VBA Rubberducking