All Questions
5
questions
43
votes
4
answers
14k
views
A lightning-fast StringBuilder
In the process of trying to build a serializable data structure, I found myself building large strings, which gets very slow because VBA copies a string every time concatenation is performed.
To ...
20
votes
3
answers
3k
views
A CSharpish String.Format formatting helper
A while ago I implemented .net's string.Format() method in VB6; it works amazingly well, but I'm sure there has to be a way to make it more efficient.
I'll start ...
10
votes
3
answers
977
views
A more readable InStr: StringContains
Consider the following:
If myString = "abc" Or myString = "def" [...] Or myString = "xyz" Then
In C# when myString == "abc" ...
7
votes
4
answers
15k
views
Hex encoding and decoding of ASCII strings in VBA
I needed to convert some Ascii text to binary in Hex format 0x00FF....
I've written an EncodeHex and a ...
4
votes
2
answers
842
views
Extract a character at particular place in a string
I have a function:
...