Output To

  • Thread starter Thread starter Phyllis King
  • Start date Start date
P

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.
 
Phyllis,

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