Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to export the report to excel file?
- Thread starter cin2002
- Start date
trueharted
Programmer
cin2002,
In the On_Click event of a command button, using the Expression Builder add the following code, replacing ReportName and FullPath:
DoCmd.OutputTo acReport, "ReportName", "MicrosoftExcel(*.xls)", "FullPath", False, ""
In the On_Click event of a command button, using the Expression Builder add the following code, replacing ReportName and FullPath:
DoCmd.OutputTo acReport, "ReportName", "MicrosoftExcel(*.xls)", "FullPath", False, ""
- Status
Similar threads
