Excel Export Naming Convention

[Dirtrider929]

I would like to add the "Month" of the information queried to my file name at export if possible. I included my current code and an example of how I would like the title to read.

DoCmd.TransferSpreadsheet acExport, 10, "tblStarzIncentivePayoutExport", "C:\StarzExports\Incentive Payouts" & " " & "Ran" & " " & Format(Date, "mm-dd-yyyy")

I would like the file to be named:

Incentive Payouts "Month out of the date ran in the query" Ran 06/08/2015

Is it possible to do?

 

[pr2-eugin]

It is not Excel formatting, it is Windows Naming conventions. As per the name space convention windows does not allow certain characters to be a part of a file or folder name one of them is /.

So the answer to your question Is it possible to do? is No, you cannot. mm-dd-yyyy is possible not mm/dd/yyyy.