Passing a string value from one module to another without quotes in VB in Excel 2010
Posted on 2014-07-15
I am trying to pass the following string to a module.
When defining the string it is requiring me to put quotes around it. However to use the string I do not want the quotes
I have this code to build it.
strInList = "('" & strInList & "')"
What do I do to be able to build the string and then use it, but without the quotes.
I want to my final result to be:
This string will be used in a query