[RESOLVED] VBA Save Access Report As SNP File Name With Current Date

[Khadafi]

Hi, i am using the following code in Access to store a report as a snapshot file, which works perfectly.

Dim stDocName As String
    stDocName = "My Report"
DoCmd.OutputTo acReport, stDocName, "SnapshotFormat(*.snp)", "C:\Documents and Settings\khadafi\My Documents\ReportFolder\MyReport.snp"

I would like to save the current date within the snp files name, or for a new folder to be created within the ReportFolder with the current date as its name.

Thanks For The Help In Advance.