Batch file command to rename file to randomly chosen filename

[BlackieHamel]

This is only tangentially related to Excel. I have a batch file that runs Excel and opens the file temp.csv:

[FONT=arial]start[/FONT][FONT=arial] C:\Program" "Files\Microsoft" "Office" "15\root\office15\EXCEL.EXE "d:\downloads\temp.csv[/FONT]

This works fine, but sometimes I want to do this multiple times, and I get a filename collision if I try to run this batch command again. My workaround is to rename temp.csv while I'm in Excel. Sometimes I forget, though!

Can I add a batch file command to rename temp.csv to something random, such as a filename containing the current time, and then start Excel and open that file?

Thanks!

Blackie

 

[Joe4]

Here is one way to get date/time stamps and rename your file:

C:
CD\
FOR /F "TOKENS=2,3,4 DELIMS=/ " %%I IN ('DATE/T') DO SET D=%%K%%I%%J
FOR /F "TOKENS=1,2,3 DELIMS=: " %%I IN ('TIME/T') DO SET T=%%I%%J%%K

copy d:\downloads\temp.csv d:\downloads\temp_%d%%t%.csv
del d:\downloads\temp.csv

 

[BlackieHamel]

Here is one way to get date/time stamps and rename your file:

C:
CD\
FOR /F "TOKENS=2,3,4 DELIMS=/ " %%I IN ('DATE/T') DO SET D=%%K%%I%%J
FOR /F "TOKENS=1,2,3 DELIMS=: " %%I IN ('TIME/T') DO SET T=%%I%%J%%K

copy d:\downloads\temp.csv d:\downloads\temp_%d%%t%.csv
del d:\downloads\temp.csv

Thanks, Joe4! Exactly what I needed. Works like a charm.