All Questions
7 questions
8
votes
0
answers
122
views
Faster VB6 / VBA class deallocation
VB6 / VBA is slow to deallocate class instances
VB* class instance deallocation becomes exponentially slower the more instances of that particular class there are.
Quick test. You will need:
Guido's ...
- 1,626
2
votes
1
answer
179
views
Create a string "Build" number for procedures and module
The class assigns various strings to the build number. So the build might look like 3.4.5.1 which would be of the format ...
- 121
4
votes
1
answer
240
views
Using OOP/Class Module called "FastMode" to toggle Application object properties in Excel
I'm programming a tool in Excel which reads two exported .csv files, performs some calculations based on Dates and Strings and ...
- 279
10
votes
0
answers
2k
views
Private VBA Class Initializer called from Factory #2
About
This is a follow-up of a previous question Private VBA Class Initializer called from Factory. I've decided to create a new question instead of answering my old question because I would like the ...
- 1,626
8
votes
1
answer
551
views
Private VBA Class Initializer called from Factory
I've been playing with COM lately and while getting to understand the mechanism of how class methods/properties are called an idea came to mind: what if we can have a global instance of a class that ...
- 1,626
0
votes
1
answer
868
views
Excel vba: the same code becomes slow if get properties are added to a class
I have a main sub that makes use of a Client class: creates an array with 100 000 Clients ...
- 131
12
votes
3
answers
7k
views
Parameterised Constructors
Finally, Parameterised Constructors are possible in VBA.
Background:
One rainy day, I came up with an idea: take a static class and expose one property as default (like it was done in the Reverse for ...
user28366