All Questions
29
questions
0
votes
0
answers
44
views
Faster method to check if a string is found inside Word Files in a directory and subdirectories
I need to check if a string is found inside a Word File in a directory and subdirectories.
I have tried to use Advanced Search of MS Windows 10, to search inside ...
6
votes
1
answer
447
views
Fastest function to `Remove Duplicate Lines` per each cell
The below function is used to Remove Duplicate Lines per each cell.
It works without problem, but it is slow with a range of only one column and 17k rows.
Actually, ...
3
votes
1
answer
300
views
Create VBA string array fastest method
My VBA has become really rusty but I need it for now for some data downloading.
This routine works but I'm certain that over the last 10 (at least) years something quicker/less code has surfaced to do ...
4
votes
3
answers
474
views
Excel VBA code midStr() function using left and right position instead of length used with mid()
In the early days of Basic (1970's when i started coding) the midStr() function used left and right positions directly rather than left and length we now use with mid(). I always found it more ...
4
votes
2
answers
930
views
Excel VBA Code for Imperial Length Measure Conversion and Formatting Yards Feet and Inches for English and Spanish
STR2INCHES is an Excel VBA Function that will convert string text for Imperial length measurements to a decimal number of Inches.
It handles both English and Spanish words, abbreviations and symbols ...
5
votes
1
answer
116
views
Similarity between words
I'm writing a method that writes the code for a loading routine.
Given an object from the database, I want to put its properties in the right control on a userform.
I have the list of the properties ...
1
vote
2
answers
51
views
Trimming strings in non-contiguous spreadsheet ranges
This code is tested and works, but I am needing some guidance on simplifying these loops with non-contiguous ranges. I was thinking an array might be better, but I ...
4
votes
1
answer
329
views
VBA Text Class, sort of like .NET
This is my first attempt at writing some reusable OOP code. The problem I'm trying to simplify is the confusing (at least to me) structure of VBA string manipulation.
Example
...
1
vote
3
answers
721
views
Excel VBA Retrieving a Specific Pattern from String
The following VBA code is in response to a SuperUser question which I found interesting.
What I'm looking for in a response?
Code cleanliness. Can I do more to make the code easier to read and ...
3
votes
1
answer
232
views
Safely and efficiently parse and replace tokens in a string
I have written a VBA function that will do parsing / replacement according to tokens / placeholders.
Example:
Input string: Username %u, date is %d.
The function ...
1
vote
1
answer
87
views
Transforming the case of text using Excel VBA
I created a simple user form for my VBA course.
I then created the following VBA code:
...
6
votes
1
answer
505
views
Replace function in VBA
For reasons I'd rather like to not talk about, I am in a VBA environment that doesn't have the replace function (Access 97). I have wrote this to alleviate my frustrations.
My question is, what is ...
1
vote
1
answer
56
views
Add spaces around variable with $ symbol bookends
I have some code in a particular coding language, and I am trying to clean it up by adding spaces around the variables. I wrote this code, and it works on small amounts of text and if I set a break ...
3
votes
1
answer
116
views
Return a substring containing a certain pattern to VBA
I've written in a C++ dll the following function to return to VBA a substring containing a certain pattern, given an input string, which contains that substring:
...
6
votes
3
answers
204
views
Rubberduck Test Module Creation
I recently started learning C# and am taking the opportunity to try and accelerate my introduction by helping the RubberDuck team (Website and GitHub Repo). The full class code that I'm working on can ...