I made an immutable list class using the head-tail idiom. If I did this correctly, it implements persistent data structures. Unfortunately it doesn't scale well as VBA is not tail recursive. Note: I use a method called seq.Assign to handle assigning objects without using Set. I would like to ...
internal static class CodePaneExtensions
{
public static Selection GetSelection(this CodePane code)
{
int startLine;
int endLine;
int startColumn;
int endColumn;
code.GetSelection(out startLine, out startColumn, out endLine, out endColumn);
return new Selection(startLine, startColumn, endLine, endColumn);
}
}
VB6 and VBA
Not sure if this qualifies or not, because it is calling a method of a class:
This goes in a class module:
Public Sub TheFunction()
MsgBox ("WTF?")
End Sub
Public Sub SomeOtherFunction()
MsgBox ("Expecting this.")
End Sub
And this is the "calling" code:
Private Decl...
@RubberDuck My hunch is the overhead is in interacting with the sheet, it's almost always faster to read a range into an array, manipulate it, then write it back to a sheet and I suspect for the same reasons
ironically I'm sort of back in there now with this Business Analyst job.. but I report to the CEO and if I say I need SQL Server 2014 Standard, .. I'm getting it ;)
One of those "if it works don't break it while fixing it" things... but I hate leaving that sort of stuff in code since, well, just because it works for a while doesn't mean it will work forever
You (and Eric) are right that it probably isn't necessary and to only do it if you have problems. Sometimes I forget that I've seen some of the office products pushed way beyond their limits
@RubberDuck maybe I should switch some of that stuff to ADODB huh, I forgot I had some of that lingering in my project... I've been exlusively using ADODB for quite some time but have some legacy methods using DAO (woops)
@vba4all Making that change makes the Class_Initialize event of FactoryTest fire. Which in turn makes Factory's Class_Initialize fire, but it cFactory_AfterInitialize still doesn't.
> You cannot publish local branch master to the remote repository origin because a branch with the same name already exists there. You might want to rename your local branch and try again.
@Fitzroy oh, I check for all "likely errors" - I'm only using the error handler for non-testable (generally related to external libraries doing things which are more difficult/impossible to validate first)
I don't like code that relies on the error handler to get you out of trouble. You should think about all possible scenarios and cater for them. When something calls the error handler - see if you can use pre-emptive checking to avoid that ever happening again.
hey I even tried to make a property Private - because that would hide it from intelli-sense and also make it default at the same time but that failed...
there is just so much of it it overwhelms me ... i start reading a book on WPF get to chapter 5 or 6 and then suddenly I have to go so something else not in C# and WPF and by the time I am done doing something else I already forgot all the good stuff I read ... Labors of Sisyphus
I made an immutable list class using the head-tail idiom. If I did this correctly, it implements persistent data structures. Unfortunately it doesn't scale well as VBA is not tail recursive. Note: I use a method called seq.Assign to handle assigning objects without using Set. I would like to ...
VB6 and VBA
Not sure if this qualifies or not, because it is calling a method of a class:
This goes in a class module:
Public Sub TheFunction()
MsgBox ("WTF?")
End Sub
Public Sub SomeOtherFunction()
MsgBox ("Expecting this.")
End Sub
And this is the "calling" code:
Private Decl...
