sladetroityer
Registered User.
- Local time
- Today, 11:39
- Joined
- Oct 26, 2011
- Messages
- 149
Access 2010.
I want to add a command button that exports my the data on my datasheet view Form to excel. The issue is that the data is filtered with macros. Below is VBA code that allows my reports to run off the filtered data, can I apply this same idea (me.filter) to the export to excel VBA code?
Private Sub cmdOpenHeadcountSummary_Click()
DoCmd.OpenReport "rptHeadcountSummary", acViewPreview, , Me.Filter
End Sub
Can someone show me how to write the code for export to excel utilizing the me.filter?
I want to add a command button that exports my the data on my datasheet view Form to excel. The issue is that the data is filtered with macros. Below is VBA code that allows my reports to run off the filtered data, can I apply this same idea (me.filter) to the export to excel VBA code?
Private Sub cmdOpenHeadcountSummary_Click()
DoCmd.OpenReport "rptHeadcountSummary", acViewPreview, , Me.Filter
End Sub
Can someone show me how to write the code for export to excel utilizing the me.filter?