Is there any C-style string formatting in VBA?

Question

I would like to use C-style string formatting in VBA to make it easier to send SQL instructions the same way I do in Python.

Is there anything similar?

sql = "INSERT INTO customers (name, address) VALUES (%s, %s)"
val = ("John", "Highway 21")
mycursor.execute(sql, val)

Thank you,

I found this, it helped me https://stackoverflow.com/questions/17233701/is-there-an-equivalent-of-printf-or-string-format-in-excel — Marcelo Gazzola, Aug 12 '19 at 08:10
In that case it's a good option to answer your own question, or to close this question — Tim Stack, Aug 12 '19 at 08:13

score 1 · Accepted Answer · answered Aug 12 '19 at 09:29

You can use a System.Text.StringBuilder like this:

Function FormatString(Text As String, ParamArray Args() As Variant) As String
    Dim values()
    Dim n As Long
    ReDim values(UBound(Args))

    For n = 0 To UBound(Args)
        values(n) = Args(n)
    Next

    With CreateObject("System.Text.StringBuilder")
        .AppendFormat_4 Text, values
        FormatString = .toString
    End With
End Function

Test

You can find a class that I wrote to wrap the System.Text.StringBuilder here: Bringing The System.Text.StringBuilder Up To Lightning Speed In The VBA.

score 0 · Answer 2 · answered Aug 12 '19 at 15:03

I found this, it helped me, is a similar way:

Is there an equivalent of printf or String.Format in Excel

Public Function printf(mask As String, ParamArray tokens()) as String

    Dim i as Long
    For i = 0 To Ubound(tokens)
        mask = replace$(mask, "{" & i & "}", tokens(i))
    Next

    printf = mask

End Function

myString = printf("Some text '{0}', more text: '{1}'", A1, A2)

Is there any C-style string formatting in VBA?

2 Answers2

Test