I know that I can click analyze in Excell from the Access tool bar, but what I am trying to do is to create a Excel workbook from an Access Query or Report. If I use the Export Excell function I can only insert the sheet in a Named WorkBook. I want to be able to create a Workbook with the name created by user selections. Now the user enters a BeginDate and an EndDate as criteria in the query. I want the file name to be “BeginDate-EndDate Report”.xls All of this needs to happen from Access.
