Macro to create report html with current date in filename

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?
 
S

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Folder names 1
path names 1
Export a table to text file with file name depending on certain da 12
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Access 2003 - Macro Output File with current date 2
Using macro to open report based on empty field. 1
Excel Monthly Spread sheet. 12

Top