Analysis with Excel (1 Viewer)

[waxdart23]

I have some queries which I would like to export (analyze) in Excel. At the moment I do this by highlighting the query and clicking on the "Analyze it with Excel" button which then opens the data in Excel. However, I wish to let other people use the database and so wish to hide the database window.

Is there another was of opening a query in Excel (without having the database window open)? My queries also require the user to enter "Start Date" and "End Date" parameters that are part of the queries. I am using an Access 2000 format database in 2002.

 

[bradcccs]

Have you considered using the TransferSpreadsheet command.

eg:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "QueryName", "C:\Destination\FileName.xls"

This will create the spreadsheet in the relevant folder for analysis.

Once created, you would still need to open the spreadsheet, but as you have the determined filename, you could open the spreadsheet from code anyway.

HTH

Brad.

 

[waxdart23]

This is just what I was looking for. Thanks.