Run-time error '2501'

Question

Hi,

I have a command button in Access 2007 that is supposed to save a report called "CycleReportFresh" as a pdf file in a specified directory under a specified name. It gives me the following error message:

Run-time error '2501': The OutputTo file action was canceled.

What is wrong with this code?

Private Sub Command193_Click()

DoCmd.OutputTo acOutputReport, "CycleReportFresh", acFormatPDF, "C:\My Documents\Work\P-Data\D-B\rptFoo.pdf"

End Sub

Thank you

Answer 1

DId you create that directory?  Because there is no *C:\My Documents...* on Windows 7 machines, it would C:\Users\YourComputersName\Documents\*

Answer 2

You're most welcome!

Answer 3

Thank you! You are absolutely right. I managed to get windows explorer show the path to the directory that could be pasted into the code and now it works like magic. Thank you again!