How Macro export to EXCEL with different name for every run.

[amolin]

for example:

Macro will export to EXCEL with different name for every run.


For example, I would like code macro like this way:

DoCmd.TransferSpreadsheet acExport, 8, "A0020_ASSY_OPER_WIP_REPORT", "" "D:/ASSY_WIP_RPT_DH" & Hour(Now) & ".xls", False, ""

But it couldn't work, why?