All Questions
Tagged with vba object-oriented
85 questions
3
votes
0
answers
188
views
Simulating Objects with Collections in VBA
Background
I am writing a VBA module which requires the functionality of a custom object. This object will support "regular" functions (UDFs) within the module.
Due to reasons beyond the ...
- 511
4
votes
0
answers
418
views
A vehicle database in Excel
I'm looking for some help. I'm new to coding and have started creating this Vehicle database program in Excel for a friend to use.
He is wanting to be able to see all vehicles he owns, when ...
2
votes
0
answers
424
views
SQLite C/ADO VBA library with reflection
SQLite C/ADO VBA library with reflection
The SQLiteCAdo library is a VBA middleware facilitating access to SQLite databases. Its two subpackages provide alternative connectivity options: via ADODB/...
- 415
1
vote
1
answer
119
views
Predeclared class instance tracks the number of regular instances
Predeclared class instance tracks the number of regular instances
In VBA, predeclared class instances can act as object factories, and in general, it makes sense to keep this instance stateless. ...
- 415
4
votes
0
answers
625
views
VBA class managing loading DLL libraries
I am playing with a custom-built SQLite library intending to access it from VBA via the C-language API. I keep the library within the project folder, so I load it via the LoadLibrary API. To make the ...
- 415
1
vote
1
answer
237
views
DbRecordset: Updatable recordset with transaction and affected rows count check
DbRecordset is a new class added to a fork of the SecureADODB library, which wraps the ADODB.Recordset class. It complements the functionality of the DbParameters class from the previous post and ...
- 415
2
votes
0
answers
99
views
Extending the SecureADODB library
SecureADODB is a very instructive VBA OOP demo. I have played with SecureADODB for a while and plan to integrate it into the prototype of my database manager application. In my previous post, I showed ...
- 415
4
votes
1
answer
248
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
5
votes
1
answer
158
views
Copy Columns Forward Macro: From Procedural to OOP
Background: I had created a macro few years ago and when I was reviewing this now, it was hard to understand.
I recently went through all the articles from ...
- 163
2
votes
0
answers
83
views
Modeling data from Excel sheets to parse to Excel sheet
Background:
I have close to 50 excel files - I cannot change the data source - and I steadily get more.
My task is to make sense of all that data and, lo an behold, save that as another excel file (I ...
- 121
11
votes
0
answers
360
views
Host-Agnostic Model-View-ViewModel Infrastructure
I've written an API that unlocks some serious MVVM capabilities with VBA's MSForms UI framework.
This is the complete code-behind for an example ...
- 75.5k
6
votes
1
answer
184
views
Creating a Chart Worksheet from scratch with VBA / OOP Design
I recently posted some code for review, and am now looking to gather some feedback on my latest implementation with that code. Yes, I have fallen into the OOP rabbit hole (thanks Mathieu Guindon) and ...
- 113
3
votes
0
answers
85
views
Setting a forecast for 2,5k workers intraday for a whole month
I'm working on a large project that requires a ton of data to be processed. I was thinking that using classes would be the best way, and it is, until it has to dump out the memory at the end of every ...
- 188
11
votes
3
answers
378
views
Secure ADODB: Unit of Work
I've been meaning to revisit this old code for a long time, and this week finally ended up doing it. The resulting code is on GitHub, and for full context and disclosure I wrote a blog article about ...
- 75.5k
6
votes
0
answers
135
views
An over-the-top approach to data entry
My goal: to make the already easy task of filling out an excel sheet 1% easier by putting in hours and hours of effort. On a more serious note, I'm currently developing a system to manage inventory at ...
- 133