Newbie at mixing ADO and Excel
Bryan,
What does it do instead of work?
Tim.
"Bryan Dickerson" wrote in message
...
Thanks!
Now, I have to confess that I *thought* I could do the ADO part, but I've
previously only worked with straight query text that is passed to the
server. This time I'm having to call a stored procedure as I indicated
below and I'm not having much luck. The SP has 3 parameters. Can you
help
or do I need to take this to another NG?
This is what I currently have:
------------------------------
oCmd.CommandType = adCmdText
oCmd.CommandText = "EXEC SP_Report '" & _
CustomerNumber & "', '"
&
_
StartDate & "', '" &
EndDate & "'"
Set oRSet = oCmd.Execute
------------------------------
... it's not working. Any ideas?
TIA!
|