I have a query that I want to allow users to automatically export to Excel. I have a macro set up that uses the TransferSpreadsheet function and sets the path. However, I'd like to further automate it by using a unique name for each spreadsheet saved as I will have several users exporting files to the same folder.
I would like to have the user enter the name in a text box, such as Doe, John. This is simply entered on a form that is used to provide criteria for the queries that are run. Nothing from the form is written to any of the tables. Is there a way to pull the data in the unbound text box and use that as the file name. In my example, I'd like to see the file name be Doe, John.xls.
Any help is appreciated!