I am attempting to use a macro to output a table in .csv format to a server each day. The macro has the ability to run each day but always saves under that same name. Is there a way to get a unique file name for each day it runs such as ..... File, File 1, File 2.
Or even better File 09/25/06, File 09/26/06 etc....
Thank you anyone for help!!