In Excel 2003:

If you leave the ? in the call, it should prompt for a value. Enter a value to get a result set, then use the Send to Excel...

I just realized you said Excel 2007, which I've yet to use.

If you read this thread from the beginning, I believe you will find a satisfactory VBA-less method of...

Try this.

Dim prm As ADODB.Parameter

Dim cmd As New ADODB.Command

cmd.CommandType = adCmdStoredProc

cmd.CommandText = "dbo.proc_StoredProcedure"

Dim strParameterValue As String

strParameterValue = Sheet1.Range("A1").Value

Set prm = cmd.CreateParameter("@ParameterName", adVarChar, adParamInput, 50, strParameterValue)

cmd.Parameters.Append prm

If you use Command type...

I found a satisfactory method of refreshing pivot data based on parameters. Using the...

Swarm_Catcher (8/18/2008)

---

How do you eliminate carriage returns? I replaced a query with a stored procedure in MSQuery and get the same results, except for the additional carriage returns in...

I've found that the datatypes for the parameters are optional, and in my experience, this is with MSSQL Server 2005, the server handles the implicit conversions quite well.

I use Excel 2003 with stored procedures without involving VBA. The trick is to manually edit the .dqy file that MSQuery generates, or more accurately, just manually create the file...

That did it Christopher. I'd heard the term 'parameter sniffing' but I did not realize this is what it meant. It actually crossed my mind to try replacing the input...

Thanks Tim, that is the same answer we came up with. Actually glad we uninstalled both and came back with 2K5 as the default.