If a procedure takes for example 3 parameters, then {CALL uspThreeParm (?,?,?)}

The procedure might look like this :

ALTER PROCEDURE uspThreeParm ( Parm1 int , Parm2 int , Parm3 datetime )

AS

....etc

WHERE...

LadyReader (10/9/2009)

---

I have a spreadsheet, created via .Net automation, and populated from a sproc, with one column left blank (the sproc supplies the column header). Now I need to continuously...

And well played also. Not one to give up easily however! You can set refresh every x minutes in Data Range properties (agreed can't do seconds). If it...

Maybe better to do the work on the SQL side? If not maybe you could establish a zone on the sheet that combines the results of the ,Net automation...

Indeed, I guess I just prefer to keep VBA out of the picture for security compliance where possible. You can wrap the view with a patameterized proc and call...

Yes, but without parameters. A View works just like a table. so the SQL could be as simple as SELECT * FROM [ViewName] in the MS query, or simpler still...

By using {Call [Proc Name] (?)} you can still use the native parameter handling without VBA code.