Export of a report as Snapshot or EXCEL-File

U

UG

Hi freaks,

I need some help for exporting a report into an EXCEL-sheet.

I've created a button on a form using the following code for Click-event:

....
stDocName = "MyReport"
MyFilter = .............................
DoCmd.OutputTo acOutputReport, stDocName, , , True
....

The report "MyReport" contains a filter activated in On-Open-event:

Me.filter = MyFilter
Me.FilterOn = True

This construction works without any problem when I select as Output Foramt
the snapshot dormat. When I select "Microfoft Excel 5-7" as output format the
file seems to be generated but it cannot be opened! The message EXCEL brings
up is "Cannot acces 'filename'".

Any hint or advice is very appreciated.

Thanks,
Ulrike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Individual Report to each Staff member 0
Output Snapshot format of Report to shared drive 2
Export report to Excel, Error message "Compile Error: Argument not 0
Exporting a Report to Excel 2
Export a report (without opening it) 1
Make a Snapshot File from an Excel Worksheet 0
Export report to excel ERROR - please help 3
How to convert a report to an excel spreadsheet? 0

Top