Macro to create report html with current date in filename

Macro to create report html with current date in filename

Post by Brend » Thu, 22 Apr 2004 00:47:04


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?
 
 
 

Macro to create report html with current date in filename

Post by Steve Scha » Thu, 22 Apr 2004 03:50:16

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"

--
Steve Schapel, Microsoft Access MVP