Run-time 1004 - "=" within a string

[newtolivieri]

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

 

[Norie]

If all you ultimately need is the SQL then I don't see why you need the formulas.

You could just create the SQL strings in VBA and put them in the appropriate places.