Hi folks: I posted a SO (https://stackoverflow.com/questions/57541246/optimizing-vba-function-loop) and was told to ask here.
I am starting to think that rather than relay on excel as my data repository, I should create a separate class that holds a variant array that I can then query must fast...
Welp, I managed to write an unit test that passes in VS runner, but fails in Resharper's runner. If I fix it to pass Reshaper, it fails when running with VS.
Possibly. I know very little beyond the fact that a common trend is to try and obscure the VBA payload
AIUI, they actually do very little in VBA; they just shell out to something else but they have to obfuscate the script that they execute via Shell or equivalent.
VBA may not be as expressive, but it'll still need much more, possibly just as many because of all the weak typing and implicit conversion voodoo that goes on
just checking --- would you consider this smelly code? Keep in mind I cannot do DI in this context because this class get created by VBA caller indirectly:
private readonly ComMocked mocked;
private readonly SetupArgumentResolver _resolver;
private readonly SetupExpressionBuilder _builder;
public ComMock(Mock mock, Type type, IEnumerable<Type> supportedInterfaces)
{
Mock = mock;
_resolver = new SetupArgumentResolver();
_builder = new SetupExpressionBuilder(type, supportedInterfaces, _resolver);
Mock.As<IComMocked>().Setup(x => x.Mock).Returns(this);
mocked = new ComMocked(this, supportedInterfaces);
note that the type and supportedInterfaces are simply forwarded to the resolver which the ComMock creates for its use.
Had a brain tickle regarding the settings windows. IIRC we have OK and Cancel. Would it be better to change OK to Save since changed settings won’t be persisted otherwise. Makes me think of following the principle of least surprise.
@MathieuGuindon it's actually not the root; it's one level down from the root (MockProvider). I suppose the MockProvider could have provided the factory or created the resolved directly and pass it into ComMock class - it's more that I want to keep the dependency graph shallow as possible since I have no DI.
@MathieuGuindon I think it is always - the attribute simply helps with optimizing - I assume to bypass the EnumVARIANT enumeration or something, IDK.
No, I was answering the question about whether COM sees property let / get as two or one members
and also trying to find if it specify what happens if the disp id isn't the same. I do not think it is possible to have 2 different disp IDs for a let / get
If neither has the disp id set, then it won't be default member, so having one on only either is enough, apparnetly. I bet the same is true for the set (propputref)
I just checked. the id(0x0) does work on the others.
besides, if midl cared, it'd have yelled at me.
The trouble, though is that while we can see that VBIDE's OB will pick up the default member from either Let/Get, it doesn't say whether it does so by checking both or whether that the ITypeInfo has the appropriate attribute set for all let/get/set.
Hi folks: I posted a SO (https://stackoverflow.com/questions/57541246/optimizing-vba-function-loop) and was told to ask here.
I am starting to think that rather than relay on excel as my data repository, I should create a separate class that holds a variant array that I can then query must fast...
VBA Rubberducking
VBA Rubberducking