Tying to export data to an Excel spreadsheet and it's works with no problem. But what I would like to add is a specific name in the .xlsx file name. I have a table with a single field and a single record with a name in it. I use this for other functions when running the DB. I would also like the exported .xlsx file name to consist of the contents of the field.
Table being Exported to Excel: tblPersFile
Table that has the Naming info: tblFileName
Filed Name: FileName
Example: Tampa2012
Thus once completed, I would like my Excel file to be named Tampa2012.xlxs
Note, this DB is used as a middleware to prep data for other uses. As such, I'll be running dozens of files through it per week and each one will need a different file name. I know I can just rename the Excel File after it's exported, but if I can automate it, that would be awesome. BTW, the file name comes from a user prompt when the initial file is first imported to the DB. Thanks!
Table being Exported to Excel: tblPersFile
Table that has the Naming info: tblFileName
Filed Name: FileName
Example: Tampa2012
Thus once completed, I would like my Excel file to be named Tampa2012.xlxs
Note, this DB is used as a middleware to prep data for other uses. As such, I'll be running dozens of files through it per week and each one will need a different file name. I know I can just rename the Excel File after it's exported, but if I can automate it, that would be awesome. BTW, the file name comes from a user prompt when the initial file is first imported to the DB. Thanks!