ah yeah. from what i've seen it's not intrinsically web, think it can be used in a scripting context too. Not sure if there are UI framewroks for it though
> The Recorder object is used to record text into a single macro. Recording text in this manner typically occurs in response to user actions in the host application. While recording, if the Code window for the project item containing the recorded macro is visible, then the user can watch the lines as they are recorded.
@Comintern FWIW, if we hijack VB6, no reason why we can't hijack VBA; it'd be a matter of self-hosting and lying to the project that we're Excel/Access/whatever.
I remember him saying there are extra binary stuff that aren't documented in the stream. What I wasn't too sure about is whether host decide to add their own specific encoding
[Test]
[Category("AddRemoveReferences")]
public void TryAddReference_CallsAddFromFile()
{
var reconciler = ArrangeReferenceReconciler(null, out _, out _);
ArrangeAddRemoveReferencesModel(null, null, out var project);
var references = project.Object.References.Count;
reconciler.TryAddReference(project.Object, @"C:\Windows\System32\reference.dll");
var expected = references + 1;
Assert.AreEqual(expected, project.Object.References.Count);
The Assert relies completely on mocked behavior of the Mock<IVBProject>. Are we cool with that for testing to see if AddFromFile is called, or should I bust out a mock of References?
> The issue is with VBE, not with how we register our libraries. VBE has had exhibited strange behavior in how it choose to display libraries in a list and this has been observed even with Microsoft's own libraries such as shell32.dll.
For that reason, I'm inclined to close this as <kbd>status-bydesign</kbd> with the suggestion that the workaround is to use the upcoming reference explorer.
@Vogel612 Not yet - I want to, but keep getting sidetracked by RL. :/ I expect to be able to look at it tonight (might not work out due to wedding anniversary) or tomorrow otherwise. I any case: I've not forgotten about it. :)
@MathieuGuindon Hi there Mat. I only operate from ResX Manager so I translate all red field into Czech :-) So if Template.resx was localized, it was because it was in ResX Manager.
> Agreed! I get this feeling many will even forget what the VBE's Project References dialog even looks like in a few weeks... I'd suggest we default the RD libraries to the pinned tab.
@Phrancis Thanks for the tip! I just picked up a "very good" condition used copy for <$7. Once I work my way through that, I guess I'll no excuse to not fix the bugs I find on the duck
And nice to see you'll be back soon
erm.. used copy of Head First C#, to be specific, since there were 3 books in that picture...
Umm... what's the difference between Head First C# and Head First C# A Learner's Guide to Real-World Programming with C#, XAML, and .NET (other than the length of the title)?
Short title: this book covers C# 3.0 and Visual Studio 2008,
long title: Updated for Windows 8.1 and Visual Studio 2013,
both are somewhat out of date... are there enough differences between 2008 & 2013 that the newer one is worth it?
> You can also open, launch and debug WPF and Windows Forms projects in Visual Studio 2019 Preview 1. It is currently possible to open .NET Core 3.0 projects in Visual Studio 2017 15.9, however, it is not a supported scenario (and you need to enable previews).
again, my exposure is limited but AFAICT, python on desktop is primarily about scripting and getting stuff done rather than building GUI-based applications
This code survives the indenter exactly as formatted:
```VBA If col > reportSettings.FirstCol + 1 Then With .Cells(row, col).Interior If report.Cells(row, col) > report.Cells(row, col - 1) And _ report.Cells(row, col - 1) <> vbNullString Then ```` This version is indented to match the above: ```VBA If col > reportSettings.FirstCol + 1 Then With .Cells(row, col).Interior I
@Vogel612 true and there's actually more than one package manager to choose from, and heck you could change the package manager if you wanted and nobody'd notice (not counting the new crop of bugs resulting from the change...)
I have a excel that contains about 20 sheets. I have hundreds of calculations among those sheets. Is it possible for me to figure out a way to find how many memory is being used for each calculation?
Thanks.
A memory leak would be if the cached data remained in memory after the worksheet is closed. As long as it's opened, RAM consumption going up means nothing other than Excel allocating more memory for its purposes. — Mathieu Guindon7 secs ago
just wondering - does excel have a quick way for not creating extra rows when pasting in a bunch of text that contains line breaks? It messes up what should be a tabular format?
> I've just had a couple of head scratching hours due to defining a function with a parameter array in an interface.
To prevent compilation errors the class procedure also has to be declared with a paramarray. However the array received by the class procedure is consolidated into a single variant containing an array, rather than an array.
> To be clear, are you calling the class procedure from the interface?
If that is the case, then the workaround would be to define the class procedure as taking a `Variant` rather than an `ParamArray`. If the class procedure is public/friend, then both the class procedure and the interface procedure should call an internal procedure that takes a `Variant` rather than `ParamArray`.
Agreed about an inspection but need to think about how it's going to be handled.
> Not sure the interface is relevant. That's just a by-product of `ParamArray` being, well, a `Variant` array. A procedure with a `ParamArray` parameter should take steps to validate whether it's getting an array of values, or a single-element array containing an array of values. Any method passing a `ParamArray` argument to another method taking a `ParamArray` parameter, will be passing it as a single-element variant array holding the array of values.
I have a excel that contains about 20 sheets. I have hundreds of calculations among those sheets. Is it possible for me to figure out a way to find how many memory is being used for each calculation?
Thanks.
VBA Rubberducking
VBA Rubberducking