Your input is 1, so you output "POSITIVE" or whatever it is that your logic is supposed to do. Now do you know where to output? What do you need to do with the results?
Public Sub NatureOpinion(pOpinionId As Long) Set rstNatureOpinion = Storage.GetDataSource("Volcano", "RstToNatureOpinion", AccessMode_ReadWrite, pOpinionId).Rst End Sub
@RubberDuck I gave up SU because some of the people there are not very nice - but still recommend that site for quite a few Qs posted to SO (though mainly installation/short-cut keys/charts and the like). Formulae I like HERE and would point out that often people ask for, say, VBA and seem delighted with other solutions - which they would miss out on if formulae and the like were exclusively SU.
@RubberDuck I deleted my meta 'answer' re macros for lack of interest but did mean to ask whether you might want the stats to show progress. (I gave up when the only changes seemed to be those I made and after about 2,000 was not prepared to continue unassisted).
Evidently the conversion from Excel file to text file must have carried over some meta-data with it that VBA probably went WTF when I tried to shove it into a String lol.
My original code looping over the array later works just fine now too
@RubberDuck You have done more than your share, are adding much greater value elsewhere and there are ~9 million others that might (but don't!) shoulder at least a straw or two each of the SO burden. Anyway SE is partly the issue (for not making mass edits easier). mehow deleted about 500 [vba] tags in the space of a few hours - shame they weren't [macros] instead!
well the Twitter account says "Rubberduck is a COM add-in for the VBA Editor (VBE) that provides an amazing range of functionalities that take programming in VBA to a whole new level"
There are only two hard things in Computer Science: cache invalidation and naming things. – Phil Karlton How many VBA modules declare variables looking like this: Dim v As Long, vWSs As Variant, Mrange As Range, Vrange As Range Or like this: Dim i As Long Dim LR As Long How many procedures have cryptic […]
I have two objects that need to interact with each other one is called Collateral the other is called Model. Model is an abstract Class is implemented by Model_A, Model_B, Model_AB. Each Collateral object has a collection of models as one of its properties. In order to initalize each Model I will...
I like what you're doing. VBA has no constructors, so you're right, you'll need factories; Class_Initialize cannot be parameterized, and runs before any other code in the class - so you can't use it as a constructor. — Mat's Mug23 secs ago
I wrote 3 subroutines related to batch data processing, they will be used together. A bit of background, I wrote this for my admin colleagues who do not write code. An application dumps daily .ack files onto a shared drive which contain data processing messages (success, errors, etc.).
I wrote ...
First, lets answer your question. How can you dynamically create instances of different class that all implement the same interface? As was pointed out, VBA doesn't have any constructors, so you're correct. A Factory Pattern is called for here.
How I tend to go about this is define a public enu...
> It can be easy to make a small error that causes an infinite loop, which can mess up things and crash the VBE. It would be nice if Rubberduck could catch an infinite loop at compile time (or at another time besides run time, whichever is most ideal).
> If this inspection happens, expect a bunch of other ones too, like ConditionIsConstantInspection ("condition always evaluates to 'true'" or "condition always evaluates to 'false'"), and other things I can't think of at the moment.
Well, TTGH. I feel like I actually accomplished something of much more value than my normal day-to-day stuff. It's going to save a lot of man hours and customer frustration/escalations. Back in a bit from home.
I wrote 3 subroutines related to batch data processing, they will be used together. A bit of background, I wrote this for my admin colleagues who do not write code. An application dumps daily .ack files onto a shared drive which contain data processing messages (success, errors, etc.).
I wrote ...
First, lets answer your question. How can you dynamically create instances of different class that all implement the same interface? As was pointed out, VBA doesn't have any constructors, so you're correct. A Factory Pattern is called for here.
How I tend to go about this is define a public enu...
VBA Rubberducking
VBA Rubberducking