I have a Export button which I wrote code behind and receiving this error after the Export was successful.....Any suggestions?
Private Sub Command562_Click()
On Error GoTo SubError
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "BeneficiaryRMD", "C:\Distro\Distro Processing\Exports\Exp_Beneficiary.xlsx"
MsgBox "File exported successfully", vbInformation + vbOKOnly, "Export Success"
MsgBox "Error Number:" & Err.Number & ": " & Err.Description, vbCritical + vbOKOnly, "An error occured"