How do I get an SQL Server 7.0 Stored Procedure to use variables from a VB form in Excel? I want the variables to be used in a query. The form opens in Excel and prompts the user for a start and end date. I designed the form in Excel's VB Editor.

Does the SQL statement go in the actual VB procedure and then passed to SQL Server somehow, or can I just pass the variables through from VB to the SQL query?