Automate Export to Excel upon Close of Database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am wondering if there is a way to automate the export of Access
information, in this case Form information to an excel sheet automatically
when Access is closed or updated.

The problem is we have users who are not remeber to export the data each
time they update it. We have another piece of software which references and
links to information in that excel file.

Is there a way to automate this process so whenver the user closes Access or
saves that the export to excel is automatically completed without them
remeber how to do it?
 
You need a form that opens when you open the application and stays open until
you close the application. It can be hidden. Put the TransferSpreadsheet
code in that form's UnLoad event.
 
Back
Top