Publish a report to excel?

Prev: Keep Data together in a Report
Next: A Year to Date Report Question

From: a_ryan1972 on 19 Mar 2010 17:45

---

This is exactly what I need to do, but I don't understand where to insert
this code.

Please help.

Thank you.

"mike_mike" wrote:

> ur a legend! I couldn't remember the command!
>
> "Baffee" wrote:
>
> > Try using:
> >
> > DoCmd.OutputTo acReport, "Acess ReportName", acFormatXLS, "Path/FileName.xls"
> > This will save it as an excel file with the name you enteted in the path you
> > specified..
> >
> > If you want to save it and fire up Excel use:
> > DoCmd.OutputTo acReport, "Acess ReportName", acFormatXLS,
> > "Path/FileName.xls",True
> >
> > "mike_mike" wrote:
> >
> > > HI is it possible to publish a report to excel,
> > >
> > > without showing the preview window ?
> > >
> > >
> > > currently i go
> > >
> > > DoCmd.OpenReport report, acPreview, ,

From: PieterLinden via AccessMonster.com on 19 Mar 2010 19:28

---

a_ryan1972 wrote:
>This is exactly what I need to do, but I don't understand where to insert
>this code.
>
>Please help.

The click event of a button...

--
Message posted via http://www.accessmonster.com

 | 
Pages: 1
Prev: Keep Data together in a Report
Next: A Year to Date Report Question