This program is a GUI where you can paste/type text into an editor, and get a valid VBA string literal as output.
I made an Excel macro to fetch rows from a database. I just wanted to hardcode the query to save some time. But, the SQL statement was about 80 lines long, and I found out that Visual Basic has a few limitations that impact string literals.
myStr = "line 1" & _ "line 2" & _ ... "line 100"
myStr = "line 1" & _ "line 2" & _ ... "line 25" myStr = myStr & "line 26" & _ ... "line 100"
The text2vbastring tool handles both of these limitations automatically: all you need to do is paste and/or type text into the text box, then copy and paste the output directly into the Excel VBA editor!