transferspreadsheet File Name (1 Viewer)

sepefrio

New member
Local time
Today, 11:56
Joined
Jun 20, 2013
Messages
9
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!
 

boblarson

Smeghead
Local time
Today, 08:56
Joined
Jan 12, 2001
Messages
32,059
You can do it with VBA but not really with macros (if I remember correctly).
 

Users who are viewing this thread

Top Bottom