Invalid Operation

[paulS30berks]

I am running a report from a form that is to produce an excel output:

Private Sub cmdTransferToExcel_Click()

On Error GoTo Err_CmdTransferToExcel_Click

Refresh

DoCmd.Hourglass True

DoCmd.OutputTo acOutputQuery, "Temps_Margin_Output", acFormatXLS, [Forms]![Revenue_Output]![output], False


Exit_CmdTransferToExcel_Click:
DoCmd.Hourglass False
MsgBox "File Created", vbOKOnly
Exit Sub

Err_CmdTransferToExcel_Click:
MsgBox Err.Description
Resume Exit_CmdTransferToExcel_Click

End Sub

but receive an error "Invalid Operation"

Can anyone suggest anything?

Thanks

 

[RuralGuy]

Try loading your OutputFile name into a string variable first and then using the string variable in your command.