OutputTo Macro Include today's date

[Lorlai]

I have a Report that I am saving as a pdf. This is a report that will be saved every week, and I would like for the file to be saved as "WeeklyReport" + today's date. For example, today the report file name would be "WeeklyReport9-22.pdf". I am uncertain how to do this as in the OutputTo Macro, the Output file line seems to only contain strong quotes, so every word written in that line is saved.



How can I make my file be saved with today's date?

Thank you!

[boblarson]

If you use VBA instead, you can concatenate in the name so you could use

Dim strFile As String

strFile = "WeeklyReport" & Format(Date(), "m-dd") & ".pdf"

and then you can use strFile in the place where the file name is in the DoCmd.OutputTo command.

[Lorlai]

Thank you again Bob, you are always such a great help!