Here is what I ended up doing to get this to work. It feels clunky, but it works:
In the macro that is creating the field list, I use ! instead of single quotes, then AFTER I pass the fields over to routine that is building the table I do a replace:
Let _fieldsFinal = Replace('$(_fields)', '!', chr(39)); //Build table from passed values [$(_tableName)]: LOAD $(_fieldsFinal) FROM $(_fileName) (txt, codepage is 1252, no labels, delimiter is '$(_delimiter)', header is $(headerLines) lines, msq);
If anyone has a better way, please let me know.