Output To

[Phyllis King]

I am using an Output To macro to export the results of a
query to an excel file and storing the excel file on a
server. How do I append the system date/time to the file
named in the Output file parameter? The system date/time
should represent the time that the file was created.

Thanks.

 

[Steve Schapel]

Phyllis,

An addaptation of the below as applicable...
="M:\ExcelSheets\YourFile" & Format(Now(),"yymmddhhnn") & ".xls"

 

[pking]

Steve,

Thanks so much for the help. It worked like a charm!!.

Phyllis