Binding Excel to a custom MDX query supporting PivotTable filters

Chris Webb wrote this post: Binding an Excel table to the results of an MDX query. In a comment at the bottom, Scott Gall suggested using VBA. I want to take this one step further to allow custom MDX to be filtered by the filters from the Pivot Table Field List, while not actually using a pivot table (similarly to formulas mode).