I have a report that is passed a where clause (a start and end date). I would like the user to be able to open this as a report or as an excel spreadsheet. I can open the report as a report using the following command
DoCmd.OpenReport stDocName, acViewPreview, , stWhere

I can open the report as as excel spreadsheet with the following command
DoCmd.OutputTo acReport, stDocName
But I do not know how to pass in the where clause.

What am I missing?