add date to file name

[Johnny Drama]

Hi all,

I'm using the following code to dump a report into an excel spreadsheet:

DoCmd.OutputTo acOutputReport, "rptPBC Query", acFormatXLS, "I:\pbcdump.xls", True

Since the report gets run multiple times I was wondering if there is a way to insert a time stamp as part fo the file name so previous files don't get overwritten.

Is this possible and if so, how?

Thanks in advance

 

[mdlueck]

I use this code to insert the datecode into the complete path\filename using the following LOC:

  'Finally arrive at the full filespec for our LogFilename
  strLogFilename = strLogDir & [B]Format(Date, "yyyymmdd")[/B] & ".JDEFandangoReplicateErrors.log"

The bold piece is where the date comes into the string.

 

[Johnny Drama]

works like a champ. Thanks!

 

[mdlueck]

Glad I was able to be of assistance, Johnny. Thank you for your followup post.