File Operations using ScriptingRuntime
:
Return to List
' Requires a reference be set to Microsoft Scripting Runtime
library under Tools | Reference within the VBE
' Declarations
Set fs = CreateObject("Scripting.FileSystemObject")
' To copy folder
fs.CopyFolder "c:\test","c:\subbu\test"
' To move folder
fs.MoveFolder "c:\test","c:\subbu\test"
' To DeleteFile
fs.DeleteFile "c:\test.txt"
' To CreateFile
fs.CreateTextFile "c:\test.txt"
' To check for existence check return value (true if exists or false)
blnResult = fs.FileExists("c:\test.doc")
blnResult = fs.FolderExists("c:\subbu")
Note to Webmaster