Questions tagged [vba]
Visual Basic for Applications (VBA) is an event-driven programming language first introduced by Microsoft in 1993 to give Excel 5.0 a more robust object-oriented language for writing macros and automating the use of Excel. It is now used for the entire Office suite and over 200 non-Office hosts.
1,295 questions
4
votes
1
answer
186
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
100
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
1
vote
0
answers
120
views
Collection Utilities for VBA
Background
I am building a complex, standalone class. It has a property called .Mapping, which should behave like a Dictionary.
...
- 549
6
votes
1
answer
113
views
Excel Bookkeeping Application, Create Ledgers from Chart of Accounts and Journal
I am writing an Excel bookkeeping application that would be suitable for a small business or contractor. The application is based on a book on double entry bookkeeping:
https://www.amazon.co.uk/gp/...
- 2,531
12
votes
0
answers
542
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,746
7
votes
2
answers
312
views
VBA: Efficiently Organise Data with Missing Values to Achieve Minimum Number of Tables
The task is to create sub-tables from an original table (like below) that contain the missing data columns (missing data is highlighted in red). The important part of this task is to make the smallest ...
- 71
3
votes
1
answer
158
views
VBA code used to build a diverse portfolio of DFS lineups to minimize risk
This code works great and does exactly what I want but it takes around 10 minutes for the code for find 150 lineups. I am hoping to get help and learn how to make it much faster.
The goal of this code ...
- 81
3
votes
0
answers
149
views
Evaluating WinAPI, PowerQuery, PowerShell, and FileSystemObject for File Retrieval Using VBA
Traditionally, VBA developers rely on the FileSystemObject to retrieve files within a directory. I decided to test and compare different methods (Windows API, PowerQuery, PowerShell, and ...
- 4,328
3
votes
1
answer
135
views
Search through all the sub-folders in a given folder for files
I use the below code to loop through a list of data and search through all the sub-folders in a given folder for files which match my requirements.
Right now it takes this code about 22 minutes to run,...
- 33
2
votes
0
answers
288
views
Simulating Objects with Collections in VBA
Update
I have released a prototype (v0.1.0) of my SOb project, which is a generalized framework for easily simulating objects.
Background
I am writing a VBA module ...
- 549
4
votes
1
answer
165
views
Speed up recursively looping through network folder and subfolders in VBA
I'm trying to loop through around 100k files in varying degrees of nested directories using vba and md5 hashing each of those files. Right now, the current state of the program takes around 1.5 to 2 ...
- 43
5
votes
1
answer
151
views
Update Member "In Place" within VBA Collection
Background
I encountered this issue a while back, where I tried to "set" the value of a member "in place", without changing its position within the ...
- 549
3
votes
0
answers
394
views
Fluent VBA: Two (Almost Three) Years Later
Part 1 - A fluent unit testing framework in VBA: A fluent unit testing framework in VBA
Part 2 - Fluent VBA: One Year Later: Fluent VBA: One Year Later
Two (almost three) years have now passed since I ...
- 209
-1
votes
1
answer
79
views
Need assistance modifying a "too large" procedure [closed]
I have a chunky VBA script that needs some help making it efficient, which I think will correct the "Procedure too Large" issue I just ran into.
I run the procedure from an open workbook ...
-3
votes
1
answer
76
views
Multiple key swap algorithm [closed]
I have a dictionary with key - data pairs. My data comes from excel sheets. When I create the dictionary my objects are placed in order by their keys ex. 1 -> data of sheet1, 2 -> data of sheet2 ...
- 3