Kind of new to VBA in Access.
I was able to export a table into excel however I need the original excel workbook closed before the export.
Why wouldn't the following command work before the export:
Workbook(filename).Close
If not is there a subroutine I should create?
Thanks