I am having trouble with my bat file. I am trying to add today's date to a file and then move the previous days file in another folder. Example:
Yesterdays file is in a folder, I want to run a script to move that and then run my access macro. Once that file is complete then rename the file adding today's date to the end of it. Or is there a way to add today's date to the end of the file name in access? Which ever is easier? Below is what I have:
move "G:\CLSINC\Provana Queries\Daily Letters\DantomPrevDay_*.*".xlsx" "G:\CLSINC\Provana Queries\Daily Letters\Older\
"C:\Program Files (x86)\Microsoft Office\Office12\MSACCESS.exe" "E:\CLS Queries\Provana Database.accdb" /x LettersDailyAudit
For /F "tokens=2,3,4 delims=/ " %%A in ('Date /t') do @(
Copy "G:\CLSINC\Provana Queries\Daily Letters\DantomPrevDay_.xlsx" "DantomPrevDay_!All!.xlsx"
Del "G:\CLSINC\Provana Queries\Daily Letters\DantomPrevDay_.xlsx"