Hello,
I am trying to export data from a filtered Access form to Excel by clicking on a command button. I found a function written by Bob Larson to export data from a filtered Access form to Excel, but I am getting an error 438, "Object doesn't support this property or method."
My form's name is "frmReviewData" and my command button is: "cmdExport." The function name is "Send2Excel"
The code I have to call the Function on the OnClick event of the button is: Call Send2Excel(Forms!frmReviewData, "strSheetExport").
I have attached a document containing the function and a screen shot of my form. I am not experienced with VBA so the error is probably obvious to someone with experience.
Thank you for your help!
I am trying to export data from a filtered Access form to Excel by clicking on a command button. I found a function written by Bob Larson to export data from a filtered Access form to Excel, but I am getting an error 438, "Object doesn't support this property or method."
My form's name is "frmReviewData" and my command button is: "cmdExport." The function name is "Send2Excel"
The code I have to call the Function on the OnClick event of the button is: Call Send2Excel(Forms!frmReviewData, "strSheetExport").
I have attached a document containing the function and a screen shot of my form. I am not experienced with VBA so the error is probably obvious to someone with experience.
Thank you for your help!