Average 28000 requests/month












 

This is a collection of VBScripts to deal with files 


' CREATE FOLDER
Dim fso, fldr
Set fso = CreateObject("Scripting.FileSystemObject")
Set fldr = fso.CreateFolder("C:\MyTest")

' CREATE NEW FILE AND WRITE TO IT
Dim fso, tf
Set fso = CreateObject("Scripting.FileSystemObject") 
Set tf = fso.CreateTextFile("c:\testfile.txt", True) 
tf.WriteLine("This is a test.") 
tf.Close

' OPEN EXISTING FILE AND WRITE TO IT AT THE END
Dim fso, tf
Const ForReading = 1, ForWriting = 2, ForAppending = 3 
Set fso = CreateObject("Scripting. FileSystemObject")
Set tf = fso.OpenTextFile("c:\test.txt", ForAppending, True)
tf.WriteLine("Testing 1, 2, 3.") 
tf.WriteBlankLines(3) 
tf.Write ("This is a test.") 
tf.Close

' OPEN EXISTING FILE AND OVERWRITE THE CONTENTS
Dim fso, tf
Const ForReading = 1, ForWriting = 2, ForAppending = 3 
Set fso = CreateObject("Scripting. FileSystemObject")
Set tf = fso.OpenTextFile("c:\test.txt", ForWriting, True)
tf.WriteLine("Testing 1, 2, 3.") 
tf.WriteBlankLines(3) 
tf.Write ("This is a test.") 
tf.Close

' OPEN EXISTING FILE AND READ FROM IT
Dim fso, tf
Const ForReading = 1, ForWriting = 2, ForAppending = 3 
Set tf = fso.OpenTextFile("c:\testfile.txt", ForReading)
s = tf.ReadLine
'OR s = tf.ReadAll
tf.Close

' MOVE FILE TO D:
Dim fso, tf
Set fso = CreateObject("Scripting.FileSystemObject")
Set tf = fso.GetFile("c:\testfile.txt")
tf.Move ("d:\testfile.txt")

' COPY FILE TO D:
Dim fso, tf
Set fso = CreateObject("Scripting.FileSystemObject")
Set tf = fso.GetFile("c:\testfile.txt")
tf.Copy ("D:\testfile.txt")

' DELETE FILE 
Dim fso, tf
Set fso = CreateObject("Scripting.FileSystemObject")
Set tf = fso.GetFile("c:\testfile.txt")
tf.Delete
'OR if fso.FileExists("c:\testfile.txt") then fso.DeleteFile("c:\testfile.txt")

' REMOVE 'OLD' XML FILES
dim fso, fldr, tf, oFiles
set fso = CreateObject("Scripting.FileSystemObject")
Set fldr = fso.getfolder("\\cisliveww30\AllnewsfeedsTmp")
Set oFiles = fldr.Files
For Each tf In oFiles
  If fso.GetExtensionName(fi.Name) = "xml" Then
    If DateDiff("h",tf.DateCreated,now()) > 7 Then
      tf.Delete
  End If
End If
Next

 
 

July 2005