Movatterモバイル変換

Question 1

2votes

0answers

187views

Indexing into Nested Data Structures in VBA

ProjectI have created a VBA module calledIdx which you may find here on GitHub. It is inspired bypluck() and ...

Greg

569

askedOct 22 at 21:14

Question 2

4votes

1answer

278views

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 ...

MDragon

51

askedOct 19 at 15:35

Question 3

1vote

0answers

115views

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 ...

MDragon

51

askedOct 9 at 6:42

Question 4

1vote

0answers

140views

Collection Utilities for VBA

BackgroundI am building a complex, standalone class. It has a property called.Mapping, which should behave like aDictionary....

Greg

569

askedSep 30 at 20:13

Question 5

6votes

1answer

117views

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/...

arcomber

2,531

askedMay 4 at 11:35

Question 6

14votes

0answers

603views

Faster VB6 / VBA class deallocation

For latest additions, see Edit sections at the bottom of this question.VB6 / VBA is slow to deallocate class instancesVB* class instance deallocation becomes exponentially slower the more instances ...

Cristian Buse

1,776

askedDec 11, 2024 at 14:06

Question 7

7votes

2answers

335views

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 ...

Luke Wood

71

askedSep 13, 2024 at 8:58

Question 8

3votes

1answer

174views

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 ...

safo2238

81

askedAug 31, 2024 at 13:37

Question 9

3votes

0answers

157views

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 ...

TinMan

4,328

askedAug 23, 2024 at 15:42

Question 10

3votes

1answer

151views

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,...

J. DeSantis

33

askedAug 13, 2024 at 23:27

Question 11

2votes

0answers

311views

Simulating Objects with Collections in VBA

UpdateI have released a prototype (v0.1.0) of my SOb project, which is a generalized framework for easily simulating objects.BackgroundI am writing a VBA module ...

Greg

569

askedJul 31, 2024 at 21:56

Question 12

4votes

1answer

169views

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 ...

mhabes

43

askedJul 31, 2024 at 19:58

Question 13

5votes

1answer

167views

Update Member "In Place" within VBA Collection

BackgroundI encountered this issue a while back, where I tried to "set" the value of a member "in place", without changing its position within the ...

Greg

569

askedJul 18, 2024 at 23:30

Question 14

3votes

0answers

400views

Fluent VBA: Two (Almost Three) Years Later

Part 1 - A fluent unit testing framework in VBA: A fluent unit testing framework in VBAPart 2 - Fluent VBA: One Year Later: Fluent VBA: One Year LaterTwo (almost three) years have now passed since I ...

Brian Gonzalez

209

askedJul 17, 2024 at 12:09

Question 15

-1votes

1answer

83views

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 ...

WhiteRaven76

7

askedMay 22, 2024 at 17:57

Movatterモバイル変換

Stack Exchange Network

Questions tagged [vba]

Indexing into Nested Data Structures in VBA

Using Lightweight Objects in VBA

Counting the number of instances of a class module in VB*

Collection Utilities for VBA

Excel Bookkeeping Application, Create Ledgers from Chart of Accounts and Journal

Faster VB6 / VBA class deallocation

VBA: Efficiently Organise Data with Missing Values to Achieve Minimum Number of Tables

VBA code used to build a diverse portfolio of DFS lineups to minimize risk

Evaluating WinAPI, PowerQuery, PowerShell, and FileSystemObject for File Retrieval Using VBA

Search through all the sub-folders in a given folder for files

Simulating Objects with Collections in VBA

Speed up recursively looping through network folder and subfolders in VBA

Update Member "In Place" within VBA Collection

Fluent VBA: Two (Almost Three) Years Later

Need assistance modifying a "too large" procedure [closed]

Hot Network Questions

Subscribe to RSS