View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.scripting.vbscript,microsoft.public.scripting.wsh
D.P. Roberts D.P. Roberts is offline
external usenet poster
 
Posts: 8
Default How to delete rows in a csv file?

I have a vbscript that appends data to a csv file on a daily basis. When new
data gets appended to the bottom rows of the file, I'd like the oldest data
in the top rows to be deleted. Does anyone know how I can delete the top 3
rows every time the file gets appended? Here's what I've got so far:

Set WshNetwork = WScript.CreateObject("WScript.Network")
Set fsoOut = CreateObject("scripting.filesystemobject")
Set outFile = fsoOut.OpenTextFile("MyFile.csv", ForAppending, True)

<<<Here's where I want to delete rows 1-3 in the csv file

outFile.writeline (Now & "," & DataValue)
outFile.close


Thanks for any help on this...