Thread: Dates and Variables
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Michael$Lost[_2_] Michael$Lost[_2_] is offline
external usenet poster
  
Posts: 1
Default Dates and Variables
Yeah it doesn't like the double qoutes

"gocush" wrote:

did you try the double quote

objCmd(1) = ""10/25/2000""
or objCmd(1) = """&10/25/2000&"""



"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"

Reply With QuoteReply With Quote