Export to PPT, Excel, PDF, Word

[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

 

[Guest]

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