[AccessD] A2003:Remove first line in CSV/Excel file

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



More information about the AccessD mailing list