VBA Stringbuilder

[David G]

Hello,

I am just wondering if it is somehow possible to use any sort of
Stringbuilder class in VBA for excel macros to speed up multiple
string concatenations. And if so, how?

David

 

[Don Guillett]

not sure what you're talking about but

Sub makestring()
For Each c In range("d2:d15")
If c <> "" Then ms = ms & "," & c
Next c
MsgBox Right(ms, Len(ms) - 1)
End Sub

 

[gimme_this_gimme_that]

Dynamically you can create arrays and concatenate them using join :

Sub f()
a = Array("asdfa", "sfasdfa")
d = Join(a, ";")
MsgBox d
End Sub

 

[Tim Williams]

Here is a VB implementation which I've used in the past and is easily converted to VBA - works very well.

http://www.awprofessional.com/articles/article.asp?p=25175&rl=1

 

[Tim Williams]

I also seem to recall comparing the string builder class (see other post) with writing the info directly to a local file and the
file approach won hands down.