Macro to create report html with current date in filename

  • Thread starter Thread starter Brenda
  • Start date Start date
B

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?
 
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"
 
Back
Top