General discussion

Locked

Create Excell file from Access Report

By dennisbv ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Create Excell file from Access Report

by mark.thomson In reply to Create Excell file from A ...

Have a look at the Outputto method of the Docmd object in the Access help

Collapse -

Create Excell file from Access Report

by dennisbv In reply to Create Excell file from A ...

Simple but thats what I wanted. Thanks alot.

Collapse -

Create Excell file from Access Report

by dennisbv In reply to Create Excell file from A ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums