run SQL stored procedure from Excel

[monadel2]

Hi,

I need to run a SQL Server 2005 stored procedure by pressing a command button in excel 2003 (VisualBasic 6.3).

Searched and tried many solutions here and in other web resources, read about opening the datasource, but I cannot find the exact solution for my problem.

Any help would be greatly appreciated,

Thanks

[Penio]

You can assigned the following Sub to a button :


-------------------------------------------
Sub ExecuteStoredProcedure()

Dim Chan As Variant

'Open a channel to a SQL Server data source
Chan = SQLOpen("DSN=SQLServer")

'Execute the stored procedure "sp_who" and return the
'results to the activecell on the active sheet.
SQLExecQuery Chan, "Execute sp_who"

SQLRetrieve Chan, ActiveCell

'Terminate the channel
SQLClose Chan

End Sub

--------------------------------------------------------------

More info for SQL - Excel connection on:

Macro Examples Using XLODBC Functions

Cheers
Penio