Darren DICK
darrend at nimble.com.au
Tue Oct 24 09:02:55 CDT 2006
Further to my last Does anyone have any code that will remove the first line in an Excel doc but from Access? Many thanks again in advance Darren _____ From: Darren DICK [mailto:darrend at nimble.com.au] Sent: Tuesday, 24 October 2006 11:55 PM To: 'Access Developers discussion and problem solving' Subject: A2003:Rename a file in a folder Hi all I have a file that will be always named the same - EG myCoolCSVfile.csv It will be dumped into a folder...say C:\MyCoolFolder at random times I need some code to Check the C:\myCoolFolder to see if the file myCoolCSVfile.csv file exists in the folder - and if it does to rename it to YYMMDDHHMMSS.csv Where YY = Year MM = Month DD = Day etc etc Does anyone have anything that might suit? Many thanks in advance Darren