Use ADO with Parameters

I want to use ADO to pull a query into a spreadsheet. The problem I have is --- is it possible to pass parameters to that query via VBA? For example, with this query, It asks for a begin date and an end date. The begin date of course is Last Sunday, the end date is Saturday (02-26-2012 ---- 03-03-2012) Is there a way for me to pass those dates via ADO?

EDIT --- let me also add that the dates of course change, but the range is always from Sunday to Saturday.