Macro "Output File" name

T

TotallyConfused

I hope this can be done. I have a macro that outputs a copy of a table to
excel. I would like to have a datestamp on the file name. I would like the
date stamp to be added either when I copy the table or when saving. I want
this to be done automatically. Thank you
 
K

Ken Snell \(MVP\)

Use as expression for the File Name argument of the macro:

="C:\MyFolder\MyFileName" & 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

Output to macro action 1
Output File Naming 8
Output to : Template file 3
file name for output to macro 2
help VBA code in macro 2
Can output file name from access query-create table include date . 1
Export table to txt file with a variable filename 0
output to text 3

Top