Cancelling OutputTo gets error message.

[juschuma]

I have the following command in my code:

DoCmd.OutputTo acOutputForm, , acFormatXLS

It allows me to export the forms data to Excel. A standard Microsoft window pops up with the directories, so I can save the file.

However, if I "Cancel" at that time, my original form returns an error message.

"Run Time error 2501 - The OutputTo action was cancelled"

Is there a way to error check this and prevent this message from occuring.

 

[SiJP]

Easy to put some error handling in here..:

On Error goto Click_Err_Handle

DoCmd.OutputTo acOutputForm, , acFormatXLS

Click_Err_Handle:
If Err.Number = 2501 Then
Exit Sub 'or function
Else
End If

HTH's

SImon