Automatic naming of a file used with TransferText macro

[Ju]

I am exporting the content of a table to a file. I'd like to have the file automatically named 27ddmmyyyy where ddmmyyyy is the date of the day.<br><br>Thank you.

 

[rochelle]

Look up TransferText in Help for assistance with each of the parameters.&nbsp;&nbsp;In general, your visual basic code should look like:<br><br>DoCmd.TransferText acExportDelim, specificationName, _<br> tblName, &quot;27&quot; & Format$(Date(),&quot;ddmmyyyy&quot<br><br>

 

[Ju]

MMhhh....I have a little problem....<br>Actually, where should I place it?<br><br>Thanks.

 

[rochelle]

This line should be part of a function or sub that is executed at the point that you are ready to export the file.&nbsp;&nbsp;For example, you could create a button in a form that calls this function.