This article is valid for VBA as for VBS projects.
SCENARIO
I am trying to create a string in VBA and have it span multiple lines in the code. Is there a way to do this?
Here is what im trying to do:
Code
query = "INSERT INTO Users(...)" "VALUES(...." "....);
SOLUTION
The string continuation sequence is " & _" so:
query = "INSERT INTO Users(...)" & _ "VALUES(...." & _ "....);
...would work.
SOURCE | LINK | LANGUAGE | ENGLISH |