cancel export

A

accessnps

I have been working on code that allows users to export a selected set of
data from a large database to an excel spreadsheet based on a number of
different parameters. I am using the Docmd.TransferSpreadsheet method to
accomplish the export. I have now been asked to include a cancel button
that would allow the user to cancel the export if it is taking too long. I
have searched around quite a bit but don't have any idea how to do this or if
it is even possible. Any ideas? Thanks.
 
Top