newtolivieri
New Member
- Joined
- Mar 19, 2010
- Messages
- 13
Hi all,
First post here.
I'm getting '1004' on this instruction: Selection.Formula = ConcFormula
ConcFormula is a String which has: =CONCATENATE("(select ";$B$6;" from ";$B$2;" where ";$B$3;" = ";"'";$B$4;"' AND ";$C$3;" = ";"'";$C$4;"'";")")
The desired result is an SQL Select statement.
At first, I thought the error was with the double quotes with the string while composing the contents, so I used a bunch of "chr(34)" in the code, but it turns out the problem, at least now, is with the '=' character within the string, for when I remove it, it doesn't give me '1004'.
Thanks,
Newton
First post here.
I'm getting '1004' on this instruction: Selection.Formula = ConcFormula
ConcFormula is a String which has: =CONCATENATE("(select ";$B$6;" from ";$B$2;" where ";$B$3;" = ";"'";$B$4;"' AND ";$C$3;" = ";"'";$C$4;"'";")")
The desired result is an SQL Select statement.
At first, I thought the error was with the double quotes with the string while composing the contents, so I used a bunch of "chr(34)" in the code, but it turns out the problem, at least now, is with the '=' character within the string, for when I remove it, it doesn't give me '1004'.
Thanks,
Newton