Michael$Lost wrote:
I'm trying to hit a stored procedure in SQL but I'm getting an error
when I'm
passing anything that needs the quotes " " for SQL.

How do I pass the quotes in a variable?

I'm sure it's amazingly simple but I'm lost.
objCmd(1) = "10/25/2000"

Instead of double quotes Chr$(34), try single quotes Chr$(39), which is
ANSI standard syntax. BTW if your column is a temporal data type (e.g.
DATETIME), try using an unambiguous date format e.g.

objCmd(1) = Chr$(39) & "2000-10-25" & Chr$(39)

Note your product may have a different 'date delimiter' e.g. MS Access
uses the hash character Chr$(39).

Jamie.

--