I have a macro that is exporting records for a particular employee to an xls.
The default output filename is qryEmpItems.xls
Is there a way to have the macro append the employee name to the actual xls filename?
I'm looking for an end result such as qryEmpItems_EMPLOYEENAME.xls
Or better yet EMPLOYEENAME_Survey.xls
Not sure if this is a possibility.
Thanks!