Hello,
I have a big SQL Code which does not fit in one line in Excel VBA. When I try to insert it, the Microsoft Basic Visual Editor automatically moves down by one line the code and put an "" at the end of the first line.
Example, lets say here is my SQL code, which is big, but I will put a sample:
sSQL = "SELECT ... "
When I try to add the rest of the code it automatically moves down to below line, does not allow me to continue, as the "" is automatically inserted at the end. Is there a way to prevent this from happening? Maybe concatenating the SQL code? how should I do that?
Here is my code, if needed, but I do not think it will be needed:
Please Login or Register to view this content.
Bookmarks