Unanswered: Auto Save report with incremental Date
I have some reports I want to run auto save in an external folder everyday. I have created a macro to run the "OutPutTo" function and save the report as a snapshot (.snp) file. The issue is that it wants to always use the same name and overwrite the existing saved file. I need to get the filename to change automatically so it always creates a new file and doesnt prompt an overwrite msg box.. I would like the difference in file names to be the date at the front or end of the report name. Can anyone show me the code to get this to work??
I Also need to macro to run based on an active timer I have set up.
I have a form called FORM1 that auto opens up a timer with the active date and time. In that form in properties the "on Timer" i want the command to run the macro I created. Can you also help with this code??
Changing the report name on open should work but the Me.Caption code you provided above is not working for me. Can you give me an example on how it should be too look like the name below and have only the date change?