Macro to create report html with current date in filename

[Brenda]

We need to generate a report html every day
automatically. The same report, but have it write the
filename out as:

OrderStatusMMDDYY.html


We don't want the user to have to enter it in...how can we
do this?

 

[Steve Schapel]

Brenda,

I guess you are using an OutputTo macro for this? In the Output File
argument of the macro, put the equivalent of...
="C:\YourFolder\OrderStatus" & Format(Date(),"mmddyy") & ".html"