How do I use Date Functions for File Names in Access

K

Kevin Warrington

I am trying to create an OutPutTo Excel file using a date function to name
the output file. Basically I need to be able to name the output file using
the current date and time or use the current date with an incrementing number
for each file generated for that date.
 
K

Ken Snell [MVP]

Use an expression similar to this in the argument for the filename:

="C:\MyFolder\FileName" & Format(Date(), "mmddyyyy") & ".xls"
 

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

Countdown macro - display settings 2
Display weeks from a Milestone 0
Excel - Wich Function should I use? 1
Insert name and adress from a list in a word document 1
Automation of scanned file storage based on content 0
Autonumber field in Excel that behaves the same as Access 0
Synchronization problems while moving folders to new email 1
Copy previous record into form field 0

Top