Export Access Report to Excel-97 including Header / Footer and UDF
I need to regularly export a report created using Access Reports on Access-2000 database to XLS format. I can do it using the menu but the exported file does not contain the footer I desire. I want to automate the same at the click of a button of by executing a code so that report is exported to XLS file including its Headers / Footers and a few blank fields.
Can anybody guide me in the matter. Please guide me using step-by-step process.