http://biinsight.com/passing-parameters-to-a-sql-stored-procedure-from-powerpivot-dynamically-using-vba/
Dynamically Passing Parameters to a SQL Stored Procedure from PowerPivot Using VBA