Questions tagged [vb6]
Visual Basic 6.0 (VB6) is the "third-generation" event-driven programming language and integrated development environment (IDE) from Microsoft for its COM programming model. It was also considered a relatively easy programming language to learn and use, because of its graphical development features and BASIC heritage.
36 questions
4
votes
1
answer
279
views
Using Lightweight Objects in VBA
Lightweight Objects implementation in VBA7 (32/64-bit)
As shown here, VB* class instance deallocation becomes exponentially slower the more instances of a particular class module there are.
Cristian ...
- 51
1
vote
0
answers
115
views
Counting the number of instances of a class module in VB*
In VBForums I found the following post:
Is there a way of retrieving the number of instances of a VB* class from within the class itself?
One could store an instance counter in a Public variable in a ...
- 51
14
votes
0
answers
603
views
Faster VB6 / VBA class deallocation
For latest additions, see Edit sections at the bottom of this question.
VB6 / VBA is slow to deallocate class instances
VB* class instance deallocation becomes exponentially slower the more instances ...
- 1,776
6
votes
1
answer
432
views
ADODB Wrapper Class (Revisited)
I recently posted this question on my implementation of an ADODB Wrapper Class. I realized in my own review that I was missing some very important things, so much so, that I decided it would be worth ...
- 698
2
votes
1
answer
619
views
ADODB Wrapper Class
I use ADO (specifically for accessing SQL) daily at work. So, I finally decided that I was going to create a class that makes it simple for myself and other programmers on the job to use. Just the ...
- 698
5
votes
1
answer
273
views
App for providing accounting solutions for clients
I have a VB6 app that has existed for more than 7 years to which I have a few clients using it for their accounting solutions. Now my problem is that a particular client has grown so big with a 15GB ...
- 53
12
votes
6
answers
5k
views
Format RGB Long as hex string in VB6
This is how I convert e.g. RGB(255, 0, 0) (where red is stored in the least significant byte of a Long) to a 6-digit hex string <...
- 1,103
12
votes
1
answer
663
views
Shared VB6 *and* VBA extensibility add-in with OnConnect and OnDisconnect handling
Rubberduck works well enough when the VBE is of the VBA variety, but it currently only works when the Rubberduck is configured to load at VBA start-up, and it has a tendency to crash the host ...
- 1,959
9
votes
1
answer
8k
views
Multi-dimensional array sort and filter functions
As I said in my last post Multi-dimensional ascending and descending sort array function, I'm back with the final version of the code.
Added features:
Filter array function by following parameters: <...
- 313
4
votes
2
answers
273
views
Implementation of the Access version DBLookup() in VB6
I've tried to implement the access function DBLookup() in VB6 for a project I'm doing. Does anyone have comments on how well done it is and what could be improved? ...
- 330
8
votes
1
answer
649
views
Growing my own Tree (Structure)
Summary
VB6 doesn't have a great selection of data structures to work with, so again I find myself creating my own. I have a need to dynamically generate a directory structure on the file system. The ...
- 31.2k
2
votes
1
answer
8k
views
Calling Stored Procedures with Lots of Parameters
I have this piece of code for running a Stored Procedure, and I was wondering if there is a way of cutting code like:
...
- 315
5
votes
1
answer
2k
views
Converting to Roman Numeral with Recursive Algorithm
Summary
I'm getting ready to dive back into a "more proper" project, so I wanted to take a moment to get my TDD hat on before doing so. I decided to tackle this Roman Numeral Kata for practice. The ...
- 31.2k
15
votes
3
answers
6k
views
Building a better Collection. Enumerable in VBA
VBA's 'Collection' is.... lacking, so, I've been working on a better Collection object that implements many of the features of C#'s Enumerable. This is very much inspired by this question and a follow ...
- 31.2k
10
votes
2
answers
740
views
No more Fizzbuzz. How about Hello World instead?
Write a program that prints the numbers from 1 to 100. But for multiples of three print “Fizz” instead of the number and for the multiples of five print “Buzz”. For numbers which are multiples of both ...
- 31.2k