Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming,microsoft.public.scripting.vbscript,microsoft.public.scripting.wsh
|
|||
|
|||
![]()
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trying to delete blank rows after file save | Excel Discussion (Misc queries) | |||
How to delete alternating BLANK rows in .xls file all @ once? | Excel Discussion (Misc queries) | |||
How delete to end of file; comp keeps adding rows; over 3000! | Excel Worksheet Functions | |||
Delete some rows at the end of the file | Excel Programming | |||
Delete rows in Excel file with macros | Excel Programming |