Print til pdf og excel i 2007?

DoCmd.OutputTo acOutputReport, "reportNameGoesHere", acFormatPDF, "C:\SomePath\test.pdf"

You may need to install http://www.microsoft.com/downloads/details.aspx?FamilyID=f1fc413c-6d89-4f15-991b-63b07ba5f2e5&displaylang=en

to save as PDF

OK and thanks.

But when I have installed this?

And how should the code be for creating the pdf and for exporting to excel?

To open the report inthe program which can read PDF (Acrobat) for example then just add True to the end of teh previous example.

DoCmd.OutputTo acOutputReport, "reportNameGoesHere", acFormatPDF, "C:\SomePath\test.pdf", True

To export a report to Excel

DoCmd.OutputTo acOutputReport, "rpt1", acFormatXLS, "C:\Test.xls" , True

Thanks, I will try :o)

Terry, vil du lægge et svar ud så jeg kan lukke tråden?

Here it is