I need a QueryTable.Refresh solution
 

Hello,

Could someone give me a solution please for the next situation?

I have an excel worksheet where I got a ODBC connection to a SQL Server.
The query represents an execution of a stored procedure with parameters.

I've tried to use SQLOLEDB because this way I don't have to create for each
SQL Server a DSN connection like I do for ODBC connection (and this would
improve a lot excel use), but the Refresh doesn't work if the query string
contains parameters (run time error 1004).

What can I do?

Any idea will be appreciated.
Thanks in advance.

Regards,
Lucian Rosu