Export to PPT, Excel, PDF, Word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi -

I have some reports that I would like to know how to write a VBA code so
that when I push a command button. It would export my report into
PPT,XLS,PDF,DOC format.

Any references?
Thanks
 
Hi Leo,

The command you will need is DoCmd.OutputTo
There you can specify the file formats Excel, RTF (-> Word), HTML and TXT.

To export to PDF and PPT : not sure how to do, usually PDF via Acrobat
Destiller (or similar software) works via the print function, therefore you
will have to program something like 'print to file'.
PPT file format is not supported by Access, you will need use one of the
above and import this into Powerpoint.

HTH
Bernd
 
Back
Top