I have the following code which fires upon pressing a Command Button:
Sub SendRPT
DoCmd.SendObject acReport, "rpt_RPT", _
"MicrosoftExcel(*.xls)", eRPT, "", "", Date & _
" Report 1 ", "Attached is the report you requested.", False, ""
End Sub
Works fine on my machine, but when another user presses the same button, they get the following error message:
"The format in which you are attempting to output the current object is not available."
I am still running Excel 2000, while the other user is running Excel 2002. Could that have something to do with it and what do I need to do to fix this (aside from upgradiing)?
Any help would be welcome.
Sub SendRPT
DoCmd.SendObject acReport, "rpt_RPT", _
"MicrosoftExcel(*.xls)", eRPT, "", "", Date & _
" Report 1 ", "Attached is the report you requested.", False, ""
End Sub
Works fine on my machine, but when another user presses the same button, they get the following error message:
"The format in which you are attempting to output the current object is not available."
I am still running Excel 2000, while the other user is running Excel 2002. Could that have something to do with it and what do I need to do to fix this (aside from upgradiing)?
Any help would be welcome.